DSN RUN versus DB2 call attach

jerryte · Posted: Thu Oct 06, 2011 2:50 am

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.

enrico-sorichetti · Posted: Thu Oct 06, 2011 2:57 am

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
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