Does the TSM Server Service Instance user have DB2 Admin Access?

Best Regards
Christian Svensson

Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Supported Platform for CPU2TSM:: 
http://www.cristie.se/cpu2tsm-supported-platforms

________________________________________
Från: Gibin [tsm-forum AT BACKUPCENTRAL DOT COM]
Skickat: den 14 juli 2011 08:21
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Reorg in DB2 TSM V6.2.x

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.
+----------------------------------------------------------------------