Job DSNTEJ71 (optional)

Job DSNTEJ71 compiles, link-edits, and binds two sample applications that manipulate LOB data.

The DSN8DLPL sample application demonstrates how to use LOB locators to populate a LOB column. The DSN8DLTC sample application validates the contents of the LOB table, verifying that it was populated correctly.

In previous releases, you had to run job DSNTEJ71 to populate LOB columns that were greater than 32 KB. In Db2 12, the LOAD utility populates all columns of the sample LOB table, so job DSNTEJ71 is optional.

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

Table 1. DSNTEJ71 return codes
JOBSTEP PROCSTEP Return Code
PH071S01
PC
C
PLKED1
LKED
0000
0000
0004
0000
PH071S02
PC
C
PLKED1
LKED
0000
0000
0004
0000
PH071S03   0000
PH071S04   0000
PH071S05   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

You can compare the output from this job with the sample output for DSNTEJ71 found in member DSN8TJ71 in your prefix.SDSNIVPD data set.