• 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