Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from venkyrepala on Jun 20 at 5:05 AM With DB2 10.1, you can use the feature of Reclaimable storage to
down the high water mark.
you can use the ALTER TABLESPACE with option LOWER HIGH WATER MARK.
With this option, the maximum number of extents are moved to lower the
high water mark, however, no container resizing operations are
performed.
ALTER TABLESPACE <Tablespace name> LOWER HIGH WATER MARK
Please check the following link for details.
http://publib.boulder.ibm.com/infocenter/db2luw/v9 r7/topic/com.ibm.db2.luw.admin.dbobj.doc/doc/c005539 2.html
As per the Info Centre:
http://publib.boulder.ibm.com/infocenter/db2luw/v9 r7/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql01 763n.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9 r7/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql01 763n.html
11
Table spaces must have the Reclaimable Storage attribute before you can
use clauses to reduce or lower the high water mark.
http://publib.boulder.ibm.com/infocenter/db2luw/v9 r7/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.doc/doc/t005537 5.html
"
Restrictions
#You can reclaim storage only in table spaces created with DB2 Version
9.7 and later.
#When you specify either the REDUCE or the LOWER HIGH WATER MARK clause
on the ALTER TABLESPACE statement, you cannot specify other parameters.
#If the extent holding the page currently designated as the high water
mark is in "pending delete" state, the attempt to lower the high water
mark through extent movement might fail, and message ADM6008I will be
logged. Extents in "pending delete" state cannot always be moved, for
recoverability reasons. These extents are eventually freed through
normal database maintenance processes, at which point they can be moved."
You can use the following query to see which tablespaces are
enabled for reclaimable storage:
SELECT TBSP_NAME, TBSP_TYPE, RECLAIMABLE_SPACE_ENABLED FROM TABLE
(MON_GET_TABLESPACE('',-2))
| | | ---------------Original Message---------------
From: db2dba_admin
Sent: Friday, June 20, 2014 4:48 AM
Subject: Deleting BALDAT Table
Thanks for the replies
I did offline reorg and Runstats on the table, but the table size remains the same.
Database- 10.1 |
| Reply to this email to post your response. __.____._ |   _.____.__ |
