There needs to be duplicate dsm.opt files on each host in the cluster.
'Clusternode yes' should be in each dsm.opt. 'SQLServer' with the SQL cluster
network/instance name should be noted in each tdpsql.cfg. I went through this
very problem last week, I was missing the SQLServer name from the tdpsql.cfg.

It seems like there is a recent Redbook that deals specifically with clusters
(MSCS and HACMP), including configuration. There is a new SQL Redbook, but I
haven't perused it yet.  :)  In the old SQL Redbook, there was some scattered
info, including how to set up a TDP scheduler on a cluster.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, March 06, 2008 4:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] tdpsql.cfg

> You probably already saw this, but just in case...

Nope, missed it completely actually.

Since I have a few more questions might as well keep going. In a cluster
environment it looks like the software is installed on a local disk.
With an active/active cluster, and not really being concerned which
instance is on which node, it seems to indicate that there needs to be
multiple dsm.opt files. But what about this tdpsql.cfg? There seems to
be entries in there that would need modification depending on which
instance on a node. Am I mistaken there? 

By the way, in that sample file SQLSERVer is indicated by only a . so
the question is if this is a cluster what that might need to be and what
if a cluster fails to this node? I'm digging around the manuals as best
I can but it sure would be nice to see a document that has a better
layout of steps that need to be performed on each node in the cluster.
Is there one? I'm trying to test in a cluster environment now so I want
to make sure how these files are laid out in this environment and also
an active/passive setup.

Thanks for the help so far.
 
Geoff Gill 
TSM Administrator 
PeopleSoft Sr. Systems Administrator 
SAIC M/S-G1b 
(858)826-4062 
Email: geoffrey.l.gill AT saic DOT com 

-----------------------------------------
Confidentiality Notice:
The information contained in this email message is privileged and
confidential information and intended only for the use of the
individual or entity named in the address. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this information is strictly
prohibited. If you received this information in error, please
notify the sender and delete this information from your computer
and retain no copies of any of this information.