Adding an entry for SNA usage

 

The Add RDB Directory Entry (ADDRDBDIRE) display is shown here. You can use the Add Relational Database Directory Entry (ADDRDBDIRE) command to add an entry to the relational database directory. 

Add RDB Directory Entry (ADDRDBDIRE)
 
Type choices, press Enter.
 
Relational database  . . . . . .  MP311         Name Relational database alias . . .   *NONE Remote location:   Name or address  . . . . . . .  MP311         Name, *LOCAL, *ARDPGM   Type . . . . . . . . . . . . .  *SNA          *SNA, *IP Text . . . . . . . . . . . . . .  'Oak Street Dealership'

In this example, an entry is made to add a relational database named MP311 for a system with a remote location name of MP311 to the relational database directory on the local system. For SNA connections, the Relational database alias field must remain *NONE, the default value. The remote location name does not have to be defined before a relational database directory entry using it is created. However, the remote location name must be defined before the relational database directory entry is used in an application. The relational database name (RDB) parameter and the remote location name (RMTLOCNAME) parameter are required for the Add Relational Database Directory Entry (ADDRDBDIRE) command. By default, the second element of the RMTLOCNAME parameter is *SNA. The descriptive text (TEXT) parameter is optional. As shown in this example, it is a good idea to make the relational database name the same as the system name or location name specified for this system in your network configuration. This can help you identify a database name and correlate it to a particular system in your distributed relational database network, especially if your network is complex. To see the other optional parameters on this command, press F10 on the Add RDB Directory Entry (ADDRDBDIRE) display. These optional parameters are shown here. 

Add RDB Directory Entry (ADDRDBDIRE)
 
Type choices, press Enter.
 
Relational database  . . . . . .  MP311
Relational database alias . . .   *NONE Remote location   Name or address  . . . . . . .  MP311
  Type . . . . . . . . . . . . .  *SNA         *SNA, *IP Text . . . . . . . . . . . . . .  'Oak Street Dealership'
 
Device:   APPC device description  . . .  *LOC          Name, *LOC Local location . . . . . . . . .  *LOC          Name, *LOC, *NETATR Remote network identifier  . . .  *LOC          Name, *LOC, *NETATR, *NONE Mode . . . . . . . . . . . . . .  *NETATR       Name, *NETATR Transaction program  . . . . . .  *DRDA         Character value, *DRDA

The system provides *SNA as the default value for the following additional Add Relational Database Directory Entry (ADDRDBDIRE) command parameters:

Notes:

  1. For SNA connections, the relational database alias field must be left with its *NONE default value.

  2. The transaction program name parameter in the i5/OS® operating system is TNSPGM. In SNA, it is TPN.

  3. If you use the defaults with Advanced Program-to-Program Communication (APPC), the system determines the device, the local location, and the remote network identifier that will be used. The mode name defined in the network attributes is used and the transaction program name for Distributed Relational Database Architecture™ (DRDA®) support is used. If you use the defaults with Advanced Peer-to-Peer Networking® (APPN), the system ignores the device (DEV) parameter, and uses the local location name, remote network identifier, and mode name defined in the network attributes.

You can change any of these default values on the ADDRDBDIRE command. For example, you might have to change the TNSPGM parameter to communicate with a DB2 Universal Database™ for VM server. By default for DB2 Universal Database for VM support, the transaction program name is the name of the DB2 Universal Database for VM database to which you want to connect. The default TNSPGM parameter value for DRDA (*DRDA) is X'07F6C4C2'. QCNTEDDM and DB2DRDA also map to X'07F6C4C2'.

 

Parent topic:

Working with the relational database directory

 

Related tasks


Setting QCNTSRVC as a transaction program name on a DB2 UDB for VM application requester

 

Related reference


Add Relational Database Directory Entry (ADDRDBDIRE) command
Setting QCNTSRVC as a transaction program name on a DB2 UDB for iSeries application requester
Setting QCNTSRVC as a transaction program name on a DB2 UDB for z/OS application requester
Setting QCNTSRVC as a transaction program name on a DB2 for Linux, UNIX, and Windows application requester