Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2TEP2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
saikat

New User


Joined: 23 Jun 2008
Posts: 26
Location: pune

PostPosted: Fri Jun 21, 2013 10:29 am    Post subject: DB2TEP2
Reply with quote

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.
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri Jun 21, 2013 12:00 pm    Post subject:
Reply with quote

Quote:
I know if I run multiple sql insert queries using DB2TEP2 utility


Are you sure if you are reffering to correct program name??

Hope it was typo for DSNTEP2
Back to top
View user's profile Send private message
saikat

New User


Joined: 23 Jun 2008
Posts: 26
Location: pune

PostPosted: Fri Jun 21, 2013 12:16 pm    Post subject:
Reply with quote

Its DB2TEP2, IBM's utility
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri Jun 21, 2013 12:25 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Fri Jun 21, 2013 12:28 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
saikat

New User


Joined: 23 Jun 2008
Posts: 26
Location: pune

PostPosted: Fri Jun 21, 2013 3:04 pm    Post subject:
Reply with quote

Does DSNTEP2/DSNTEP4 issue rollback in case of sql failure?
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri Jun 21, 2013 3:39 pm    Post subject:
Reply with quote

What happen when you tried ?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Jun 21, 2013 5:14 pm    Post subject: Reply to: DB2TEP2
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 21, 2013 7:03 pm    Post subject:
Reply with quote

Hello,

Quote:
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.
No. Once committed, the data is committed and no longer a candidate for a ROLLBACK.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:



Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us