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.

If errors occur, please see Troubleshooting Upgradedb Problems. Correct the errors and rerun the upgradedb utility.

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 directly before the upgrade to unlock them with the ENABLE PASSPHRASE statement. Therefore, encrypted databases must be unlocked by connecting to the iidbdb database (master database) and running the ENABLE PASSPHRASE statement on the encrypted databases in this connection to iidbdb. This lets the upgradedb utility connect to the individual encrypted databases.

After running the upgradedb utility, it is necessary to directly connect to the individual encrypted databases and run the ENABLE PASSPHRASE statement again to complete the upgrade with the passphrase.

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. This time, 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.