Item/order creation for new bib record times out

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

Description:
Creation of the first item or order for a new bib record is increasingly slow -- it now frequently times out with "Server failed to execute request after 60 seconds". And the "io wait" percentage in the "top" command is in the 20-40% range (while it had previously been 0-5%).

Resolution:
This slowness was traced to the writing of Z00R records in the xxx50 (as part of the creation of the Z00/doc record).

While the xxx50 $data_tab/tab100 had "CREATE-Z00R=Y" and the SQL "desc z00r" showed that the z00r existed in the xxx50,

* util a/17/11/2 was getting the message, "the z00r is not managed by xxx50";
* util f/4 was getting "error in z00r"; and
* SQL "select count(*) from z00r" or "select * from z00r where z00r_doc_number = 'nnnnnnnnn'" took forever.

It seems that the sequence leading to this must have been something like this:

* z00r was in the file list, resulting in the z00r being created in Oracle by the initial util a/17/1 all;

* z00r was removed from the file list, but the z00r table was not dropped in Oracle;

* the z00r_id Oracle index was lost at some point;

* "CREATE-Z00R=N" was changed to "CREATE-Z00R=Y".


There are two possible solutions:

1. Change "CREATE-Z00R=Y" to "CREATE-Z00R=N" and do SQL "drop table z00r" ... in the *xxx50*!

2. Leave "CREATE-Z00R=Y" as is; add z00r to the xxx50 file list; run util a/17/2 to generate the z00r_id Oracle index.