Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DSN RUN versus DB2 call attach

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 187
Location: Toronto, ON, Canada

PostPosted: Thu Oct 06, 2011 2:50 am    Post subject: DSN RUN versus DB2 call attach
Reply with quote

There are 2 ways I know of to execute a db2 program.
  • DSN RUN command. This will connect to the db2 environment and then execute the program
  • DB2 call attach. This will execute the program first and then a call is made to connect to the db2 environment.

They both achieve the same result but is one better then the other?

What I like about the call attach is that I can see the name of the program, db2 subsystem, and plan right in the JCL. There is also no need to use the IKJEFT01 to establish a tso environment first.

The DSN RUN usually has the program and plan name buried in a pds member which is then read in via SYSTSIN dd.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Oct 06, 2011 2:57 am    Post subject: Reply to: DSN RUN versus DB2 call attach
Reply with quote

You will have anyhow, even when using the CAF, to provide some additional parms to identify the DB2 subsystem You want to connect
unless You want to have as many <versions> each one with hardcoded the DB2 subsytem to be used

You might prefer it, but makes life more complicated from the programming side

it is Your responsibility to properly setup the environment, as per
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.apsg%2Fsrc%2Ftpc%2Fdb2z_programxmpcaf.htm

not to talk about a more complex error recovery

and all the programs have to do it icon_biggrin.gif
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts GETMAIN / FREEMAIN versus STORAGE OBT... steve-myers PL/I & Assembler 8 Wed Feb 01, 2017 1:45 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us