Parallel indexing, p_manage_32, "such column list already indexed "
- 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