There are a few steps you have to take to make sure this works:
1. install the TDP on both nodes of the cluster (in the same directory path on
each box).
2. Setup the dsm.opt file in a directory on a clustered disk.
3. run the TDP and initialize the password in the registry. (and make sure
it's going to work)
4. install the TDP service using something like this for the command line:
dsmcutil inst /name:"TSM TDP SqlSchedule Cluster <SQLNODENAME>-CL-SQL"
/node:<SQLNODENAME>-CL-SQL /password:whatever /autostart:no
/clientdir:"c:\Program Files\Tivoli\TSM\baclient" /optfile:"Q:\TSM\SQL\dsm.opt"
5. Fail over to the other node and again install the services with the exact
same parameters.
6. Add the generic service to your Fail over cluster Group, and test.
Make sure to add the registry key to be replicated:
SOFTWARE\IBM\ADSM\CurrentVersion\Nodes\<SQLNODENAME>-CL-SQL\TSMSERVER1
Then set the options to have the generic service NOT cause a failover
if it can't run.
Of course have the clusternode yes, and other cluster options setup in the
dsm.opt file.
I have several of these setup, and they fail over and back pretty well. There
was a version of the TDP/BA client that would "eat" the password and then fail
to start the scheduler, but I think that has been fixed in latter versions.
See Ya'
Howard Coles Jr.
John 3:16!
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill
Boyer
Sent: Wednesday, January 25, 2012 8:59 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Windsows 2008 failover cluster, SQL Server and TSM
Windows 2008 R2 failover cluster with SQL as a resource. All the cluster
disks are "owned" by the SQL resource. I need to install a client scheduler
for the cluster backups. The documentation for doing that is assuming you
will just be doing backups of the cluster drives and adding the generic
resource you add the cluster drives so it all fails over together.
I need to make it so that the generic service is part of the SQL resource
and gets failed over with that. Anyone out there done this type of
configuration? I have the generic service installed and the TDP SQL backups
run fine, but last night the SQL resource failed over and my service didn't.
Have failed SQL backups this morning.
If I try to add a generic service to the SQL resource, it doesn't appear to
give me the option to replicate registry keys.
Any help would be appreciated.
Bill Boyer
DSS, Inc.
(610) 927-4407
"Enjoy life. It has an expiration date." - ??
DISCLAIMER: This communication, along with any documents, files or attachments,
is intended only for the use of the addressee and may contain legally
privileged and confidential information. If you are not the intended recipient,
you are hereby notified that any dissemination, distribution or copying of any
information contained in or attached to this communication is strictly
prohibited. If you have received this message in error, please notify the
sender immediately and destroy the original communication and its attachments
without reading, printing or saving in any manner. Please consider the
environment before printing this e-mail.
