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

    Multiple z120_id3 entries in util a/17/14

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

    Description:
    In analyzing some OPAC problems, I find duplicate entries for the z120_id3 in util a/17/14 for z120:

    Z120_ID3 VALID NORMAL NONUNIQUE Z120_REC_KEY
    Z120_ID3 VALID NORMAL NONUNIQUE Z120_REC_KEY_1

    I see that the usm01 (and usm90) are the same,... but it seems odd. Is this really OK?

    Resolution:
    The appearance of two lines in util a/17/14 for the z120_id3 Oracle index is normal. It occurs because the ./alephm/sql_tab/z120_create_index_3.sql has this line:

    CREATE INDEX &1.Z120_ID3 ON &1.Z120 (Z120_REC_KEY, Z120_REC_KEY_1 ASC)

    It is building the index using two different columns.

    Other indexes which are built on two columns and, similarly, have multiple entries in util a/17/14:

    Z00P_ID5
    Z0101_ID3
    Z15_ID2
    Z82_ID

    • Article last edited: 10/8/2013