Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Toronto, Canada

    Unanswered: runstats on SYSCAT tables

    we are migrating to v9.5 and manual says we should do RUNSTATS on SYSCAT tables as "during database migration, the statistics collected for system catalog tables are not retained".

    My question is should we do RUNSTATS on SYSCAT tables on regular basis as a maintanence (same as for regular application tables)? Thanks
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Yes, you should do RUNSTATS on the system tables. The frequency depends on the frequency of changes to them.


  3. #3
    Join Date
    May 2003
    Any time you make a big schema change. Also the first time you run them on catalog tables, make sure run them twice because the first time will add a large number of rows to some of the stats tables, and you have to run again to get stats on the stats tables.
    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