1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TDP configuration for an Active/Active SQL2008 cluster

Discussion in 'Microsoft SQL Server' started by Me-Cyclist, May 19, 2010.

  1. Me-Cyclist

    Me-Cyclist New Member

    Joined:
    May 19, 2010
    Messages:
    3
    Likes Received:
    0
    Location:
    Maine
    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.
     
  2.  
  3. TonyB

    TonyB Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    384
    Likes Received:
    9
    Location:
    Sydney, Australia
    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
     
  4. Me-Cyclist

    Me-Cyclist New Member

    Joined:
    May 19, 2010
    Messages:
    3
    Likes Received:
    0
    Location:
    Maine
    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: May 20, 2010
  5. TonyB

    TonyB Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    384
    Likes Received:
    9
    Location:
    Sydney, Australia
    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)
     
  6. Me-Cyclist

    Me-Cyclist New Member

    Joined:
    May 19, 2010
    Messages:
    3
    Likes Received:
    0
    Location:
    Maine
    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
     
  7. amjain

    amjain New Member

    Joined:
    Dec 8, 2011
    Messages:
    11
    Likes Received:
    0
    Hi,

    Can you please post the steps that were done for the configuration.

    Thanks
    Amit
     

Share This Page