Clean iidbdb Database
Note: This step is required only for an in-place upgrade.
To clean the iidbdb database
As the installation owner, run the following steps against the master database iidbdb:
Note: It is assumed that there are no objects created by users in the iidbdb.
sysmod iidbdb
verifydb -mrun -sdbname iidbdb -opurge
verifydb -mrun -sdbname iidbdb –odbms
ckpdb –j iidbdb
The verifydb command may issue the following messages, which you can ignore:
S_DU1611_NO_PROTECTS iirelation indicates that there are protections for table (owner), but none are defined.
S_DU0305_CLEAR_PRTUPS Recommended action is to clear protection information from iirelation, and S_DU1619_NO_VIEW iirelation indicates that there is a view defined for table (owner), but none exists.
S_DU030C_CLEAR_VBASE Recommended action is to clear view base specification from iirelation.
You can also ignore the “patch warning” message that warns of the loss of user tables in “runinteractive” mode. This mode will not be used.