Quick Beginnings

Preparing DB2 for AS/400 for DB2 Connect

DB2 Connect gives applications on remote systems access to data in your DB2 for AS/400 system. In order to set up the connection, the person installing DB2 Connect needs the following information:

• The local network name. You can get this information by entering DSPNETA.

• The local adapter address. You can get this information by entering WRKLIND (*trlan).

• The mode name. You can get a list of mode names by entering WRKMODD. If the mode IBMRDB has been defined on your OS/400 system, you should use it.

• The local control point name. You can get this information by entering DSPNETA.

• The remote transaction program name. The default (defined by DRDA) is X'07'6DB (X'07F6C4C2'). The default is always used by DB2 for AS/400. If entering a hexadecimal number is not convenient, an alias is QCNTEDDM.

• The relational database name. You can get this information by entering DSPRDBDIRE. This will display a list. The line containing *LOCAL in the Remote Location column identifies the RDBNAME which must be defined to the client.

  Here is an example screen:

  +--------------------------------------------------------------------------------+
  |                  Display Relational Database Directory Entries                 |
  |                                                                                |
  |  Position to  . . . . . .                                                      |
  |                                                                                |
  |  Type options, press Enter.                                                    |
  |    5=Display details   6=Print details                                         |
  |                                                                                |
  |          Relational          Remote                                            |
  |  Option  Database            Location  Text                                    |
  |    _     __________________                                                    |
  |    _     DLHX                RCHAS2FA                                          |
  |    _     JORMT2FA            JORMT2FA                                          |
  |    _     JORMT4FD            JORMT4FD                                          |
  |    _     JOSNAR7B            RCHASR7B                                          |
  |    _     RCHASR7B            *LOCAL                                            |
  |    _     RCHASR7C            RCHASR7C                                          |
  |    _     RCH2PDH3            RCHASDH3                                          |
  |    _     R7BDH3SNA           RCH2PDH3                                          |
  |    _     RCHASDH3            RCHASDH3                                          |
  +--------------------------------------------------------------------------------+

  
  

When you have obtained these parameters from OS/400, enter your values into the worksheet that follows:

Table 46. Configuration Parameters from OS/400

Item	Parameter	Example	Your value
A-1	Local network name	SPIFNET
A-2	Local adapter address	400009451902
A-3	Mode name	IBMRDB
A-4	Local control point name	SYD2101A
A-5	Remote transaction program	X'07F6C4C2'(default)
A-6	Relational database name	NEW_YORK3

For further information about how to set up DB2 for AS/400 as an application server, refer to the online DB2 Connectivity Supplement provided with your DB2 Connect product.

More detailed information can also be found in the DRDA Connectivity Guide.

[ DB2 List of Books | Search the DB2 Books ]