Job DSNTEJ6T

Job DSNTEJ6T registers, prepares, and binds the sample stored procedure DSN8ED2 on the server. DSNTEJ6T also defines a created temporary table to receive the IFI output that is returned as a result set.

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.

You must run job DSNTEJ6T on the server Db2 subsystem.

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

Table 1. DSNTEJ6T return codes
Step PROCSTEP Return code
PH06TS01   0000
PH06TS02   0000
PH06TS03
PC
C
PLKED1
LKED
0004
0000
0004
0000
PH06TS04   0000 or 0004
  1. The PLKED step does not exist in the job if the value of the C LE PRELINKER PHASE field is set to NO.

If SQLCODE -592 is received during the execution of DSNTEJ6T, ensure that SPA is active.