DB2 Connect Quick Beginnings for UNIX**

Preparing DB2 Universal Database for AS/400 for DB2 Connect

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

__  1.

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

__  2.

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

__  3.

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

__  4.

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

__  5.

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

__  6.

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. If there is no *LOCAL entry, you can add one, or use the system name obtained from the DSPNETA command on the server.

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                                          |
|    _     R7BDH3SNA           RCH2PDH3                                          |
|    _     RCHASDH3            RCHASDH3                                          |
|                                                                                |
+--------------------------------------------------------------------------------+

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

Table 12. Configuration Parameters from AS/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 Universal Database for AS/400 as an application server, refer to the online Connectivity Supplement provided with your DB2 Connect product.

For more information, refer to the DRDA Connectivity Guide and the World Wide Web at the V4R4 AS/400 Information Center. The Information Center can be found at the following URL: http://as400bks.rochester.ibm.com or http://www.as400.ibm.com/db2/db2main.htm.

[ Top of Page | Previous Page | Next Page ]