This is an old revision of the document!
SFX Update Procedures
ExLibris updates the Knowledgebase [KB] data as well as various software files and some of the manuals each week. Notice of the time and date of the update is sent to asp1 Listserv subscribers.
Help with SFX terms is available at this SFX glossary.
Tips and Notes
As hosted customers, our update is applied a week later than the current update. Check applicable software changes, new and removed targets, and other changes in SFX. Target name changes affect Menu Display logic and need to be changed in sort_services_config (eventually).
Update Release Notes for coming update can be checked for upcoming target deletions. Be sure they are deactivated, with object portfolios moved. Check for upcoming changes to targets. Export any target active portfolios that might be affected (e.g. previous titles that might be lost).
KB Update Reports are obtainable from SFX Admin>KBUpdate. Setting to “Yes” is supposed to retrieve only UMass active targets but does include UMass formerly-active targets, designated “Inactive”.
Weekly maintenance
Clean sessions subdirectory. This terminates live sessions so best to do in quiet times.
Login UNIX-side.
ds
cd sessions
rm cgisess_* (if done regularly, there is no need to breakdown with numbers and letters, e.g. rm cgisess_0* and rm cgisess_a*)
(To exit without checking stats) da, exit
Check Stats tables. Unix-side. da>./server_admin_util>5=Statistics>4=Show stats table monitor information>exit
Offline table limit is 1,000,000. Check for unusually high number in Online table.
Statistics are automatically moved from the online to offline file within a few days.
Statistics files are being archived by ExLibris 1-2 months after the beginning of the calendar and fiscal years, leaving at least 12 months in the offline file (as of 2016).
Check outstanding SFX support cases.
Monthly maintenance
Scratch directory cleanout
Web side: SFX KBManager>UNIX File Manager>dbs>scratch
DO NOT DELETE: Sessions Directory! Recent e_collection and MARCit files! Institutional holdings file (Google Scholar/WorldCat holdings)! Leave several months in scratch folder.
Export directory cleanout (this seems to be automatically cleaned out, 2016).
bX Statistics file cleanout
Other Maintenance
Cron jobs: These are presently running as scheduled jobs see:
sfx_cron_jobs
Table repair
Google/OCLC WorldCat Local holdings export
AZ and RSI Index build
Clearing SFX_REQUEST table
Clearing SFX logs. This is currently set up as a cron job. If it becomes necessary to do manually, it should be done every few weeks.
Statistics queries are run as cron jobs: Query 2(top 100),3,4,5,6,8,10(top 100),11(top 100),12(top 100). Calendar and FY statistics should includ 14(top 100) & 19(top 100) as well.
Primary contact: Catherine Knapp