• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDP configuration for an Active/Active SQL2008 cluster

#1
I have two SQl 2008 clusters running in Active/Active mode.

NODE_A1 and NODE_A2 comprise Cluster1 running SQL instance SQLA1 and SQLA2

I also have

NODE_B1 and NODE_B2 comprise Cluster2 running SQL instance SQLB1 and SQLB2

I can use the TDPSQL GUI to see all of the databases in SQLA1 from either NODE_A1 or NODE_A2 regardless of which node is active, but I cannot see SQLA2 from either node in the cluster also regardless of which is active.

Neither of the SQL instances on Cluster2 work in anyway.

How should I have my DSM.opt files, TDPSSQL.opt and shortcuts be configured?

Thanks for any guidance.
 

TonyB

ADSM.ORG Senior Member
#2
I did a little bit of work on this a while back...here's some config steps I have for multi-instance:

Code:
• Copy the tdpsql.smp file, creating one file per SQL instance on the node in the form tdpsql_<instance>.cfg
• Open a command shell in the TDPsql directory and run the TDPsql setup utility once per instance as follows:
    tdpsqlc set sqlserver=<server\instance> /configfile=tdpsql_<instance>.cfg
...

Code:
 3.5.1.1         GUI Startup for multiple instances
It will be necessary to create additional shortcuts in the program menu, at least one per instance configured on the node. 
• Create a new shortcut per instance, named "SQL Client - GUI - <instance>" with the target set 
   to:
     "C:\Program Files\Tivoli\TSM\TDPsql\tdpsql.exe" /configfile=tdpsql_<instance>.cfg
HTH

T
 
#3
Thanks Tony,

I tried your suggestions, but had no luck. I am still able to ru8n TDP GUI for one instance but the second instance I get an error when trying to expand the SQL Server within the GUI ACO5424E

Code:
BUFFers     3
BUFFERSIze     1024
FROMSQLserver     SQLINVENTORY
SQLAUTHentication     INTegrated
SQLBUFFers     0
SQLBUFFERSIze     1024
SQLSERVer     SQLINVENTORY
STRIPes     1
LOGFile     tdpsql-inventory.log
LOGPrune     30
MOUNTWaitfordata     Yes
DIFFESTimate     20
 
*****       Server     Database        BU Type    BU Dest   Management Class Name
VSSPOLICY   *          *               *          TSM       MC_TSM_1
VSSPOLICY   *          *               *          LOCAL     MC_LOCAL_1
VSSPOLICY   *          "Special DB"    *          TSM       MC_TSM_SPECIAL
VSSPOLICY   *          "special DB     *          LOCAL     MC_LOCAL_SPECIAL
VSSPOLICY   SQLSRV1    *               *          TSM       MC_TSM_2
VSSPOLICY   SQLSRV1    *               *          LOCAL     MC_LOCAL_2
 
LASTPRUNEDate     05/20/2010 08:58:56
BACKUPMethod     LEGACY
LANGuage     ENU
My Shortcut for launching the GUI is
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe" /CONFIGfile=tdpsql-inventory.cfg

The only difference I can see is the text within the cfg files.
 
Last edited:

TonyB

ADSM.ORG Senior Member
#4
I think I've run into ACO5424 once before... it may be that you need to enable the named pipe communication method within the instance thats failing (this is the method that enables INTegrated SQLAUTHentication)

Hmm then again you're presumably able to get to the database using the commandline client? (tdpsqlc query sql /config=blah)
 
#5
Thansk again Tony, I do have Named Pipes enabled. I haven't actually tried to use the command line.

I'm under a tight time crunch with this project, so I'll have to contact IBM support.

Thank you much
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 12 15.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 48 63.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.8%
  • Other (please comement)

    Votes: 7 9.2%

Forum statistics

Threads
31,344
Messages
133,509
Members
21,469
Latest member
guidocaffa
Top