HCL Workload Automation, Version 9.4

Upgrading your database

About this task

If you want to upgrade your database, change the instance owner, or relocate it to a different host, the procedure for upgrading your database, changing the instance owner, or relocating it, is as follows:
  1. If you are changing DB2®, check the node directory and database directory and make a note of the current configuration. To do this, issue the following commands at the DB2 command-line:
    db2 list node directory show detail
     
    db2 list database directory
    where the show detail attribute is specified to give the full information in the directory.

    Make a note of the displayed details.

  2. Stop the application server, using the command
    stopWas -direct -user <user> -password <password>
  3. Make the upgrade, instance owner change, or relocation, of the database following the instructions from your database supplier.
  4. If you have changed the database host, port, or database name, you will need to update the application server's data source properties, as described in Changing the database host name, port, or database name.
  5. If you have changed the database access credentials, you will need to update the application server's security properties, as described in Changing the security settings.
  6. Reconfigure the database for HCL Workload Automation, as follows:
    DB2
    1. Check the node directory and database directory, as you did in step 1
    2. If necessary, modify the data displayed by these commands to match the data you noted in step 1. If you are not certain of how to do this, contact HCL Software Support for assistance.
    Oracle
    Check the Oracle Listener and make sure that the service name is correctly specified.
  7. Restart the database.
  8. Restart the application server, using the command:
    startWas -direct -user <user> -password <password>