In 6.2.2.30, do the allowreorgtable and related options appear when the Q OPTIONS or Q STATUS (or some other command) is issued?
I don't see them, or my bifocals are hiding it. ------------------------------------------------ Harold Vandeventer Systems Programmer State of Kansas - DISC harold.vandeven...@da.ks.gov (785) 296-0631 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Christian Svensson Sent: Thursday, July 14, 2011 4:07 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SV: Reorg in DB2 TSM V6.2.x Does the TSM Server Service Instance user have DB2 Admin Access? Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms ________________________________________ Från: Gibin [tsm-fo...@backupcentral.com] Skickat: den 14 juli 2011 08:21 Till: ADSM-L@VM.MARIST.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 gibi...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +----------------------------------------------------------------------
