Job DSNTEJ6D

Job DSNTEJ6D compiles, link-edits, binds, and runs sample program DSN8ED1, which calls the sample stored procedure that is created by job DSNTEJ6T.

The sample caller first connects to the location that is specified in the REMOTE LOCATION field of panel DSNTIPY. If the remote location name is the same as the name that is specified in the DB2 LOCATION NAME field of panel DSNTIPR, the local Db2 subsystem is used as both the client and server.

The installation CLIST edits this job only if the following conditions are met:

  • You specified AUTO or COMMAND in the DDF STARTUP OPTION field of panel DSNTIPR.
  • You specified a name in the WLM ENVIRONMENT field of panel DSNTIPX.
  • You specified a name in the REMOTE LOCATION field of panel DSNTIPY. The name can match the name that is specified in the DB2 LOCATION NAME field of panel DSNTIPR.

Before you run DSNTEJ6D, ensure that DSNTEJ6T has been run on the server Db2 subsystem to create the sample stored procedure.

If DSNTEJ6D runs successfully, it produces the return codes that are shown in the table below.

Table 1. DSNTEJ6D return codes
Step PROCSTEP Return code
PH06DS01
PC
C
PLKED1
LKED
0000
0000 or 0004
0000 or 0004
0000
PH06DS02   0004
PH06DS03   0000
Start of change
Note:
  1. The PLKED step does not exist in the job if the value of the C LE PRELINKER PHASE field is set to NO.
End of change

Output from a successful execution of DSNTEJ6D lists each Db2 command that was executed, followed by the messages that were generated by the Db2 command processor.

You can compare the output from this job with the sample output for DSNTEJ6D, which is in member DSN8TJ6D of your prefix.SDSNIVPD data set.