%META:TOPICPARENT{name="PreinstallDB2LiteUnix"}%

==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.