• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
We ran p_item_06 yesterday and I notice that we got a "bonus" of about 2.4 million additional records in our z30h table. It seems like a program like this which touches every record could be exempted from storing information in this history table. Or, at the least, there might be documentation in the help file for p_item_06 or somewhere warning that this might happen. This is an excessive addition of space in our database and could have easily caused unexpected problems.

I'm not overly interested in keeping these z30h entries around. Is there any good way to determine which ones were created from p_item_06 vs. being created in some other manner, so that I can delete them via SQL? I could probably go by time frame, but that might get a few that were legitimate changes that I would want to store.

Resolution:
In order to prevent p_item_06 from updating the z30h, you can change the "ALL-FIELDS” line in ./abc50/tab/tab_item_history.eng to "ALL-NON-CIRC " line. See KB 5845,

To delete z30h records produced by p_item_06, delete records with a z30h_h_reason of "Other" (or “All fields”) and a z30_h_cataloger of "BATCH".

• Article last edited: 10/8/2013