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

    **What bases should be in the z0102 table?**

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    We understand that not all bases should be included in the optional z0102 table which is built by p_manage_32.

    How do we decide what bases should be included?

    The setting of column 8 in tab_base.eng controls the building of the z0102 for particular bases.

    We recommend setting tab_base.eng col. 8 to "N" under these conditions:

    1. if a particular base includes more than 10% of the file

    2. if the bib library has fewer than 1 million records, set it to "N" for all bases

    (Note: If no bases have a col. 8 "Y"), then you do not need to run p_manage_32.

    In case #1, you can look at util h/1/10 to see how many records are in each base, but there will be cases (where the base is between 10% and 16% of the total) where it will give you an "ERR" and suggest that it should be "Y". You can ignore these errors....

    In case #2, you can ignore util h/1/10 entirely.

    Setting these larger bases to "N" will reduce (1) the run time for p_manage_32 and (2) the size of the z0102 table.

    Additional Information


    • Article last edited: 10/8/2013