Quick Beginnings for DB2 Connect
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 4. 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
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]