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:

If errors occur, see the chapter “Troubleshooting Upgradedb.” Correct the errors and rerun the upgradedb utility.