Unanswered: Warning: active log held by dirty pages.
Recently i have been getting this message in my db2diag.log.
This occurs once a week at a paricular time(12:30 midnight) ,not on a particular day.I checked ,at this particular time there is no particular scheduled actions as backups or so.
I tried adjusting the values many times,still now i am recieving the error.
Below i have extracted a portion of the log file for your reference.
What is soft max,when i read it stated - This is used to influence the number of logs that need to be recovered following a crash and determine the frequency of soft checkpoints. Range [1-100*logprimary]Percentageof one primary log file.
So this means if i set softmax=80,with primary log file size 250*4K
what is the number of log files to be recovered following a crash .
is it 80*250*4/100=800 logfiles or
I usually delete all the log files that are obsolete(that before a offline backup).
Will this create problems?
How does this parameter also affect the frequency of soft checkpoint?so if i decrease the values the softcheckpoint also decreases,there by holding the logfiles for more time.Is this what i have understood correct or wrong.
According to your db cfg, the logfilesize is 1m. To my knowledge, softmax works as
100% means 1 log file(1MB in your case), 60% means .6 of a log file or (600KB in you case).
Which means that if the database crashes, db2 will have 600KB of uncommitted to disk changes in the logfile to go through(also called crash recovery) when it comes up.
In my opinion, the error in the diag is due to a fraction of the logfile being specified for commits to disk. ie, when it the changes in the logfile exceed 600KB, it is trying to commit those transactions but 40% of the logfile has dirty pages. Just my opinion. Try increasing this value to 100 and see if it recurs.