各位专家: 昨天一个表空间满了,然后业务那边把表删除了,但是到今天早上空间都没有释放,重启库也不行;
1、目前表空间情况
TBSP_NAME TBSP_TYPE DBPARTITIONNUM TOTAL_MB USED_MB FREE_MB PAGE_SIZE
TBS_DATA_01 LARGE 0 427008 198296 228668 32768
TBS_DATA_01 LARGE 1 427008 194741 6186 32768
TBS_DATA_01 LARGE 2 427008 198561 228403 32768
TBS_DATA_01 LARGE 3 427008 196536 230420 32768
TBS_DATA_01 LARGE 4 427008 196722 4123 32768
TBS_DATA_01 LARGE 5 427008 197230 229726 32768
TBS_DATA_01 LARGE 6 427008 195061 6183 32768
TBS_DATA_01 LARGE 7 427008 197188 229768 32768
TBS_DATA_01 LARGE 8 427008 198784 1583 32768
TBS_DATA_01 LARGE 9 427008 196283 4299 32768
TBS_DATA_01 LARGE 10 427008 198359 2237 32768
TBS_DATA_01 LARGE 11 427008 197454 3131 32768
TBS_DATA_01 LARGE 12 427008 199590 520 32768
TBS_DATA_01 LARGE 13 427008 198822 1276 32768
TBS_DATA_01 LARGE 14 427008 203751 0 32768
TBS_DATA_01 LARGE 15 427008 198711 1532 32768
我们看到427008-203751=!0
2、试着用db2dart来降低高水位:
Action option: RHWM
Tablespace-ID: 4
Warning: The database state is not consistent.
Warning: Errors reported about reorg rows may be due to the inconsistent state of the database.
Connecting to Buffer Pool Services...
Highwater mark processing - phase start.
Reduce highwater mark processing - phase start.
Error: No changes will be made because the database is not consistent.
Reduce highwater mark processing - phase end.
¥db2 get db cfg for gzopdb | grep -i con
Database is consistent = NO--个人认为这个指标并不意味着什么
3、重启数据也还是没有解决问题
4、表空间状态
Tablespace ID = 4
Name = TBS_DATA_01
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 13664256
Useable pages = 13664192
Used pages = 6345472
Free pages = 7318720
High water mark (pages) = 9881184
Page size (bytes) = 32768
Extent size (pages) = 32
Prefetch size (pages) = 384
Number of containers = 2
麻烦哪位专家指导一下,谢谢
收起