Upgrade a DB2 external runtime database (for appliance versions earlier than 9.0.0.0)

If DB2 is the external runtime database, upgrade it after you install the appliance upgrade so that we are using the correct .sql file version. Attention: Use this task only if we have not installed v9000. The updates to the .sql file for each release are not cumulative. Therefore, depending on which version of the isam_access_control_db2_update_v*.sql file you installed, make the following updates:

• v8004.sql not installed: First upgrade to v8004, then to v8005, and finally to v9000.
• v8004.sql is installed: Upgrade to v8005 and then to v9000.
• v8005.sql is installed: Upgrade to v9000.

Use this task to install each version we require, replacing references to isam_access_control_db2_update_v9000.sql with the version number we are upgrading to each time, and starting with the earliest version we require.

Steps

1. Log in to the local management interface.

2. Click System > File Downloads.
3. Expand access_control > database > db2 > runtime.

4. Select isam_access_control_db2_update_v9000.sql

5. Click Export.

6. Save the file.
7. Open the isam_access_control_db2_update_v9000.sql file in an editor on the DB2 server.
8. Replace the following macros with the values specific to the environment:

   &DBINSTANCE

   The name of the DB2 instance.

   &DBUSER

   The name of the DB2 administrator.

   &DBPASSWORD

   The password for the DB2 administrator.

9. Save the changes.
10. Log in to the DB2 Command utility (Windows) or DB2 host (UNIX) as the DB2 administrator.
11. Run the following command:

    db2 -tsvf fully_qualified_path_to_script

    The following example shows the fully qualified path to the script:

    db2 -tsvf tmp/isam_access_control_db2_update_v9000.sql

12. Validate the tables were successfully updated.
13. Ensure that no errors were returned during the update and log in to the database to manually check the tables exist.

Parent topic: Upgrade configuration