Job DSNTEJ3M

Job DSNTEJ3M creates, populates, and processes a database that demonstrates the use of Db2 materialized query tables (MQTs).

Before you run job DSNTEJ3M, you must create a PLAN_TABLE. To create this table, specify the member DSNTESC as an input data set name to SPUFI.

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

Table 1. DSNTEJ3M return codes
Step PROCSTEP Return code
PH03MS00   0000
PH03MS01   0000
PH03MS02   0000
PH03MS03   0000 or 0004
PH03MS04   0000
PH03MS05   0000
PH03MS06   0000
PH03MS07   0000