Potential danger in "Parallel Indexing", Step 3

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

Description:
The "Parallel Indexing" document, Step 3, says the following:

In the indexing library the bibliographic documents table, Z00, as well the Z103 and Z0102 tables should always be a logical synonym:
LS z00 USM01
LS z103 usm01
LS z0102 usm01

Before initiating parallel indexing, the above tables should be dropped in the indexing library, by using the following SQL commands:
>>s+ usm21
SQL-USM21>drop table Z00;
SQL-USM21>drop table Z103;
SQL-USM21>drop table Z0102;

Remember to create logical synonyms (UTIL A/17/5) after changing the file_list table.

Resolution:
To prevent confusion and protect against a possible deletion of the bib file, I am submitting a revision which reads as follows:

Before initiating parallel indexing, the above tables should be dropped in the indexing library (the parallel library).

Before doing the following SQL drops, do the following select:

s+ usm21
SQL> select count(*) from z00;

The result should be 0. If it is not, it indicates that you either:

(1) are not in the parallel library or
(2) are LS-ed from the parallel library to the production.

*Exit immediately.*

In the case of #1, do "s+" to the correct, parallel library.

In the case of #2, do util a/17/5/1 to confirm that the synonyms already exist. If so, you do not need to do anything more: the fact that the synonyms exist indicates that the tables have been dropped. (Oracle will not let you create the synonym when the table exists in the parallel library.)

If the result of the "select count" is 0, then proceed with the SQL commands for doing the drop:


SQL-USM21>drop table Z00;
SQL-USM21>drop table Z103;
SQL-USM21>drop table Z0102;*

After changing the file_list and dropping the tables, create the logical synonyms (UTIL A/17/5/2) in the parallel library.

* In v17-up, and v16 with new_ue_01, p_manage_32 (which builds the z0102) can also be done in the parallel library.

• Article last edited: 10/8/2013