Upgrade the databases (Db2)

You must run all of the upgrade scripts in sequence to upgrade the database schema.

Two of the scripts require DBA privileges: a pre-upgrade script and a post-upgrade script. If you have DBA privileges, you can run all of the scripts. If you do not have DBA privileges, contact your database administrator.

A schema user can run the scripts that do not require DBA privileges.

Pre-upgrade step – DBA tasks

During this step, your database administrator runs a script to prepare the database for the upgrade.

Validate the pre-upgrade step

During this step, you run a script to verify that the pre-upgrade DBA script completed successfully and that the database schema is ready for the upgrade.

Upgrade step

During this step, you run a script to upgrade the database. The script determines the current version of the database schema objects, and then runs the upgrade scripts that are needed to upgrade the database.

Post upgrade step – DBA tasks

During this step, your database administrator runs a script to complete the database upgrade and to set database tuning parameters.

Validate the post-upgrade step

During this step, you run a script to validate the post-upgrade DBA step.