Upgrade problem: 2.1 to SE 5.03, 211: Cannot read ... (sysindexes)
Posted in 1996
Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting
I need a hint. I'm trying to convert several old (really old) Informix 2.1
databases to Informix SE v.5.03. I don't have any direction from Informix
on an upgrade procedure, so I'm simply copying the entire .dbs directory to
the new SE5 area, and accessing the tables without conversion.
This worked on two entire databases, and worked for most tables on three
others. However, for several tables, I get the following error if I try
to do just about anything via "isql":
211: Cannot read system catalog (sysindexes)
111: ISAM error: no record found
The tables seem fine under 2.1 isql. I've tried bcheck on the tables both
from the 2.1 package and the SE5 package. While they both report and correct
several errors, they don't affect whether SE5 can use the tables or not.
I can't see any pattern to which tables work and which don't I think that
the oldest tables are most likely to have problems, but I can't pin that
down. I also used bcheck on sysindexes. This made no difference. We're
using SCO UNIX now; the tables were all created on SCO Xenix if that matters.
If anyone has a magic answer, or can even point me in the right direction,
I would really appreciate it. Thank you.
--Perry Martin
------------------------------------------------------------------------
Perry Martin martin@netins.net
Martin & Martin Computer Services