Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: Index system catalog table

    Have any one indexed system catalog table. I have some poor performing sql that is spending lot of time on tablescan on system catalog table. I wanted to index that perticular column and DB2 does not allow me to set up an index on system catalog table.
    My version of db2 is 8.1.6

    Any suggestions how i can accomplish this task to improove the performance.

  2. #2
    Join Date
    Aug 2001
    RUNSTATS on the system catalog table is the one you are likely to need.

    Also, consider tuning catalog cache size db cfg and if needed, a separate bufferpool for the catalog tablespace.

    If you think this is causing a huge problem, get IBM support to look into this.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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