var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
I think 'lower HWM / alter tablespace' is for non-automatic storage DMS tablespaces.
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.
But why ist it recommended only for DMS tables??
Originally Posted by sathyaram_s
HWM exists in DMS tablespaces (not tables) only.
Tags for this Thread