Checkpoint and Turn Off Journaling
For each database, including the iidbdb, checkpoint each database and turn off journaling. Then save the configuration file.
To checkpoint and turn off journaling
1. Checkpoint each database, using the ckpdb command with –j option to turn off journaling. (The upgradedb process turns off journaling, so it is best to do that now.) If upgradedb fails, you can use this checkpoint to recover and try again.
Issue the following command:
ckpdb -d -j dbname
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}