DB2 V9.7新特性 - 降低高水位标记
2010-07-13 00:00:00 来源:WEB开发网使用”db2dart dbname /DHWM /TSI tbsid”命令可以查看表空间高水位标记的详细信息。其中 dbname 是数据库名称,“/TSI”用来指定表空间 ID(tbsid)。在输出结果中,可以看到在高水位标记下有两个空闲扩展数据块 266 和 267. 而占据高水位标记的数据块类型是 Table Data Extent。
获得降低高水位标记建议
清单 3. 降低高水位标记建议
# db2dart lde /LHWM /TSI 24 /NP 0
The requested DB2DART processing has completed successfully!
Complete DB2DART report found in:
/db2/LDE/db2dump/DART0000/LDE.RPT
# cat /db2/LDE/db2dump/DART0000/LDE.RPT
----------------- 略 -------------------
Lower highwater mark processing - phase start.
Current highwater mark: 271
Desired highwater mark: 0
Number of used extents in tablespace: 270
Number of free extents below original HWM: 2
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 2
Step #1: Object ID = 10
=> Offline REORG of this table using the LONGLOBDATA
option (do not specify a temporary tablespace).
Table: SAPLDE.RSBERRORCHANGED
DAT object size: 2
INX object size: 0
XDA object size: 0
LF object size: 0
LOB object size: 0
LOBA object size: 0
BMP object size: 0
Total size of object parts: 2
Minimum number of extents that will move by this operation: 2
Current highwater mark: 269
Desired highwater mark: 0
Number of used extents in tablespace: 270
Number of free extents below original HWM: 2
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 0
Final highwater mark: Extent #269 (270 extents, 540 pages).
** This cannot be lowered further as there
are not enough free extents
to move the object holding the highwater mark.
Lower highwater mark processing - phase end.
Highwater mark processing - phase end.
----------------- 略 -------------------
- ››db2 对float类型取char后显示科学计数法
- ››DB2中出现SQL1032N错误现象时的解决办法
- ››DB2 锁升级示例
- ››db2诊断系列之---定位锁等待问题
- ››db2 命令选项解释
- ››降低分区表的High Water Mark
- ››DB2 最佳实践: 使用 DB2 pureXML 管理 XML 数据的...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 基础: 表空间和缓冲池
- ››DB2 XML 编程,第 1 部分: 理解 XML 数据模型
更多精彩
赞助商链接