Unit of work for Mainframe DB2
Posted: Thu Jul 10, 2008 8:21 am
Hi,
We are currently in the procees of upgrading from 7.5 to 8.0 and we have some consultants working on a project that requires an all or none commit on a few tables on Mainframe DB2. I am aware that we can control this in a given stage by setting the Rows Per Transaction to zero. But is it possible to have this all or none commit on a job level or a series of jobs. All teh tables involved get their changes and if any in the group fail all gets rolled back.
Thanks - - John
We are currently in the procees of upgrading from 7.5 to 8.0 and we have some consultants working on a project that requires an all or none commit on a few tables on Mainframe DB2. I am aware that we can control this in a given stage by setting the Rows Per Transaction to zero. But is it possible to have this all or none commit on a job level or a series of jobs. All teh tables involved get their changes and if any in the group fail all gets rolled back.
Thanks - - John