SAP Note 24253 - OnArchive: Inconsistencies in OnCatlgr tables

Symptom:

The Informix backup tools OnArchive and Autovop do not carry out actions properly even though the hardware is OK.
For example, archive requests by the OnCatlgr are not deleted although the expiry date is already exceeded.

Cause and prerequisites

Inconsistencies have arisen in the OnCatlgr tables due to unusual events, for example, cancellation of OnCatlgr during the current operation.

Solution

To eliminate the inconsistencies, please proceed as follows:

• Stop the OnCataloger stop_oncatlgr

• Execute the script "arc_purge" to eliminate the inconsistencies dbaccess -e - $INFORMIXDIR/etc/arc_purge.sql

• Start the OnCataloger again start_oncatlgr

• Make sure that no requests have the status 'New' onarchive 'list/req=*/status=new/user=*'

• Start Autovop so that all requests which have exceeded the expiry date are deleted start_autovop

• If you can not cancel requests with the status 'New' or 'Executing' with onarchive 'cancel/req=' your only option is to set it to 'Failed' status manually:
  dbaccess sysmaster - << !
  update arc_request set req_status = 'FA' where req_rid = ;
  !

• You can remove all request with 'failed' status as follows: onarchive 'remove/failed_request'

For all other inconsistencies it is necessary to drop and recreate all concerned vsets/volumes.
Please make a new level 0 archive of the database!