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

Description:
We have classic case of 8192-2743, "Thousands of bib library Z07's suddenly coming from xxx50 library" as ue_01 was running in the ABC50 library by mistake. It has since been stopped but not before a backlog of 51,000 z07 were created in the ABC01 library.

What should we do with all of these records? Delete them or let the process run? To delete I'm figuring I would use this SQL:
delete from z07 where substr (z07_history, 1,5) like 'ABC50%';

I do not believe we have indexes in VCU50 but am not sure, and need to clarify before deleting these records.

Resolution:
The Z07 records with "VCU50" as the z07_history value can come not only from the xxx50 ue_01 but also directly from the update of item records in the VCU50 library.

The abc50 ue_01 was stopped on Dec 14 at 21:59.

The following SQL shows that 59 Z07's have been written (directly) from abc50 today (Dec 17):

SQL> select count(*) from z07 where z07_sequence like '20071217%';

COUNT(*)
----------
59


You need to preserve these. You should do:

SQL> delete from z07 where substr (z07_history, 1,5) like 'ABC50' and z07_sequence like '20071214%';


Though the ../abc50/tab/tab00.eng has:

H NLM IND 01 00 00 NLM
H LCC ACC 01 00 00 LC Class
H WRD W-000 00 00 Words

the abc50 tab11_ind, tab11_acc, and tab11_word are all empty. This indicates that you do not have any actually-functional indexes in abc50.

You can do UTIL-A-17-1 for the abc50 z07.

To prevent ue_01 from running in abc50 when aleph is restarted, "abc50" should be *removed* from the WORD_STARTUP_LIBS entry of aleph_start.private.

• Article last edited: 1/7/2014