Phase 6: Accessing data at a remote site
You can use phase 6 of the Db2 installation or migration verification process to verify that the features of DRDA access are working correctly, to prepare and call sample stored procedures, and to prepare and execute sample callers of certain Db2-supplied stored procedures.
During this optional phase, you test accessing data at a remote site by using the DRDA access application (job DSNTEJ6 in conjunction with job DSNTEJ3C).
You can use the following jobs to test creating and calling stored procedures at either the local site or a remote site.
- DSNTEJ6S and DSNTEJ6P
- Tests the stored procedure without result set sample
- DSNTEJ6T and DSNTEJ6D
- Tests the stored procedure with result set sample
- DSNTEJ61 and DSNTEJ62
- Tests the stored procedure for IMS Open Database Access
- DSNTEJ63 and DSNTEJ64
- Tests the external SQL procedure batch sample
- DSNTEJ65
- Tests the external SQL procedures processor invocation sample
- DSNTEJ66
- Tests the stored procedure that prepares a sample native SQL procedure and caller
You can use the following jobs to test calling Db2-supplied stored procedures at the local site:
DSNTEJ6U, DSNTEJ6R, DSNTEJ6V, and DSNTEJ6X
- Tests the stored procedure for invoking utilities
- DSNTEJ6W
- Tests the stored procedure for invoking WLM_REFRESH
- DSNTEJ6Z
- Tests the stored procedure for formatting the IFCID 106 trace record to obtain current Db2 configuration settings
ISPF panel requirements
The installation CLIST prepares samples DSNTEJ6, DSNTEJ6S, DSNTEJ6P, DSNTEJ6T, DSNTEJ6D, DSNTEJ6Z, DSNTEJ61, DSNTEJ62, DSNTEJ63, DSNTEJ64, DSNTEJ65 and DSNTEJ66 only if you specify COMMAND or AUTO in the DDF STARTUP OPTION field of panel DSNTIPR. If you specify NO, the installation CLIST does not prepare these samples. In this case, you should not try to run these samples.
The installation CLIST prepares the stored procedures samples only if you specify a sample WLM environment name in the WLM ENVIRONMENT field on panel DSNTIPX. If you replace the default value with blanks in the WLM ENVIRONMENT field, you cannot start the sample WLM-established stored procedures address space until you update the subsystem parameter.
The installation CLIST tailors the phase 6 sample jobs according to the information that you specify in the REMOTE LOCATION field of panel DSNTIPY. The guidelines for this field are:
- If the field is blank, the installation CLIST only customizes phase 6 sample jobs DSNTEJ63, DSNTEJ64, DSNTEJ65, DSNTEJ66, DSNTEJ6R, DSNTEJ6U, DSNTEJ6V, DSNTEJ6W, and DSNTEJ6Z. Jobs DSNTEJ63, DSNTEJ64, DSNTEJ65, and DSNTEJ66 use the local location name when the REMOTE LOCATION field is blank. Jobs DSNTEJ6R, DSNTEJ6U, DSNTEJ6V, DSNTEJ6W, and DSNTEJ6Z do not use a remote location name.
- If the value in the field is the same as the location name for the Db2 subsystem that you are installing (DB2 LOCATION NAME field of panel DSNTIPR), the stored procedures samples are prepared and customized for local use. However, the DRDA access sample is not prepared, including job DSNTEJ6 and the DRDA access component of job DSNTEJ3C.
- If the value in the field is different from the DB2 LOCATION NAME field, the installation CLIST prepares the phase 6 samples assuming that the remote location is the server and that the local system is the client.
The following table summarizes the ISPF panel values that are required for the installation CLIST to prepare the phase 6 sample jobs.
| Job name | Requires COMMAND or AUTO in the DDF STARTUP OPTION field of panel DSNTIPR? | Requires a name in the REMOTE LOCATION field of panel DSNTIPY? | Requires a name in the WLM ENVIRONMENT field of panel DSNTIPX? |
|---|---|---|---|
| DSNTEJ6 | Yes | Yes | No |
| DSNTEJ6S | Yes | Yes | Yes |
| DSNTEJ6P | Yes | Yes | Yes |
| DSNTEJ6T | Yes | Yes | Yes |
| DSNTEJ6D | Yes | Yes | Yes |
| DSNTEJ6R | No | No | Yes |
| DSNTEJ6U | No | No | No |
| DSNTEJ6V | No | No | No |
| DSNTEJ6W | No | No | Yes |
| DSNTEJ6Z | Yes | No | Yes |
| DSNTEJ61 | Yes | Yes | Yes |
| DSNTEJ62 | Yes | Yes | Yes |
| DSNTEJ63 | Yes | No | Yes |
| DSNTEJ64 | Yes | No | Yes |
| DSNTEJ65 | Yes | No | Yes |
| DSNTEJ66 | Yes | No | Yes |
Testing multiple subsystems
If you are installing and testing two Db2 subsystems concurrently, you must designate one as the server and the other as the client. If you change these designations during your testing, your results will be unpredictable. Verify that your VTAM® APPL statement has the parameter SYNCLVL=SYNCPT defined. This setting allows updates at several locations.