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

  • Update Release Notes can be found at the ExLibris Knowledge Center: http://knowledge.exlibrisgroup.com/SFX/Release_Notes/Version_4.0 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”.
    • HTML Report. Check Deleted and Updated “Targets, Target Services, Sources, Source Services” and “Linking Parameters”. Test linking.
    • Text Report. Important: Set to “Yes” and check Deleted Object Portfolios for possible previous title and other deletions in ejournal packages (ExLibris does delete our active object portfolios occasionally). Disregard databases with fluid content.

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*)
    • 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).
    • Web side: SFX KBManager>Admin>Unix File Manager>Export
  • bX Statistics file cleanout
    • After notification that a successful harvest has occurred, clean the OAI_REPOSITORY table.
      • da, ./server_admin_util
      • 5=Statistics
      • 9=Clean OAI_REPOSITORY table
      • 1=Delete all OAI_REPOSITORY table records
      • y=erase all records in table OAI_REPOSITORY
      • q, exit

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.
      • Login>da>./server_admin_util menu>2=Filesystem Maintenance>4=Clean /exlibris…umass/logs>N=Prompt for removal of each file?
    • 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

sfx_update_procedures.txt · Last modified: 2016/09/20 14:57 by cknapp
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0