I am little confused about original environment since MySQL does not support native commit and rollback. So has the original pre-port code got a lot of 'simulated' commit and rollback code ??

That being said here are a couple things to ponder that may help.

It is common in DBI to wrap transactions in eval. You may already know this but I state the obvious just in case :) 

eval {
   do some transcations
   $dbh->commit()
};
$dbh->rollback() if $@;

[download]
Also DB2 supports 4 transaction isolation levels: Repeatable Read, Cursor Stability(default), Read Stabilty, Uncommited Read. The good news is these may help to simplify transcations. Bad news DBD::DB2 supports this through an external variable TXNISOLATION found in db2cli.ini. It cannot be changed in SQL so you only get one choice and it is globally applied across your entire database.

Hope this may give you some ideas. Good Luck.

mitd-Made in the Dark
'My favourite colour appears to be grey.'

In reply to Re: commtting db transactions by mitd
in thread commtting db transactions by d_i_r_t_y

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.