Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Performance and circulation logger (Z309)

    Performance and circulation logger (Z309)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    Circulation activities are slow for some of patrons. What can be the cause of this?

    Answer

    Ex Libris has noticed that circulation activities (especially return) become slow in cases there are lot of Z309-records in the database. Z309 is storing the circulation log entries.

    SP 20.2.3 (May 2011) includes rep_change #3436 that improves performance when lot of Z309-records exist.

    Even after installation of this fix we recommend to try to reduce the number of Z309-records as much as possible to improve performance:

    - If not needed in your usual circulation workflow, you may deactivate logger creation for specific circulation activities. To do so, set col. 2 of tab_circ_log.<lng> to N for the specific activity.

    - You should clean up old Z309-entries (e.g. all log-entries that are older than one year) regularly using service p_cir_78. Please note that also in p_cir_78 there were performance problems when huge number of z309-entries exist. This performance problem is corrected by rep_change #3437 (SP 20.2.3 - May 2011). Please note that you should follow Implementation Notes of rep_change #3437 to create z309_id6 after installing this rep_change as otherwise performance will not be improved.

    Category: Circulation (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Perform OPAC search on multiple ALEPH DATABASES
      • Performance problem with publish-04
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Circulation (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved