DB2 logging factors and mincommit

09 February,2011 by Jack Vamvas

 Despite choosing logging option (either Circular logging or retain) – every  “standard” data and index change is made to the log buffer. The log buffer is then written to disk by the logger process.

 In the situation of COMMIT the query processing has to wait for the data to be written to disk – this is a potential performance factor

 The process is based on maximum throughput , and on analysis you can see that most of the time will be spent on the COMMIT phase  and related I\O delays . This is compounded in an OLTP process – characterised by many short transactions- and by implication ,COMMIT.

 One tactic to minimise this problem is to use mincommit > 1 . The purpose of mincommit is to delay the  write to disk of the log records. The count is the number of commits.

 Depending on your app , you may have  to consider increasing logbufsz

 Test thoroughly prior to implementing on a Production server. I’ve had some good results implementing this for Webspher Porcess Server interactions with DB2

 Source:Jack Vamvas(http://www.dba-db2.com)

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 logging factors and mincommit

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright