I know if I run multiple sql insert queries using DB2TEP2 utility and in case any query fails in between all records upto that point get committed and rest all get failed.
I would like to know if there is similar utility which issues auto roll back in above case so that in case of failure no records get committed.
Well, looking at the DB2 Utility manual's index there is no DB2TEP2 but there is DSNTEP2. Also, there is no reference to IBM manuals in the Google search. There appears to be a DB2TEP2 on the CBTTape but then it would not be IBM.
Joined: 03 Oct 2009 Posts: 1786 Location: Bloomington, IL
DSNTEP2 and DSNTEP4 are written in PL/I, so if someone in your shop has the necessary skills, heesh could easily add a control parameter specifying commit frequency.