Hi All

Hope there is still a few people running or knowing something about this
old dinosaur of ours.

I am getting index corruption from time-to-time on one of your main
tables (486000 records). This table is being accessed for reports and
maintenance ever minute of the day, especial over month ends.

The SE-Admin manual is talking about the secheck utility, but I am
having a gut feeling this was for SE7 (not for our release). I can’t
find the secheck on our software or in the Informix bin directory.

So currently to solve the problem on the index corruption, I need to
unload the data, drop the table and recreate the table and indexes. But
this takes the system down for half a day and I don't know if this is
the best practice.

Any ideas? And don’t try the “update Informix”, that is a big no-no
option. Is there any settings I can set to improve the systems working?
Man how do I miss the online tools.
Do anybody know where I can get the secheck util, and if it will work
for us?
Even IBM is playing that upgrade card on this old monster.

SCO Unix 5.0.5
Informix SE 4gl and SQL version 4.17.UC1

bcheck reports:
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 index node(s) used -- 1 index b-tree level(s) used
Index 2 = unique key (0,1,0) (1,4,2) (5,4,2)
9132 index node(s) used -- 4 index b-tree level(s) used
Index 3 = duplicates (18,4,2)
10124 index node(s) used -- 4 index b-tree level(s) used
Index 4 = duplicates (5,4,2)
8263 index node(s) used -- 4 index b-tree level(s) used
Index 5 = duplicates (27,6,0)
12659 index node(s) used -- 4 index b-tree level(s) used
Index 6 = duplicates (26,1,0)
4696 index node(s) used -- 3 index b-tree level(s) used

ERROR: 1 duplicate data record pointer(s)

Thanx
Franz
www.bybelgenootskap.co.za / www.biblesociety.co.za

DISCLAIMER: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.