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

    What is a "complete ue_08"?

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    We see references in other Knowledge articles and the documentation to a "complete ue_08".  What does that mean?

    Resolution

    These are the options for starting ue_08:

      - Continuous check of new headings (C)
      - Re-check previously unmatched headings (R)
      - Re-check all headings (as if they were new) (N)

    "C" is the default.  

    "N" causes all the z01_rec_key_4's to be changed to "-NEW-000000000", which means that ue_08 will need to recheck/relink all of them against the xxx10 authority headings.

    "R" causes all the z01_rec_key_4's with a value of "-CHK-0000000000", that is, those which are not linked to any xxx10 authority record, to be changed to "-NEW-000000000", causing them to be rechecked.

    A "complete ue_08" is when ue_08 is started with the "N" option.  The problem with "N" is that, though it runs in the background with other functions up and available, it can take so long to run.  In the past we have found it taking a week or more.  But, more recently, with version 22, there was a case where it ran in in 3 days for 2.2 million bib records / 35 million z01 headings.

    So ... if a headings reindexing is planned, using manage-102 ("Pre-Enrich Bibliographic Headings Based on the Authority Database") is usually the best way to go.  

    But if ue_08 is started accidentally with "N" (or "R"), then the following SQL can be used to check ue_08's progress in linking the headings:

    > s+ xxx01

    SQL> select count(*) from z01;

    SQL> select count(*) from z01 where z01_rec_key_4 like '-NEW-%'; 

    and you may want just let it run.   Note, however, that, if letting ue_08 run in this fashion, you will need to delete the many z07's which it generates. (See the article " Millions of Z07 records in bib library " in that regard.)   If not deleted, the processing of these z07's can create huge, problematic Oracle archive logs.  
      

     


    • Article last edited: 3-Jan-2018
    • Was this article helpful?