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

Description:
Following the Parallel Indexing document, I created LS's for z00, z103 and z0102 in the indexing library ABC02 to the actual library ABC01 in our Test region. I was able to successfully run the indexing jobs for keywords and headings but when I tried to run p-manage-32 in the ABC02 indexing library the job finished in seconds without processing any records. I used this in the ABC02 library:

csh -f $aleph_proc/p_manage_32 ABC02,1,ALL,5, > & $alephe_scratch/abc02_p_manage_32.log &

The $alephe_scratch/abc02_p_manage_32.log seems to indicate that it found no records to index. The actual create index logs in the $data_scratch, like create_ora_tables_z0102_id1.log, show this error:

ORA-01408: such column list already indexed

which seems to indicate that it used the synonym correctly since it found the indexes already present. Is there some other table I should have created a logical synonym for other than z0102 for p-manage-32 to work correctly?

Resolution:
The Parallel Indexing document needs to be updated. It says to LS the z0102 to the actual library. When you do this, you will not be able to run p_manage_32 in the parallel library. When you did this run, the job was trying to drop/create the abc01 z0102!

You could wait and run p_manage_32 in abc01, post-parallel-indexing -- which is what the document suggests --, but actually, in v17-up, there's no reason it can't run in the parallel library.

You need to do the following to allow this:

* in the abc02 file_list, change:

LS z0102 abc01

To:

!LS z0102 abc01
TAB z0102 960M 0K TSnD
IND z0102_id 960M 0K TSnX
IND z0102_id1 960M 0K TSnX

<changing "n" to the desired tablespace number>

* in abc02, do util a/17/5/2 to recreate the synonyms

* in abc02, do util a/17/5/1 to confirm that the z0102 synonym is gone

* in abc02, do util a/17/1 for z0102 to create the table in abc02

* run p_manage_32 in abc02.

• Article last edited: 10/8/2013