Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011

    Unanswered: Reorg and runstats of catalog tables

    Can reorg and runstats of the catalog tables help with the performance when accessing application tables?


  2. #2
    Join Date
    May 2003
    The catalog tables are used to determine the access plan chosen by DB2 to process the SQL. For example, DB2 will look at the various indexes and their statistics as stored in the catalog to determine whether to use any of them instead of doing a table scan. However, keep in mind that if the same exact SQL is being executed more than once, the access plan "may" be cached in package cache, or if static SQL is used (such as found in most stored procedures) the access plan is already stored in with the package.

    So yes, reorg and runstats of the catalog tables can help with performance.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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