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. Z309 - Best practices on retention

    Z309 - Best practices on retention

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

    Question

    Do you have any recommendations regarding the z309 table and how often or to what extent it should be either maintained or regularly purged?
    Which "best practices" which you would suggest?

    Answer

    You need to keep the z309 records only as long as you think you might need additional info for this time period for a particular patron in the "Circulation Log" in the GUI Patron Activity tree or from the Circ Logger report (cir-21) or your own SQL which you might run against the table.  Note that, as described in the article "Limit to number of Circulation Log / z309 records displayed in GUI", only about 64,000 z309 records will display for a patron in the GUI.

    Aleph doesn't require or use the z309 records in any other way.


    The Circulation Logger Clean Up service (cir-78) deletes z309 records older than a particular date.

    Additional Information

    Extract from help file of service Circulation Logger Clean Up (cir-78)
    "This service cleans up the circulation logger. All log events that are older than the input date will be deleted, if the transaction that they belong to is closed.
    This means that loan related events will be deleted only if the loan has been returned or deleted. Cash related events will be deleted only if the transaction has been fully paid."

    Category: Circulation (500)


    • Article last edited: 01/13/2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • z308-verification is human readable in overdue-summary - how to suppress the information?
      • Z309 ... table or view does not exist
    • 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