Performance Advice from a Mysterious Friend, Part 5
April 16, 2008 Ted Holt
Here’s yet another performance tip from a fellow subscriber and System i consultant. Thanks for the feedback on previous tips.
Today’s tip: “Use soft commit when committing transactions containing a small number of update, insert, and/or delete operations.”
According to the IBM V5R4 Information Center, “Soft commit is a form of commitment control that limits the number of times that the system writes journal entries associated with a transaction to disk.” In this regard, it is much like journal caching, but unlike journal caching, there is no additional fee for soft commit.
Be warned that soft commit does not protect against system failure as well as traditional commitment control does. I suspect it is for this reason that our friend recommends the use of soft commit only when the number of transactions is small.