ADSM-L

Re: TSM TDP for MS SQL in a cluster

2004-05-26 08:12:02
Subject: Re: TSM TDP for MS SQL in a cluster
From: Neil Schofield <neil.schofield AT YORKSHIREWATER.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 26 May 2004 13:05:51 +0100
Yiannakis

I'm not sure exactly where the problem lies, but would make the following
observations:

- When using DSMCUTIL INSTALL, you should specify /CLUSTERNODE:YES
/CLUSTERNAME:FUNDTCLR on both nodes in addition to specifying CLUSTERNODE
YES in the DSM.OPT.

- I'm assuming this is an Active/Passive SQL Cluster, ie the SQL Server
instance FUNDTSQL is the only instance and can switch between nodes. In
this case it's doubtful you want the TDP Scheduler service starting
automatically on both nodes. It would be better to specify /AUTOSTART:NO
and create a generic cluster service within MSCS Cluster Admin in the same
group as the virtual SQL Server. This would then start the Scheduler
accoring to which node the SQL Server was running on.

- Running scheduler's concurrently on both nodes of the cluster with
PASSWORDACCESS set to GENERATE means that upon password expirartion, one
node will change the password and cause the service on the other node to
fail. With a generic service cluster resource, you can configure the
properties of the service to replicate the registry key
Software\IBM\ADSM\CurrentVersion\BackupClient\Nodes\FUNDTSQL which is where
the encrypted password is stored.

- Unless your Virtual SQL Server resource is in the same group as your
clustername, you probably want to change the FROMSQLSERVER parameter in the
TDPSQL.CNF to FUNDTSQL.

Regards
Neil Schofield
Yorkshire Water Services Ltd.





Download walks around Yorkshire Water's reservoirs at
http://www.yorkshirewater.com/yourenjoyment/main_walk.html
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682

<Prev in Thread] Current Thread [Next in Thread>