DB2TEP2

saikat · New User Joined: 23 Jun 2008 Posts: 26 Location: pune

Hi,

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.

Pandora-Box · Posted: Fri Jun 21, 2013 12:00 pm Post subject:

saikat · New User Joined: 23 Jun 2008 Posts: 26 Location: pune

Its DB2TEP2, IBM's utility

Pandora-Box · Posted: Fri Jun 21, 2013 12:25 pm Post subject:

Could you please share the code which you have tried keen to know about DB2TEP2 ( Not sure if thats an alias) or may be link to the DB2TEP2?

Nic Clouston · Posted: Fri Jun 21, 2013 12:28 pm Post subject:

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.

saikat · New User Joined: 23 Jun 2008 Posts: 26 Location: pune

Does DSNTEP2/DSNTEP4 issue rollback in case of sql failure?

Pandora-Box · Posted: Fri Jun 21, 2013 3:39 pm Post subject:

What happen when you tried ?

Akatsukami · Posted: Fri Jun 21, 2013 5:14 pm Post subject: Reply to: DB2TEP2

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.

dick scherrer · Posted: Fri Jun 21, 2013 7:03 pm Post subject:

Hello,