Job DSNTEJ6P

Job DSNTEJ6P compiles, link-edits, binds, and runs a sample program, DSN8EP1, which calls the sample stored procedure that is created by job DSNTIJ6S.

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 DSNTEJ6P, ensure that DSNTEJ6S has been run on the server Db2 subsystem to create the sample stored procedure.

If DSNTEJ6P runs successfully, it produces the following return codes.

Table 1. DSNTEJ6P return codes
Step PROCSTEP Return code
PH06PS01
PPLI
PC
PLI
PLKED1
LKED
0000
0000
0004
0004
0000
PH06PS02   0004
PH06PS03   0000
Start of change
Note:
  1. The PLKED step does not exist in the job if the value of the PL/I LE PRELINKER PHASE field is set to NO.
End of change

Output from a successful execution of DSNTEJ6P 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 DSNTEJ6P, which is in member DSN8TJ6P of your prefix.SDSNIVPD data set.