Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Parallel Indexing Step 9, Option 1: Changing file_list for subsequent parallel

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

    We have done parallel indexing previously. The changes shown in the Parallel Indexing document, Step 9, Option 1- Logical Synonyms, seem to be for the case where the indexing is being done for the first time. What would the changes be if it's a subsequent indexing?

    The "Option 1: Logical Synonyms" doesn't properly address the case where you have previously run parallel indexing.

    In the case where you are doing the indexing in a second parallel library, rather than replacing TAB and IND entries in the xxx01 library file_list with "LS"s, you would change the LS's in xxx01 file_list from one parallel library to the second parallel library.

    Let's say that the ABC01 file list has:

    LS z01 ABC03
    LS z02 ABC03
    LS z05 ABC03
    LS z11 ABC03

    Then to make the new indexes in ABC07 be in effect, you would change the LS's to ABC07:

    LS z01 ABC07
    LS z02 ABC07
    LS z05 ABC07
    LS z11 ABC07

    and do util a/17/5/2 to recreate the synonyms.

    There would be no need to "Drop the relevant Z tables in the actual library" because this was done previously when you previously created the LS's to the other parallel library (abc03).

    The beauty of it is, if there's a problem, you can change the file_list back to ABC03, rerun util a/17/5/2 and you're back to your previous indexes -- a change taking less than five minutes.

    In order to save space, you may, several days after implementing the new index -- when you are quite certain that everything is working correctly -- , want to do delete the old index in the old parallel library. This could be done using util a/17/1 but that utility recreates the table (empty, with the primary allocation). To actually drop the table, you would do: SQL> drop table znn . (Make sure you are doing this in the correct library!)

    In the above example, you would drop the z01, z02, z05, and z11 tables in abc03.

    • Article last edited: 10/8/2013