Job DSNTEJ6

Job DSNTEJ6 consists of a single step that updates the location column in the sample DEPT table at the client and server Db2 subsystems.

The employees in department F22 are recorded as working at the server location that was entered in the REMOTE LOCATION field of panel DSNTIPY. All other employees are recorded as working at the client location.

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 REMOTE LOCATION field of panel DSNTIPY and it does not match the name specified in the DB2 LOCATION NAME field of panel DSNTIPR

Before you run DSNTEJ6, ensure that the server Db2 subsystem’s DSNTEJ1 job has been run on the server Db2 subsystem. Run the client Db2 subsystem’s DSNTEJ6 job only on the server Db2 subsystem.

If DSNTEJ6 runs successfully, it produces the return code that is shown in the table below.