Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: do you REORG system tables?

    from your experience do you ever REORG system tables (SYSIBM.*)? in what situations?
    thanks
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    doveryai, no proveryai

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I don't recall ever doing a reorg on the catalog at our shop (mainframe), but that is most likely because we didn't do a lot of changes to the catalog... or could be some other reason. I don't remember.

    I think it's a good idea to reorg your system catalog tables after a significant schema change and reorgchk can help you decide what to reorg. If you're going to reorg, then do runstats as well.
    Last edited by db2girl; 12-24-09 at 15:28.

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    we don't manually run reorgchk - we have to run maintanence script to reorg and runstats all tables in production within a small maintanence window. i think i will exclude system tables from reorg and runstats all tables incl. system.

    thank you, Bella
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    It depends... if your database or subsystem has a lot of tables and/or columns (a lot means a few thousand), I would consider system tables for reorg. Especially if you have page locks, it can be beneficial.

    If the schema doesn't change or doesn't change significantly, it should be a one-time task only.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Nov 2009
    Posts
    5
    Quote Originally Posted by MarkhamDBA View Post
    from your experience do you ever REORG system tables (SYSIBM.*)? in what situations?
    thanks


    I suggest you put reorging system tables into your schedule. It cost you little time but save you from a lot of problems.

  7. #7
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thanks everyone
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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