DB2 Server for VM: System Administration

Preparing to Implement DRDA

You can use the application requester, the application server, or both in a distributed environment. This section provides a checklist of the required tasks for implementing DRDA over SNA. For information on implementing DRDA over TCP/IP, refer to Chapter 16, Using TCP/IP with DB2 Server for VM. For detailed information on DRDA, see the Distributed Relational Database Connectivity Guide.

On the Application Requester

• Increase the virtual storage (see Table 37)
• Provide the following network information:
  • Define the local system
  • Define the remote systems
  • Supply information to the VTAM product and to AVS
  • Select RU sizes and pacing
  • Review the existing network definitions to ensure that the distributed database system does not adversely affect the existing network
  • Update the CMS communications directory
• Provide the following security controls:
  • Supply information to the VTAM product for the level of security required
• Specify the PROTOCOL parameter of the SQLINIT EXEC
• Preprocess the applications to be used
• Compile the applications.

On the Application Server

• Increase the virtual storage (see Table 37)
• If you use saved segments, redefine the saved segments for the DB2 Server for VM components, since the size of the Resource Adapter and RDS components will increase
• If the application server is to be used for distributed unit of work activity, install a CRR recover server. For more information, see the VM/ESA: Installation Guide and the VM/ESA: CMS File Pool Planning, Administration, and Operation manuals.
• Provide the following network information:
  • Define the application server to the VTAM product and to AVS
  • Review the existing network definitions to ensure that the distributed database system will not adversely affect the existing network
• Provide the following security controls:
  • Either use come-from checking so that the application server accepts user IDs from specific locations only (and translates a user ID to a different user ID when necessary), or ensure that all user IDs are unique within the SNA network
  • Ensure that the application server provides a security manager product to support the required security features
• Specify the PROTOCOL parameter of the SQLSTART EXEC.