IBM License Metric Tool (ILMT)

 View Only

  • 1.  SQL Server Availability group listeners

    Posted Sun August 11, 2024 04:21 PM

    A new install of ILMT will connect to a remote SQL server database. The company standard for all production databases is to use availability group listeners or cnames for database replication/failover. Are either of these supported for ILMT?



    ------------------------------
    Andrew Felton
    Elyzium
    07768152243
    ------------------------------


  • 2.  RE: SQL Server Availability group listeners

    Posted Mon August 12, 2024 02:46 PM

    We are on LMT 9.2.32 and just use the normal sql server datasource to connect to our availablility group, I don't believe our DBA had to do anything special.  We just specify the database as (fake example) "IBMLMTDB" on sqlconnector1.domain.com. 

    Shawn



    ------------------------------
    Shawn Lamson
    ------------------------------

    Original Message


  • 3.  RE: SQL Server Availability group listeners

    Posted Mon August 12, 2024 03:36 PM
    Theoretically this should be seamless as far as connection string is concerned.
    However never tested by us...
     
    I guess that providing availability group listener DNS name as host name of the database server during Setup database phase should work.
    At last, you can still connect directly to the instance of SQL Server using the instance name of the primary or secondary replica instead of using the availability group listener.
     
     
    Also, there is a dedicated connection option ("MultiSubnetFailover=true") which can be added to ILMT server's server.xml file:
    <properties.microsoft.sqlserver databaseName='temadb' datetimeParameterType='datetime' instanceName='SQLEXPRESS' MultiSubnetFailover='true' ...
    As far as I'm aware it provides some benefit to cope with subnet failover.
    Please be so kind to let us know if the connection setup worked or not....


    ------------------------------
    Thank you,
    Oktawian

    Oktawian Powązka, L3 Support
    IBM License Metric Tool
    ------------------------------

    Original Message