Job DSNTEJ7
Job DSNTEJ7 demonstrates how to create a LOB table with all the accompanying LOB table spaces, auxiliary tables, and indexes. DSNTEJ7 also demonstrates how to use the Db2 LOAD utility to load a LOB table.
Job DSNTEJ7 consists of the following steps:
| Step | Function |
|---|---|
| 1 | Drops sample LOB objects |
| 2 | Creates sample Employee Resume and Photo LOB table |
| 3 | Creates aliases for the table, then grants access to it |
| 4 | Uses the Db2 LOAD utility to populate the table |
| 5 | Generates run time statistics on the table |
If DSNTEJ7 runs successfully, it produces the return codes that are shown in the table below.
| JOBSTEP | PROCSTEP | Return Code |
|---|---|---|
| PH07S01 | 0000 | |
| PH07S02 | 0000 | |
| PH07S03 | 0000 or 0004 | |
| PH07S04 | DSNUPROC | 0000 |
| PH07S05 | DSNUPROC | 0000 |
| PH07S06 | 0000 | |
| PH07S07 | 0000 |