db2v9.5,最近数据删除、导入量大,有两个表空间SEFD_FAT_2,SEFD_FAT_3的高水位标记好高,有几个表是分区表,分布在这两个表空间中。然后用db2 /dhwm 和/lhwm,结果lhwm显示奇怪的如下,两个表空间都是类似的问题,SEFD_FAT_2如下:
Highwater Mark: 3702432 pages, 231402 extents (extents #0 - 231401)
Lower highwater mark processing - phase start.
Current highwater mark: 231401
Desired highwater mark: 0
Number of used extents in tablespace: 164966
Number of free extents below original HWM: 66436
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 66436
Warning: Object ID 1566 in tablespace 15 was not
found in the SYSTABLES & SYSINDEXES
catalog tables.
Note: /LHWM only supports objects in non-range partitioned tables,
and global index objects in range partitioned tables.
The object encountered may belong to a ranged partitioned table.
Lower highwater mark processing - phase end.
---------------------
SEFD_FAT_3:
Warning: Object ID 617 in tablespace 16 was not
found in the SYSTABLES & SYSINDEXES
catalog tables.
-----------------
SEFD_FAT_2的dhwm如下:
Dump highwater mark processing - phase start.
Number of free extents below highwater mark: 47212
Number of used extents below highwater mark: 103189
Object holding highwater mark:
Object ID: 617
Type: Table Data Extent
Note: Extent contains page #0 for object.
Dump highwater mark processing - phase end.
Highwater mark processing - phase end.
---------------------
SEFD_FAT_3的dhwm如下:
Dump highwater mark processing - phase start.
Number of free extents below highwater mark: 66436
Number of used extents below highwater mark: 164966
Object holding highwater mark:
Object ID: 1566
Type: Table Data Extent
Note: Extent contains page #0 for object.
Dump highwater mark processing - phase end.
Highwater mark processing - phase end.
----------------------
对表空间进行/rhwm显示如下:
Action option: RHWM
Tablespace-ID: 15
Connecting to Buffer Pool Services...
Highwater mark processing - phase start.
Reduce highwater mark processing - phase start.
The Highwater mark cannot be reduced.
The index of the last SMP extent used is: (0)
Reduce highwater mark processing - phase end.
Highwater mark processing - phase end.
求解
收起