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

Description:
util a/17/14 for abc01 shows that the Oracle indexes for the abc01 z970 do not exist:

Enter Table Name : z970

Defined in file_list:
__________________________________________________________
IND z970_id 4M 0K TS2X
IND z970_id1 4M 0K TS2X
__________________________________________________________

Exist in the Database:

Enter CR to continue...


I tried building them, but get this:

util a/17/2 for z970 :

aleph_admin@ALEPH0> 22:45:31 aleph_admin@ALEPH0> CREATE INDEX ABC01.Z970_ID ON ABC01.Z970 (Z970_REC_KEY ASC)
*
ERROR at line 1:
ORA-01408: such column list already indexed

Resolution:
This message is appearing because the z970 table is LS-ed to the ABC03 parallel index library in the ABC01 file_list:

LS Z970 ABC03

Though the entries for z970_id and z970_id1 in the ABC01 file_list are commented out, the $aleph_root/tab/file_list.BIB has these entries:

IND z970_id 100K,128K,128K,128K,128K,4M 0K ts1,TS1X,TS1X,TS1X,TS1X,TS2X
IND z970_id1 100K,128K,128K,128K,128K,4M 0K ts1,TS1X,TS1X,TS1X,TS1X,TS2X

(This is where util a/17/14 is getting the "Defined in file_list" entries.)

It seems that when you do util a/17/2 it is finding the existing z970_id and z970_id1 indexes in ABC03, but when you are doing util a/17/14, it does not find them....

What's odd about this is that at most sites, an "LS Z970 ABC03" will result in a message

Table/Index z970 not managed by ABC01 check file list

when you do util a/17/14....

• Article last edited: 10/8/2013