In article <1jhtqnINN9su@emory.mathcs.emory.edu>,
RUCHI%CFRVM.bitnet@CUNYVM.CUNY.EDU (Ruchi Patel) writes:
|> We upgraded the SQL, 4GL and SE from 4.0 to 4.1 with 5.0 SE. I can't seem
|> to select the old database from new version of Informix. I get the
|> following error:
|>
|> 312: Cannot update system catalog (systables).
|> 107: ISAM error: record is locked.
On my hardware platform (sun4), the upgrade from 4.0 involved changing lock
methods. This was mentioned in the release notes.
My notes don't mention what the error message was, but, like you, I wasn't
able to open the database at all.
I don't know if this is what you're seeing, but you could try the following:
setenv RESETLOCK
Go into isql. If you can now open the database, do so, and run update statistics.
Then exit isql, and
unsetenv RESETLOCK
If you still can't open the database when RESETLOCK is set, then your problem
is a different one.
Good luck!
--
Harry Bochner
bochner@das.harvard.edu