Clean the Database
To ensure the integrity of the system catalogs, issue the following commands:
sysmod dbname
verifydb -mreport -sdbname dbsf1 -odbms_catalogs
echo "...\g\q" |sql dbname
The verifydb command may issue the following messages; you can ignore them.
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.
If verifydb issues warnings or errors other than those in Step 1, review the messages with Actian Support before upgrading that database, because there may be damage to the system catalog.
Last modified date: 12/19/2024