IBM Support

Database backup errors regarding compver table

Troubleshooting


Problem

During regularly scheduled backups the command performs an oncheck and the compver table error can be detected while performing the oncheck call when using IBM Rational Synergy.

Symptom

Checking Informix Database "xxxxdb"...

Checking Table Space data ...
Checking Catalogs and Indexes ...

WARNING:No syssyntable records found.

Validating indexes for xxxxdb:informix.syserrors...

ERROR: Keys in node 0x4 are not in order.

ERROR: Index cv_name for xxxxdb:ccm_root.compver is bad.

Corruption found in Informix database /ccmdb/xxxxdb/db.

Checking Number of Extents ...

WARNING: summary of INFORMIX oncheck output has been saved in

        '/tmp/ccmdb_check_inf_16590'

Contents of '/tmp/ccmdb_check_inf_16590' :

Validating indexes for xxxxdb:ccm_root.compver...

 Index cv_id

   Index  fragment partition ccm in DBspace ccm

 Index cv_name

   Index  fragment partition ccm in DBspace ccm

ERROR: Keys in node 0x4 are not in order.

ERROR: Index cv_name for xxxxdb:ccm_root.compver is bad.

 Index cv_cvtype

   Index  fragment partition ccm in DBspace ccm

Please Drop and ReCreate Index cv_name for xxxxdb:ccm_root.compver.

[{"Product":{"code":"SSC6Q5","label":"Rational Synergy"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Informix Dyn Srvr V10.0 for Synergy","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.2.0.2;7.2.0.1;7.2;7.1a;7.1.0.6;7.1.0.5;7.1.0.4;7.1.0.3;7.1.0.2;7.1.0.1;7.1;7.0;6.6a;6.5a;6.5","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
22 December 2020

UID

swg21600852

Page Feedback