Troubleshooting
Problem
C-ISAM 'bcheck' shows errors after inserting rows and using the TCOMPRESS option when an index is built.
Symptom
"ERROR: BAD B-TREE NODE (52) FORMAT"
"ERROR: 2252 missing data record pointer(s)"
Cause
Corruption occurs in the C-ISAM index file after inserting rows using the 'TCOMPRESS' option when an index is built
Environment
C-ISAM 7.26.xC3 or earlier on Unix and Windows
Diagnosing The Problem
Running 'bcheck' on the relevant C-ISAM .dat and .idx files will show the errors
- ERROR: BAD B-TREE NODE (52) FORMAT
- ERROR: nnnn missing data record pointer(s) ( where nnnn is the number of records inserted before corruption occurred )
Resolving The Problem
Contact Technical Support to obtain a Special Build for your platform. The Special Build will
- avoid the corruption occurring in the first place
- allow a corrupt index to be repaired
This is expected to be fixed in the CISAM-7.26.xC5 Interim version when it becomes available
[{"Product":{"code":"SSGKNY","label":"Informix C-ISAM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","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","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
Informix C-ISAM
Software version:
7.2
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
395589
Modified date:
23 July 2019
UID
swg21398076