Configure a DB2 Database Alias (Unix)
Use the following instructions to configure DB2 database aliases on Unix and Linux operating systems:
1. Login to the machine that contains your DB2 native client software.
2. su to your DB2 instance owner. For example:
su - db2inst1
3.
Execute the .profile associated with the db2instance owner.
For example:
. ./.profile
4. Use the echo command to ensure DB2DIR is set.
echo $DB2DIR
5.
Use the echo command to ensure DB2INSTANCE is set.
echo $DB2INSTANCE
6.
cd into the $DB2INSTANCE/sqllib/bin directory.
cd $DB2INSTANCE/sqllib/bin
7.
Execute the db2 command.
./db2
8.
Execute the catalog node command using the following syntax.
catalog tcpip node arbitrary_node_name remote database_server_name server db2_listening_port
Here is an example:
catalog tcpip node WIN64IA remote openwin64 server 50000
9. Execute the terminate command.
terminate
10.
Execute the catalog database command using the following syntax:
catalog database database_name as remotedb at node arbitrary_node_name_from_above
Here is an example:
catalog database sample as remotedb at node WIN64IA
11.
Execute the terminate command.
terminate
11.
Execute the connect to database command where database is the remotedb alias from step #10.
For example:
connect to remotedb
12.
Wait for a successful connection.
Use the remotedb alias in the database alias field of your DB2 Lite Data Source Names.