Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    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
    Location
    UK
    Posts
    4,650
    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
  •