Run the upgradedb utility to upgrade databases. You can upgrade databases one at a time or all at the same time. Log the upgradedb output to a file.

Before running the upgradedb utility for encrypted databases, ensure that the encrypted databases are unlocked to provide access to the upgradedb command.

Databases, including encrypted databases, cannot be accessed before the upgrade. Encrypted databases must be unlocked by connecting to the iidbdb database (master database) and by running the ENABLE PASSPHRASE statement on the respective encrypted databases.

This requires that the iidbdb database is already upgraded.

For example:

As the installation owner, connect to iidbdb using the Terminal Monitor.

In the database session connected to iidbdb, run the ENABLE PASSPHRASE statement for the encrypted database.

If you have multiple encrypted databases, run the ENABLE PASSHRASE statement for each encrypted database with the respective passphrase. After unlocking the encrypted databases, upgrade them using the upgradedb utility.

To upgrade one database at a time:

To upgrade all databases at the same time:

Example of logging upgradedb output to a file:

To complete the upgrade of the encrypted databases after running the upgradedb utility, it is necessary to again unlock the database. Currently, the ENABLE PASSPHRASE statement needs to be run in a session that is directly connected to the encrypted database (not via a connection to iidbdb).

As the database owner, connect to the encrypted database using the Terminal Monitor.

In the database session run the ENABLE PASSPHRASE statement for this database.

If you encounter any errors, see chapter “Troubleshooting Upgradedb” correct the errors and rerun the upgradedb utility.