Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Converting Type 1 indexes in type 2

    Hello,world!
    I believe it exist somewhere as a thread,but unfortunately i can't find it.
    So:
    I want to migrate db from v7 to v8.2.To be allowed to do online reorg i remember i have to convert all indexes from type 1 to type 2.
    Questions:
    1) How to covert type 1 indes to type 2 during reorg?
    2) How to check type of specific index?
    3) Am i have to convert (and how) indexes in schema SYSIBM,SYSCAT,SYSTAT and optionally ASN?
    Tia,and sorry
    Zvonimir

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Use...
    1. REORG INDEXES ALL FOR TABLE <TABLENAME> CONVERT
    2. All indexes created henceforth will be type 2 indexes - after 1 is done for a table.
    3. Don't think you need to be concerned about this.
    HTH

  3. #3
    Join Date
    Jul 2002
    Posts
    48
    Regarding the second question
    you can check the type of index through the help of command
    "inspect" .. This will tell you whether you have type 1 index or type 2 index...

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    See the tutorial about 1 and 2 question:
    http://www.databasejournal.com/featu...0896_3399101_3

Posting Permissions

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