Re: [ADSM-L] Reorg in DB2 TSM V6.2.x
2011-07-14 12:55:20
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.Vandeventer AT da.ks DOT gov
(785) 296-0631
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Christian Svensson
Sent: Thursday, July 14, 2011 4:07 AM
To: ADSM-L AT VM.MARIST DOT 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.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.
+----------------------------------------------------------------------
|
|
|