Results 1 to 2 of 2

Thread: DB2 reorg

  1. #1
    Join Date
    Dec 2004

    Unanswered: DB2 reorg

    I am using db2 7.2 on AIX,
    I ran reorgchk, in the output for a particular table all index key it showed '*' , I did reorg by using primary key index but still remaining keys are showing '*' if i do reorg by using one index key remaining keys are still in '*', how I can resolve this?.

    And why sysibm.sysprocedure's index is also in '*', how to resolve this also?


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 1

    Reorg-ing table by one index (e.g. primary key index) will sort table according to this index. Because table can be ordered by only one index all other indexes will be market as "*". You don't need to worry about "*" at other indexes, this is normal!

    If you would like to have table ordered by particular index (and using DB2 for Linux/Unix/Windows just like you) you need to specify word "CLUSTER" at index creation.

    CREATE INDEX db2admin.index_name ON db2admin.table_name (COL1, COL2) CLUSTER
    Hope this helps,
    Last edited by grofaty; 02-15-05 at 04:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts