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.