Hi Phil, You can reset the HWM with db2dart
regards, Gert ----- Original Message ----- From: "Nelson, Philip" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Sent: Monday, March 22, 2004 7:27 PM Subject: [DB2EUG] Resetting High Water Mark on DMS Tablespaces > > Now want to reclaim space but have found that you cannot specify a new size > less than the "High water mark (pages)" figure, which is larger than the > current usage. > > All the tablespaces I seem to have this issue with appear to be ones I've > defined for holding indexes (using INDEX IN tsname on table creation). > > How do I reset the HWM ? > > Phil > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
