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

    Parallel indexing, p_manage_32, "such column list already indexed "

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

    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?

    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


    !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