 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / December 2005Errors in diag log
Hi, I found the folowing errors in my diag log ADM5500W DB2 is performing lock escalation. The total number o locks currently held is "1031", and the target number of locks to hold i "515". ADM1823E The active log is full and is held by application handl "84". Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION. Please advise the course of action . Thanks for your help, Venk ----------------------------------------------------------------------- IT Interview Questions : http://www.geekinterview.com IT Tutorials and Articles : http://www.geekarticles.com Oracle and Oracle Apps Training : http://www.exforsys.com > Hi, I found the folowing errors in my diag log > [quoted text clipped - 8 lines] > > 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  SignatureSerge Rielau DB2 SQL Compiler Development IBM Toronto Lab Thanks very much . I observed that the default value of lock list is 10 which I suppose is low . Is there any other default parameters that will usually need to change ? Thanks again, Venk ----------------------------------------------------------------------- IT Interview Questions : http://www.geekinterview.com IT Tutorials and Articles : http://www.geekarticles.com Oracle and Oracle Apps Training : http://www.exforsys.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.