Checkpoint and Turn Off Journaling
For each database, including the iidbdb, checkpoint each database and turn off journaling. Then save the configuration file.
The upgradedb process turns off journaling, so it is best to turn if off now. If upgradedb fails, you can use this checkpoint to recover and try again.
To checkpoint and turn off journaling
1. Checkpoint each database, using the ckpdb command with -j option to turn off journaling. Issue the following command:
ckpdb -d -j dbname
Note: For the iidbdb, use the ckpdb -s option. The iidbdb database does not have an "unload" directory.
2. Save the configuration file stored in the dump area after each checkpoint. The configuration file is small. Issue the following command:
cp $II_DUMP/ingres/dmp/default/dbname/aaaaaaaa.cnf {somewhere secure}