Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

how ADM1822W  could happen?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shenanwei@gmail.com - 01 Mar 2006 18:04 GMT
I noticed this in db2diag.log. Could somebody explain how this could happen?
ADM1822W  The active log is being held by dirty pages.  This is not an
error,  but database performance may be impacted.  If possible, reduce
the database work load.  If this problem persists, either decrease the
SOFTMAX and/or increase the NUM_IOCLEANERS DB configuration parameters.
Thanks.
Pierre Saint-Jacques - 01 Mar 2006 20:57 GMT
This is a warning message. It means that:
The active logs has transactions in it that are committed but not
externalized.  That's what a dirty page is: a change has been processed in
it, the change has been committed but the page has not been externalized
back in its physical location on disk.

The transaction is in the log file but the log file has to remain active
until all trans. have been either rolled back or committed AND externalized.

SOFTMAX causes some externalization to happen when it is hit. Default value
100% of a log file size.
NUM_IOCLEANERS is a parm, default value 1, that determines the number of
processes that can be dispatched to clean, meaning externalize, data pages
to their location.  They're like janitors; if you don't have enough of them
in the school, the classroom stay dirty too long and you can't use them.
SOFTMAX is one of the foremen who dispatches the janitors.

HTH,  Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> I noticed this in db2diag.log. Could somebody explain how this could happen?
> ADM1822W  The active log is being held by dirty pages.  This is not an
> error,  but database performance may be impacted.  If possible, reduce
> the database work load.  If this problem persists, either decrease the
> SOFTMAX and/or increase the NUM_IOCLEANERS DB configuration parameters.
> Thanks.
 
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.