[ADSM-L] Reorg in DB2 TSM V6.2.x
2011-07-14 02:26:19
We are having TSM V6.2.2.30( Win2008 R2) and the database is in an ever
growing state. I have expiration running daily and all other TSM operations are
going fine.
Till recently , i had DB2 "allow_reorg" ON for the tsm DB and thought the
reorg's where happening from the DB2 end.When i checked the db2diag.log . All
i can see is the below warnings from db2 health monitor
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10512W Health indicator "Reorganization Required"
("db.tb_reorg_req") is in state "Reorganization required" on
"database" "SERVER1.TSMDB1 ". Collection (Object Name, Timestamp,
Value, Detail): " ("TSMDB1"."ACTIVITY_SUMMARY", 07/12/2011
12:01:32.000000, 2, REORG TABLE USE TEMPTBSP), ...................
Hence, I enabled TSM Reorg by updating DB2 auto_reorg to off and added options
in the dsmserv.opt
allowreorgtable yes
reorgbegintime 11:00
reorgduration 10
when i check in the actlog i see no Reorg related events. Also , the status of
these commands gives no indication of Reorg happening atall
> db2pd -reorgs -db tsmdb1
> db2 list history reorg all for db tsmdb1
Am i missing something?
Please could someone help me out here ..How can i get Online Reorg running in
the TSM DB ??
+----------------------------------------------------------------------
|This was sent by gibin.g AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] Reorg in DB2 TSM V6.2.x,
Gibin <=
|
|
|