Moving the License Metric Tool database

To move the License Metric Tool database to a different computer, back up the database, move it to the target computer, and update the database connection setup.

1. Stop the License Metric Tool server.
2. Back up the License Metric Tool database.
   • Backing up the DB2 database.
   • Backing up the MS SQL Server database.
3. Move the database to the target computer and make it operational.
4. Update database connection parameters.
   • For application update 9.2.30 and later, run the SetupDatabase script and update the database location. For more information, see: Changing database connection parameters.
   • For application update 9.2.29 and earlier, perform the following steps.
     1. Back up the following files from the installation directory of the License Metric Tool server.
        • installation_directory/wlp/usr/servers/server1/server.xml
        • installation_directory/wlp/usr/servers/server1/config/database.yml
     2. Update the database location in the server.xml file. Provide the IP address or domain name of the computer on which the database is located.
        • DB2 database

          
          <properties.db2.jcc 
          password="{aes}xxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXX" 
          user="db2inst1" 
          serverName="localhost"
          databaseName="temadb"/>

        • MS SQL Server database

          
          <properties.microsoft.sqlserver 
          password="{aes}xxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXX" 
          user="sa"
          serverName="localhost" 
          databaseName="temadb"/>

     3. Update the database location in the database.yml file. Provide the IP address or domain name of the computer on which the database is located.

        host: localhost
        database: temadb
        database_type: mssql
        windows_authenticated: true

     4. Start the License Metric Tool server.