Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Is it possible to backup/archive circulation history regularly?

    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 21


    Is it possible to backup circulation history regularly?


    No, you cannot backup/archive the circulation history.

    Additional Information

    The circulation history is stored in table Z36H (Historical Loans).

    You can activate or de-active the history function by setting variable


    !# CREATE-Z36H
    !# Values:Y N Default: Y
    !# Type: Text; Max Length: 01
    !# tab100 of library: Yes; tab100_<server_type>: No.
    ! Y = transfer completed loan records to a history file

    That means, if the parameter is set to 'Y', the history will be created.

    Starting with Minor release Aleph 22.1 (rep_change #2020) you have the option to delete historical data up to a specific date / Number of days.

    Clean Events and Historic Information tables - util_x_13

    Please select one of the following tables to cleanup

    1. Z35 (Events table)
    2. Z69 (OPAC events)
    3. Z30H (Item history)
    4. Z36H (Loan history)
    5. Z37H (Requests history)
    6. Z38H (Photocopy history)

    Enter your selection or q to quit:

    Enter your selection or q to quit: 4

    Before cleaning Z36H table of USM50, verify that all the
    Aleph Servers, BatchQueues and Daemons of USM50 are down

    Enter number of days back to retain [100]:1825
    Enter loop count [1000]:

    Category: Circulation/ALEPH

    Subject: Loans (500) - ALEPH

    • Article last edited: 12/30/2014