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.00, 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. +--
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.00, 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. +--
copygroups
Is there a way to tell if a given copygroup is actually being used on TSM 6.2.2? David Ehresman
TSM and DB2 control center
Hi, Can the TSM database be managed from remote DB2 control centers (GUI)? Thanks.
Re: Reorg in DB2 TSM V6.2.x
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.00, 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. +--
Re: copygroups
AFAIK, the only way is to search the BACKUPS table. OK idea if you can narrow the search to a single client at a time; bad idea otherwise. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] copygroups Is there a way to tell if a given copygroup is actually being used on TSM 6.2.2? David Ehresman
Re: copygroups
If a session tries to use a non-existent copygroup, does it fail or does it use the default for that management class? David Prather, Wanda wprat...@icfi.com 7/14/2011 1:12 PM AFAIK, the only way is to search the BACKUPS table. OK idea if you can narrow the search to a single client at a time; bad idea otherwise. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] copygroups Is there a way to tell if a given copygroup is actually being used on TSM 6.2.2? David Ehresman
Re: copygroups
It should bind to the default management class I think. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 4:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: copygroups If a session tries to use a non-existent copygroup, does it fail or does it use the default for that management class? David Prather, Wanda wprat...@icfi.com 7/14/2011 1:12 PM AFAIK, the only way is to search the BACKUPS table. OK idea if you can narrow the search to a single client at a time; bad idea otherwise. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] copygroups Is there a way to tell if a given copygroup is actually being used on TSM 6.2.2? David Ehresman
Re: copygroups
On my TSM 5.5 server, 6.2.1 Windows client: I just tried to do an archive from a client in a domain after deleting the archive copy group from the applicable mgmt. class. Result was failure: ANS1264E The active policy set does not contain any archive copy group. The arch ive operation cannot continue.tsm W -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 4:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] copygroups If a session tries to use a non-existent copygroup, does it fail or does it use the default for that management class? David Prather, Wanda wprat...@icfi.com 7/14/2011 1:12 PM AFAIK, the only way is to search the BACKUPS table. OK idea if you can narrow the search to a single client at a time; bad idea otherwise. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David E Ehresman Sent: Thursday, July 14, 2011 9:22 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] copygroups Is there a way to tell if a given copygroup is actually being used on TSM 6.2.2? David Ehresman
Backup Exchange 2010 with DAG
Dear all, We are currently implementing an Exchange 2010 in our environment. We plan to have 5-6 mailboxes servers 2-3 client access server and the same for the HUBs. Now I’m, testing Tivoli for mail (exchange) version 6.x using only one mailbox server. When we will enable our DAG, what will be the best practice to backup all mailboxes database? Do I have to install the TDP on each mailbox server? Is this will require separate node on the TSM server (one for each mailbox server)? If some people already has knowledge on how to setup such environment, can you just drop me an e-mail to explain me the way you did it? Thank you all and best regards, Yanick Quirion Technicien en Systèmes Ordinés - Section Infrastructure des serveurs Service des technologies de l’information (S.T.I.) Université de Sherbrooke Courriel: yanick.quir...@usherbrooke.camailto:yanick.quir...@usherbrooke.ca Tél.: 819-821-8000tel:819-821-8000 Poste: 62490
