Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2012
    Posts
    25

    Question Unanswered: why should i use LOWER HIGH WATER MARK by DMS-Tables

    in the definition IBM DB2 9.7 Information Center for Linux, UNIX, and Windows i saw a remark that says that i must use use LOWER HIGH WATER MARK by DMS-Tables.
    Why???

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I think 'lower HWM / alter tablespace' is for non-automatic storage DMS tablespaces.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    by lowering the high water mark, you can release space from the tablespaces by using alter tabelspace reduce.

    the backup command copies all pages from 0 to the high water mark. by reducing the high water mark, you backup does not have to scan and store info about the empty pages
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Mar 2012
    Posts
    25
    Quote Originally Posted by sathyaram_s View Post
    by lowering the high water mark, you can release space from the tablespaces by using alter tabelspace reduce.

    the backup command copies all pages from 0 to the high water mark. by reducing the high water mark, you backup does not have to scan and store info about the empty pages
    But why ist it recommended only for DMS tables??

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    HWM exists in DMS tablespaces (not tables) only.

  6. #6
    Join Date
    Mar 2012
    Posts
    25

    Thumbs up Thanks

    Thanks!!!

Tags for this Thread

Posting Permissions

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