Interpreting event alarm messages

we are on 11.7.FC5 on AIX 6.1 seeing many instances of dynamic lock allocation - however, that is the only thing that gets written to the online log and the ph_alert table: "dynamically allocated 1000000 locks" however, the manual states that " if a thread attempts to acquire a lock, but the maximum number of locks that LOCKS specifies has already been reached, the database server writes the following message to the message log: 10:51:08 Lock table overflow - user id 30032, rstcb 10132264 10:51:10 Lock table overflow - user id 30032, rstcb 10132264 Any ideas why the user id is not being written to our logs? thanks tom

Because you have not reached the maximum due to automatic lock table expansion. ;-) That's an old section of the documentation that wasn't updated sufficiently IB. You should only see the lock table overflow message once the maximum number of table doublings (7) has happened or you run of memory to continue expanding the table. The real problem, I'm sure you realize, is what the f^&$ is that user doing that grabbing so many locks? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 14, 2012 at 4:15 PM, <tomcaml@gmail.com> wrote: > we are on 11.7.FC5 on AIX 6.1 seeing many instances of dynamic lock > allocation - however, that is the only thing that gets written to the > online log and the ph_alert table: "dynamically allocated 1000000 locks" > > however, the manual states that > " if a thread attempts to acquire a lock, but the maximum number of locks > that LOCKS specifies has already been reached, the database server writes > the following message to the message log: > > 10:51:08 Lock table overflow - user id 30032, rstcb 10132264 > 10:51:10 Lock table overflow - user id 30032, rstcb 10132264> > Any ideas why the user id is not being written to our logs? > > thanks > tom > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >