Re: Informix 7.31, oncheck and locking
This is a discussion on Re: Informix 7.31, oncheck and locking within the Informix forums, part of the Database Server Software category; --> On Thu, 10 Jul 2003 10:10:18 -0400, Matt wrote: Adjacent key locks on systables indexes, likely. Art S. Kagel ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 07:08 PM
| ||||
| ||||
 Re: Informix 7.31, oncheck and locking On Thu, 10 Jul 2003 10:10:18 -0400, Matt wrote: Adjacent key locks on systables indexes, likely. Art S. Kagel > Hi, > > In an attempt to get a full set on table level onchecks run in a > reasonable time (using -cdi options) I have split the job into three > parallel jobs each checking a distinct set of tables. > > I am getting locking problems, oncheck just reports a message like > 'could not obtain lock for <tablename>' > > Any ideas as to what might be causing this ? > > Thanks, > Matt      |
|
04-19-2008, 07:09 PM
| ||||
| ||||
| Re: Informix 7.31, oncheck and locking Thanks Art, do you know any way around this ? "Art S. Kagel" <kagel@bloomberg.net> wrote in message news  an.2003.07.10.19.05.05.284450.15473@bloomber g.net...> On Thu, 10 Jul 2003 10:10:18 -0400, Matt wrote: > > Adjacent key locks on systables indexes, likely. > > Art S. Kagel > > > Hi, > > > > In an attempt to get a full set on table level onchecks run in a > > reasonable time (using -cdi options) I have split the job into three > > parallel jobs each checking a distinct set of tables. > > > > I am getting locking problems, oncheck just reports a message like > > 'could not obtain lock for <tablename>' > > > > Any ideas as to what might be causing this ? > > > > Thanks, > > Matt |
Linear Mode
