Errors in diag log

[Venkatesh Subbaramu]

Hi, I found the folowing errors in my diag log

ADM5500W DB2 is performing lock escalation. The total number of
locks
currently held is "1031", and the target number of locks to hold is
"515".

ADM1823E The active log is full and is held by application handle
"84".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
Please advise the course of action .

Thanks for your help,
Venky
------------------------------------------------------------------------
IT Interview Questions : http://www.geekinterview.com IT Tutorials and Articles : http://www.geekarticles.com Oracle and Oracle Apps Training : http://www.exforsys.com

[Serge Rielau]

Venkatesh Subbaramu wrote:

Hi, I found the folowing errors in my diag log

ADM5500W DB2 is performing lock escalation. The total number of
locks
currently held is "1031", and the target number of locks to hold is
"515".

ADM1823E The active log is full and is held by application handle
"84".
Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.
Please advise the course of action .

Could it be you are running with the default DB configuration?
Increase the lock parameter by a factor of 10 for starters (it's cheap
and really low to begin with, so aunless you are running on a pocket
calculator it's barely worth worrying about the memory)
Also, if you only have a few connections increase the percentage of the
locks a given connection is allowed to hold (the default is 10%).

On the log side, assuming you aren't simply "forgetting" to commit
increae the filesizes.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab