Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: question on rebuilding system indexes

    We have a large number of DB2 system indexes that need to be rebuilt. Any tips on how to go about this task? We are running DB2 UDB 7.2+FP6 on AIX 4.3.3

    Thanks gurus

    Scott

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: question on rebuilding system indexes

    Maybe its just me who doesn't understand ...

    What do you mean by system indexes ?

    Cheers

    Sathyaram



    Originally posted by mixxalot
    We have a large number of DB2 system indexes that need to be rebuilt. Any tips on how to go about this task? We are running DB2 UDB 7.2+FP6 on AIX 4.3.3

    Thanks gurus

    Scott
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi Scott,

    You must be talking about the system indexes which are generated on the primary keys by the system.

    The system indexes can not be rebuilt. If you reorg the tables and runstats on them using indexes then you may get the optimisation that you are expecting.

    Cheers,
    Prashant

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    That may not be necessarily true - you can create a PK naming the underlying index with the syntax alter table <schema>.<tabname> add constraint <constraint-name> primary key (col1).

    Scott what do you mean by system indexes?

  5. #5
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi chattoraj,

    We are not talking of creating a PK by supressing the system indexes.
    We can definitely do that which you are saying.

    The question is then what system indexes are...
    If scott is talking about the indexes on system/catalog tables then they can not rebuilt.

    cheers,
    Prashant

Posting Permissions

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