CISAM and bcheck
Posted in 1999
Topics: Installation, Setup & Upgrades
ello I am using C-ISAM 5.02 UC1 Version , Which i think is no more supported by informix . We were using it successfully without any trouble until somebody introduced bcheck in the database healthcheck script . I got the following error message for .idx and .dat files ------------------------------------ Checking dictionary and file sizes. Index file node size = 1024 Current C-ISAM index file node size = 1024 Checking data file records. Checking indexes and key descriptions. Index 1 = unique key (0,52,0) 59 index node(s) used -- 3 index b-tree level(s) used Index 2 = duplicates (52,2,1) 20 index node(s) used -- 2 index b-tree level(s) used Checking data record and index node free lists. ERROR: 1 missing data record pointer(s) Fix data record free list ? no ----------------------------------------- I am assuming this is a situation in which you have the data part available and index missing . I like to findout the following things . 1. If there is no crash in system how this inconsistency can occur . Is a related Bug is there in version 5.02 . Where can i access the Bugs corrected for 5.02 to 5.1 I canot afford to lose the data by allowing bcheck to repair the database . 2. If I want to List the contents of index and data files corresponding to my data structure , is there a utility available . I may be able to ocalise the problem if i can list the content of the troubled portion. 3. If i want to replace to a newer version of C-ISAM what is the risk involved and what is a suggested version without compromising on speed . ( We like to upgrade only if it is a version related problem ) 4 . What bcheck is doing really ? , is it advisable on an active system . Please Help me Jaile Sebes