Tag «shrink tablespace»

Db2 V9.5 – How to Shrink Tablespace

db2 9.5 shrink tablespace

After deleting a big set of data from a table, we expect it to get smaller than it was before. But in Db2 V9.5 you need to lower high water mark to shrink unused space in tablespace. After Db2 V9.7 you can use ALTER TABLESPACE command to lower high water mark and reduce a table’s size. …