WEB开发网
开发学院数据库DB2 DB2 V9.7新特性 - 降低高水位标记 阅读

DB2 V9.7新特性 - 降低高水位标记

 2010-07-13 00:00:00 来源:WEB开发网   
核心提示: 使用”db2dart dbname /DHWM /TSI tbsid”命令可以查看表空间高水位标记的详细信息,其中 dbname 是数据库名称,DB2 V9.7新特性 - 降低高水位标记(5),“/TSI”用来指定表空间 ID(tbsid),在输出

使用”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. 
 ----------------- 略 ------------------- 

上一页  1 2 3 4 5 6 7 8 9 10  下一页

Tags:DB 特性 降低

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接