Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006

    Unanswered: maintenance

    - runstats should be executed on regular interval
    - reorgchk and reorg if check indicates reorg is needed
    - backup (this is not part of maintenance)
    - space usage if dms tablespaces defined
    probably many more ...
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  2. #2
    Join Date
    Aug 2005
    Guy przytula,
    thanks so much for your response....

    I think you r right.Still there may have some more things to do.
    Is there anybody know some more facts for table maintainance ?
    Could you pls share us?


  3. #3
    Join Date
    Jan 2004

    Maintenance Activities

    One of the maintenance activity is to bring down HWM for DMS tablespaces. This can be achieved in two ways.

    1. Offline re-org (for this you required 100% free space of table allocated size on your tablespace).
    2. Table data unload & load.

    After completion of any of the above steps,

    do update runstats for those tables.

    Quote Originally Posted by Coolhard
    Dear All,

    I want to make a maintainance for some of my tables by manually in every month.
    May I know what to do?
    I only know the statistic.I think there are some others procedure I suppose to do for the maintainance.Am I right?
    Is there any idea pls?

    Thanks in advance,

Posting Permissions

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