|
Step 2: DB2 on AIX Database Connection Instructions
Substep 1: AIX Server Setup Instructions
Setup the server machine to use TCP/IP to connect to the DB2 database.
- On the server, use the operating system command line to login as DB2 administrator and type:
- db2set DB2COMM=tcpip
- Setup the server port number on which DB2 will listen for incoming requests.
- As root user on the server, add the following line to the "/etc/services" file:
db2srvc <port_number>/tcp #DB2 connection service port
where
- <port_number> refers to an unused port number (one which is not listed in the "/etc/services" file).
- Next, you must configure the database to use the new service.
On the Server, use the DB2 command line and type:
- UPDATE DBM CFG USING SVCENAME db2srvc
- Restart DB2
- Go to AIX Substep 2
 
- Be sure to enter db2srvc in all lowercase letters.
- The "server" refers to the machine on which the actual DB2 database resides. The "client" refers to the machine that uses the DB2 database which resides on the "server". The "server" and "client" can be the same machine.
|