RE: Upgrade problem: 2.1 to SE 5.03, 211: Cannot read ... (sysindexes)

I did a similar update not long ago, however I unloaded the tables, created the database and tables on the new version and reloaded my data from the unloaded files. It seems like a long way around but I didn't have any problems with it. Hope this helps, Eva Ferguson }---------- }From: martin@worf.netins.net[SMTP:martin@worf.netins.net] }Sent: Tuesday, November 05, 1996 2:09 PM }To: informix-list@rmy.emory.edu }Subject: Upgrade problem: 2.1 to SE 5.03, 211: Cannot read ... (sysindexes) } }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 }