Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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.