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

    Arrow Unanswered: REORG/RUNSTAT - User v/s System tables

    Rerog and Runstat should be run against users tables, but how important is to run it against system tables?


    DB: DB2 UDB V7/V8 on Windows

  2. #2
    Join Date
    Mar 2003
    Do a reorgchk on the database - that will tell you how the system tables are doing. Reorg based on what you get. I think it could turn out to be fairly important if the tables need reorganisation. I think one of the indications will be the catalog cache hit ratio will fall significantly.

Posting Permissions

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