Certain headings which should have authority link ("Auth. Info") do not
Description:
There are xxx01 bib headings which don't have a BIB-AUT match but *should* because the BIB Z01_REC_KEY, Z01_NORMALIZED_TEXT and Z01_DISPLAY_TEXT of the headings match the same columns in an xxx10 AUT Z01 'GEN' heading. See examples in Additional Information below.
What can be done about this -- and how to determine the extent of the problem.
Resolution:
The information seen in the "Auth. Info." column is coming from the authority record linked to the heading via the z01_rec_key_4 (Z01-AUT-LIBRARY + Z01-AUT-DOC-NUMBER).
Checking this AUT LSUK JOSEF 52176 012252176 z01/heading in util f/4, it was found that this heading was not linked to any authority record; it had a value of "-CHK-000000000".
The ue_08 daemon goes through the z01 records looking for ones which have a z01_rec_key_4 of "-NEW-000000000".
Since it seemed that this heading *should* be linked to the xxx10 003340589 authority record, SQL was used to change its z01_rec_key_4 to "-NEW-000000000". And, sure enough, ue_08 processed it and connected it to the xxx10 003340589 record.
Then the following SQL was used to change the '-CHK-000000000' for all AUT headings to '-NEW-000000000':
xxx01@ALEPH22> update z01 set z01_rec_key_4 = '-NEW-000000000' where z01_rec_key_4 = '-CHK-000000000' and z01_rec_key like 'AUT%' ;
xxx01@ALEPH22> update z01 set z01_rec_key_4 = '-NEW-000000000' where XXX01.Z01.Z01_rec_key_4 = '-CHK-000000000' and (substr (XXX01.Z01.Z01_REC_KEY,6,65) = substr(XXX10.Z01.Z01_REC_KEY,6,65)) and substr(XXX10.Z01.Z01_REC_KEY,1,3) = 'GEN';
ue_08's progress can be checked with the following SQL:
xxx01@ALEPH22> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ substr (z01_rec_key_4,1,5), count(*) from z01 where z01_rec_key like 'AUT %' group by substr (z01_rec_key_4,1,5);
It will show something like this:
SUBSTR(Z01_REC_ COUNT(*)
--------------- ----------------------------------------
XXX10 690679
-NEW- 1024976
-CHK- 84135
As ue_08 processes the z01's, the z01_rec_key_4's will change from "-NEW-" to "XXX01" or "-CHK-". When the "-NEW-" count reaches zero, that will indicate that ue_08 has finished processing these z01's with "-NEW-".
**The preceding should be done on the Test server first.** If it is found that the process is too slow,then a complete Headings re-indexing (manage-102, manage-02, etc.) may be performed instead, or the method described in Additional Information below may be used.
Additional Information
Examples of the condition described in the Description above.
SUK
xxx01@ALEPH22> select
Z01_REC_KEY,Z01_ACC_SEQUENCE,Z01_AUT_TAG,Z01_REC_KEY_4,Z01_ACC_SEQUENCE_SEE,Z01_NUMBER_OF_DOC,Z01_CATEGORY,Z01_NORMALIZED_TEXT,
Z01_DISPLAY_TEXT from z01 where Z01_REC_KEY like 'AUT LSUK JOSEF %';
Z01_REC_KEY Z01_ACC_S Z01_A Z01_REC_KEY_4 Z01_ACC_SEQUENCE_SEE Z01_NUMBER_OF_DOC Z01
Z01_NORMALIZED_TEXT
Z01_DISPLAY_TEXT
AUT LSUK JOSEF 52176 012252176 -CHK-000000000 0 0 00
$$asuk, josef
$$aSuk, Josef
xxx10@ALEPH22> select
Z01_REC_KEY,Z01_ACC_SEQUENCE,Z01_AUT_TAG,Z01_REC_KEY_4,Z01_ACC_SEQUENCE_SEE,Z01_NUMBER_OF_DOC,Z01_CATEGORY,Z01_NORMALIZED_TEXT,
Z01_DISPLAY_TEXT from z01 where Z01_REC_KEY like 'GEN LSUK JOSEF %';
Z01_REC_KEY Z01_ACC_S Z01_A Z01_REC_KEY_4 Z01_ACC_SEQUENCE_SEE Z01_NUMBER_OF_DOC Z01
Z01_NORMALIZED_TEXT
Z01_DISPLAY_TEXT
GEN LSUK JOSEF 11398 009011398 1001 XXX10003340589 0 0 00
$$asuk, josef
$$aSuk, Josef
MOZART
xxx01@ALEPH22> select
Z01_REC_KEY,Z01_ACC_SEQUENCE,Z01_AUT_TAG,Z01_REC_KEY_4,Z01_ACC_SEQUENCE_SEE,Z01_NUMBER_OF_DOC,Z01_CATEGORY,Z01_NORMALIZED_TEXT,
Z01_DISPLAY_TEXT from z01 where Z01_REC_KEY like 'AUT LMOZART WOLFGANG AMADEUS 1756 1791 %';
Z01_REC_KEY Z01_ACC_S Z01_A Z01_REC_KEY_4 Z01_ACC_SEQUENCE_SEE Z01_NUMBER_OF_DOC Z01
Z01_NORMALIZED_TEXT
Z01_DISPLAY_TEXT
AUT LMOZART WOLFGANG AMADEUS 1756 1791 83544 010383544 -CHK-000000000 0 0 00
$$amozart, wolfgang amadeus$$d1756 1791
$$aMozart, Wolfgang Amadeus,$$d1756-1791
xxx10@ALEPH22> select
Z01_REC_KEY,Z01_ACC_SEQUENCE,Z01_AUT_TAG,Z01_REC_KEY_4,Z01_ACC_SEQUENCE_SEE,Z01_NUMBER_OF_DOC,Z01_CATEGORY,Z01_NORMALIZED_TEXT,
Z01_DISPLAY_TEXT from z01 where Z01_REC_KEY like 'GEN LMOZART WOLFGANG AMADEUS 1756 1791 %';
Z01_REC_KEY Z01_ACC_S Z01_A Z01_REC_KEY_4 Z01_ACC_SEQUENCE_SEE Z01_NUMBER_OF_DOC Z01
Z01_NORMALIZED_TEXT
Z01_DISPLAY_TEXT
GEN LMOZART WOLFGANG AMADEUS 1756 1791 62778 009462778 1001 XXX10003301685 0 0 00
$$amozart, wolfgang amadeus$$d1756 1791
$$aMozart, Wolfgang Amadeus,$$d1756-1791
An alternative way of performing the update: resend the *authority* record for reindexing, either by saving it to the server in GUI cataloging or via util f/1/13 while dlib-ed to xxx10 and then specifying the xxx10 rec-key of the authority record.
If there are many such authority records, a file of numbers like this
000123456XXX10
000234567XXX10
<etc.>
could be used as input to the manage-40 Service running in xxx10. That will create z07 records,
which will be processed by the xxx10 ue_01,
which will write a z105 message record,
which will be processed by the $usr_library (xxx50) ue_11 messaging daemon,
which will change the z01_rec_key_4 to "-NEW-000000000",
which will trigger processing by ue_08.