Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2002
    Posts
    48

    Question Unanswered: Altering High Water mark for DMS tablespace

    Hello all

    I am working on DB2 UDB Verion 8.2.1. I have added more space to the tablespace. Now i have to reduce the size. But it's not allowing me to reduce the size below highwater mark.
    Is there any way to reduce the size of the container?
    Is there any way to change the highwater mark without any outage.

    Thanks
    Nageswaran

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    db2dart /LHWM will suggest the ways of lowering the high watermark.

  3. #3
    Join Date
    Jul 2002
    Posts
    48
    Whether we have to take the database down....thanks

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    IIRC, yes ...

    Having a look at the documentation will definitely help

    Cheers
    Sathyaram

    Quote Originally Posted by Nageswaran
    Whether we have to take the database down....thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    I know I am bringing dead to life, but I figured it might help someone. I just spent a good amount of time on this so others don't have to.

    We have DMS tbs where HWM is seriously out of reality with current data. Db2dart in this case was suggesting >>>> => EXPORT all data from table, drop the table, disconnect, reconnect, recreate the table, and LOAD the data back into the table.<<< as the only option. I know there are times where it tells you to reorg/deactivate and then possibly rebuild indexes. This was not the case.

    Touching data should be the last thing on anyone’s mind. I have dropped and rebuild indexes and HWM were right were it should be.

    In the cases where it told to do a reorg first, I have found no benefit of doing reorg what so ever. The only feasible and useful option is to rebuild indexes regardless what db2dart says.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  6. #6
    Join Date
    Apr 2008
    Posts
    51
    Rebuilding indices may help if they are in the same tablespace as data, which often is not the case. The official response from IBM on this subject: "We are aware of the problem. There is no documented way to affect HWM. We are working on a solution."
    db2topgun.com

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by SuperKuper
    Rebuilding indices may help if they are in the same tablespace as data, which often is not the case. The official response from IBM on this subject: "We are aware of the problem. There is no documented way to affect HWM. We are working on a solution."
    Great to see you here Gene.

    Thanks for the responce.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Well, it seams that dropping table and indexes does not lower HWM either. Gene, have you heard anything from IBM on this? Anyone else were able to lower HWM? I really do no feel like dropping and rebuilding 77 tables.

    Thank you.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  9. #9
    Join Date
    Apr 2008
    Posts
    51
    Have not heard anything on this lately. I recall reading somewhere that this is taken care of in 9.1 or 9.5 - not sure.
    db2topgun.com

  10. #10
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Great. until then I have to let 40GB get dusted.

    Thanks.

    btw.I am sick working from home. Lunch next week?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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