- 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.
The circulation history is stored in table Z36H (Historical Loans).
You can activate or de-active the history function by setting variable
!# 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 :1825
Enter loop count :
Subject: Loans (500) - ALEPH
- Article last edited: 12/30/2014