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

    p_auth_03 count too high?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Our catalogers are trying to run the p_auth_03 Unauthorized headings report using a date time frame and think the results are incorrect. I don't know enough about this report to know if this is or is not true.

    From the batch log, here are the parameters they are running with:

    12181345135306 8938 p_auth_03 Fixed param: ABC01,2008_08_7series,SRS,20080605,N,01,AGUIMARA,

    So, they want values changed since 20080605. But the resulting output file reports 32,853 records, which seems excessive.

    How can I tell if this is working properly or not. The resulting file has output of entries like:

    <section-02>
    <heading-seq>010604464</heading-seq>
    <heading-code>SRS</heading-code>
    <heading>$$a18th century overtures</heading>
    </section-02>

    What is the heading-seq number and how might it be used to review this output? Or is there another way in which the output is reviewed?

    Resolution:
    p_auth_03 is run in the bib library and lists bib headings of a type which (according to tab_aut) is linkable to an authority record and which have been updated since yyyymmdd date, but which are not actually linked.

    I'm working with the most recent run, abc01_p_auth_03.00671 which has a p_file_name_out of "2008_08_13series3".

    The following grep shows that 11,686 headings are listed in this file:

    > grep -c '<heading-index' 2008_8_14dupseries
    11686

    The following SQL shows that there are 22,070,015 ndu01 z01's:

    SQL> select count(*) from z01;
    **** Hit return to continue ****

    COUNT(*)
    ----------
    22070015

    The following SQL shows that 17,046,279 z01's were updated on June 13, 2008:

    SQL> select count (*) from z01 where Z01_UPDATE_DATE = '20080613';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    17046279


    The following SQL shows that 16,110,927 z01's are not linked to an authority record and have been updated since June 12, 2008. (z01's linked to an authority record have a z01_rec_key_4 of 'ABC10nnnnnnnnn'):

    SQL> select count(*) from z01 where Z01_REC_KEY_4 = '-CHK-000000000' and Z01_UPDATE_DATE > '20080612';
    **** Hit return to continue ****

    COUNT(*)
    ----------
    16110927


    This is higher than 11,686 because it is not excluding z01's which are not of a linkable type, while p_auth_03 includes only those of a linkable type.

    The significant fact here is that almost all of the z01's have been updated since 2008-06-12 -- no doubt as a result of ue_08 activity. (Remember that ue_08 type "New" recreates *all* of the z01's.)

    • Article last edited: 10/8/2013