- Article Type: General
- Product: Aleph
- Product Version: 18.01
I've been reviewing the z73 table which is a new log of MARCIVE and OCLC loader information. I'm unclear on the purpose for this table. Were there previously no logs for these activities, or just no logs to a database table? What drove the decision to start logging this information into a database table?
And is this information expected to be saved permanently? I see no util command which is meant to clean out the information in this table, but it seems like this kind of data has very little usefulness after a load is completed. I can see wanting to know the status shortly after the load was completed, but why would I care about a load which happened months ago. As it stands, the information stored in this table would remain there indefinitely, which seems a little overkill.
> Were there previously no logs for these activities, or just no logs to a database table?
<<js Just no logs to a database table.
> What drove the decision to start logging this information into a database table?
<<js One factor may be the ability to have a common logging location for both the batch (p_file_99, p_file_93) and the oclc_server, that is, everything using the generic loader programs.
> And is this information expected to be saved permanently?
<<js No, it is not.
I am passing this on as an enhancement request. In the meantime, you can periodically use the following SQL to delete older z73 records:
SQL> delete from z73 where Z73_OPEN_DATE_X < 'yyyymmdd';
<where "yyyymmdd" is the cutoff date for saving z73 records>
This issue is still open and was escalated to Development for further investigation <2007-10-21 01:00:04>.
- Article last edited: 10/8/2013