DB2 Connect gives applications on remote systems access to data in your DB2 Universal Database for AS/400 system. In order 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 OS/400, enter your values into
the worksheet that follows:
Table 8. 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 Universal Database for AS/400 as an application server, refer to the online Connectivity Supplement provided with your DB2 Connect product.
More detailed information can also be found in the DRDA Connectivity Guide, and on 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