DRDA access sample

The distributed sample application that uses DRDA access is executed as part of Phase 6 of the installation or migration verification process.

The application is prepared in Phase 3 as part of DSNTEJ3C. Before this application can be run correctly as a DRDA access sample, you must run job DSNTEJ6 at both the local and remote sites to tailor the DEPT sample table for use in a distributed environment.

To set up your samples testing for concurrent installations at two Db2 locations, follow these guidelines:

• Designate one location as the requester (the client) and the other location as the server.
• Run the client version of DSNTEJ6 at the client site only; do not run the client version of DSNTEJ6 at the server.
• Edit the server version of DSNTEJ6 at the remote server site; do not run the server version of DSNTEJ6 at the client.
• Locate the following text in the server version of DSNTEJ6 within step PH06S01:

  UPDATE DEPT SET LOCATION = (your remote location name) WHERE DEPTNO = 'F22';
  UPDATE DEPT SET LOCATION = (your location name) WHERE LOCATION = '  ';

  This text should be replaced with:

  UPDATE DEPT SET LOCATION = (your location name) WHERE DEPTNO = 'F22';
  UPDATE DEPT SET LOCATION = (your remote location name) WHERE LOCATION = '  ';