Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    Unanswered: lowering high water mark db2 dms tablespace


    A question about lowering the high water mark of db2 DMS tablespaces in db2 v9.5 FP 4 on AIX :

    When I try to lower the HWM of a tablespace containing tabledata , everything works as planned : db2dart /LHWM suggest which table should be reorganized offline and indeed, after the reorg, the HWM has dropped
    The indexes of all the tables in the tablespace for which I'm lowering the HWM are all in a second DMS tablespace. When an offline reorg is taken, also indexes are rebuild so why isn't the HWM of the index tablespace lowered as well (because I clearly see that the HWM stays the same for this tablespace) ?

    Best regards


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Did you run db2dart /LHWM for the index tablespace?

Posting Permissions

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