[ADSM-L] Reorg in DB2 TSM V6.2.x

2011-07-14 02:26:19
Subject: [ADSM-L] Reorg in DB2 TSM V6.2.x
From: Gibin <tsm-forum AT BACKUPCENTRAL DOT COM>
Date: Wed, 13 Jul 2011 23:21:40 -0700
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>