Re: problems with table locking

In article <32f759bd.13839680@news.mindspring.com>, Sheila Higgins <shiggins@mindspring.com> writes >shiggins@mindspring.com (Sheila Higgins) wrote: > >>I have two questions. I am running informix online and I have some >>tables locked (I queried the syslocks table in sysmaster). The first >>question is how do I remove the locks? The second questions is is >>this why whenever I attempt to exit the dbaccess utility, it hangs? I get the same problem - strange, dbaccess does not accumulate CPU time either. I could not see the session in onstat -u - I'm confused. Ctrl-C gets you out of it though. >>(I have several databases; only 2 of them have locks. Yet dbaccess >>hangs whenever I exit regardless of which database I have accessed). >> >> > >More Information: >There were applications that ran against the locked tables that >terminated abnormally, and did not release the locks for the tables. Under online the locks are automatically freed by the engine. >My error is #252, ISAM error 113. 'finderr 252' refers to two >utilities called 'bcheck' and 'secheck', neither of which I have. >I'm assuming that there is an equivalent tools for releasing locks on >online tables. > tbcheck (Online 5) oncheck (Online 7). oncheck -cr Check reserved pages oncheck -ce Check entexts oncheck -cc <database name> Check system catalogs oncheck -CID <database> Check all index and data pages in the database. >Thanks to anyone who can help. You can either post or send email to >shiggins@mindspring.com. > -- David Williams