DirectConnect for DB2 UDB worksheet

Use the following worksheet to identify information that you should designate and record prior to installing DirectConnect for DB2 UDB. You are prompted for this information during installation.

Much of the DirectConnect for DB2 UDB installation process is accomplished when you configure the DRDA data sources using the Windows ODBC Administrator tool. You use this tool to set up connectivity, and create and bind packages to the DRDA system. As a result, terms on the installation worksheets are identified with one of the three windows:

The General window, where connectivity parameters are entered and tested
The Advanced window, where parameters can affect performance and resource use.
The Bind window, where packages are created and bound to the DRDA system

Be sure to have the IP address of the machine on which you are installing DirectConnect for DB2 UDB.

**Table A-1: DirectConnect for DB2 UDB worksheet**
Your installation information	Description
DIRECTORY NAME:	DirectConnect Directory Name: Home directory for DirectConnect for DB2 UDB.
SERVER NAME:	DirectConnect Server Name: Name of the DirectConnect Server you want to create or update.
DSN(s):	DSN: Define and record the Data Source Name (DSN) value, which is ConnectionSpec1.
LOCATION NAME:	Location Name: Specify the DB2 location name defined when your local DB2 subsystem was installed on Windows, Unix, AS/400, or z/OS.
COLLECTION:	Collection: Record the collection name, which identifies a group of packages. These packages include the DRDA driver packages. The database administrator for your site will provide this name for you.
PACKAGE:	Package: Record the name of the package that the driver uses to process static and dynamic SQL for applications that use this data source definition. The default name is DEFxx, where xx is the version number. The database administrator for your site will provide this name for you.Name that the driver uses to process static and dynamic SQL for applications that use this DSN.
IP ADDRESS: TCP PORT:	TCP/IP Connectivity: Record the following: IP Address: address of the mainframe. Record the address using the machine’s numeric address (for example, 123.456.78.90) or type its address name. If you enter an address name, the driver must find this name (with the correct address assignment) in the HOSTS file on the workstation or in a DNS server. TCP Port: port number assigned to the DRDA server on the machine where catalog tables reside. Record this port’s numeric address or its name (8898 is the default). If you enter a port name, the driver must find this name (with the correct port assignment) in the SERVICES file on the workstation.
MAX. NUMBER OF CLIENTS:	Maximum Number of Clients: Maximum number of clients that the service will support.
DYNAMIC SECTIONS:	Dynamic Sections: Maximum concurrent cursors that can be opened.
PACKAGE OWNER:	Package Owner: AuthID of person who will execute all SQL in the package.