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

Problem Symptoms:
* Service Circulation Logger Clean Up (cir-78) takes several weeks for initial cleanup
* rep_change 3437 (Aleph 20) did not improve the speed.
* util/a/17/14 to "List Existing Indexes for a Table", the results (below) indicates that it's defined in the file_list, but does not exist in the database.

Is there an implementation step missing in the release notes?

A.17. Manage Oracle Tables of ABC50
[...]
14. List Existing Indexes for a Table

Please select [exit]: 14

Enter Table Name : z309

Defined in file_list:
__________________________________________________________
IND z309_id 4M 0K TS2X
IND z309_id2 4M 0K TS2X
IND z309_id3 4M 0K TS2X
IND z309_id4 4M 0K TS2X
IND z309_id5 4M 0K TS2X
IND z309_id6 4M 0K TS2X
__________________________________________________________


Exist in the Database:

INDEX_NAME STATUS INDEX_TYPE UNIQUENESS COLUMN_NAME
--------------- ------- ---------- ----------- --------------------
Z309_ID VALID NORMAL UNIQUE Z309_REC_KEY
Z309_ID2 VALID NORMAL NONUNIQUE Z309_REC_KEY_2
Z309_ID3 VALID NORMAL NONUNIQUE Z309_REC_KEY_3
Z309_ID4 VALID NORMAL NONUNIQUE Z309_REC_KEY_4
Z309_ID5 VALID NORMAL NONUNIQUE Z309_DATE_X

Enter CR to continue

Cause:
Index z309_id6 was not created

Resolution:
In order to "Exist in the database"
* dlib xxx50
* execute util a/17/2 ("Create Index")

Example
Enter table name to Create all tables' indexes
OR
index name to Create a specific index (all/table-name/index-name): z309_id6