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:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Thursday, March 06, 2008 4:57 PM To: [email protected] 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: [EMAIL PROTECTED] ----------------------------------------- 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.
