Troubleshooting
Problem
You notice Index corruption on restoring data using onload.
Symptom
oncheck -cI will show corruption similar to what is specified below:
- Validating indexes for testdb:informix.tab1...
Index 698_3576
Index fragment partition ta_dbs in DBspace ta_dbs
WARNING: No data row exists for btree item.
Btree item contains fragid 0x800375 rowid 0x1fa01, key value:
Key: 5625:
It's possible this is a transient issue. Please run oncheck -cIx on this index.
ERROR:No btree item exists for data row.
Fragid 0x800375 Rowid 0x231701 contains key value:
Key: 5625:
ISAM error: illegal key descriptor (too many parts or too long).
Index esec_exchg_tick_ix
Index fragment partition ta_dbs in DBspace ta_dbs
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF022","label":"OS X"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.1;11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
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.
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21637056