Configuring your local environment to connect to your Db2 database

To connect local applications and tools to your Db2 database, you need to configure your environment.

1. Add entries to the driver configuration file, db2dsdriver.cfg, for your database.

   The configuration steps are different depending on whether or not you want to connect to your database using SSL:

   Without SSL

   To connect your applications and tools to your database without using SSL, enter the following commands in a command shell on Linux® operating systems, at the Windows command prompt, or in a DB2® command window:

   
   db2cli writecfg add -database BLUDB -host hostname -port 50000
   db2cli writecfg add -dsn alias -database BLUDB -host hostname -port 50000
   

   where:

   • hostname is the host name of your server.
   • alias is an alias you choose. The alias cannot be the same as the database name, "BLUDB". If you want to have spaces in the alias, surround the alias with double quotes.

   With SSL

   To connect your applications and tools to your database using SSL, enter the following commands in a command shell on Linux operating systems, at the Windows command prompt, or in a DB2 command window:

   
   db2cli writecfg add -database BLUDB -host hostname -port 50001
   db2cli writecfg add -dsn alias -database BLUDB -host hostname -port 50001
   db2cli writecfg add -database BLUDB -host hostname -port 50001 -parameter "SecurityTransportMode=SSL"
   

   where:

   • hostname is the host name of your server.
   • alias is an alias you choose. The alias cannot be the same as the database name, "BLUDB". If you want to have spaces in the alias, surround the alias with double quotes.

2. Test connecting by issuing the db2cli validate command from the command prompt:

   
   db2cli validate -dsn alias -connect -user userid -passwd password
   

   where:

   • alias is an alias you created with the db2cli writecfg command.
   • userid is your Db2 user ID.
   • password is your Db2 password.
3. [Optional] To be able to connect local ODBC applications and tools to your database, register the DSN with the ODBC driver manger:
   Run the following command from a command line:

   
   db2cli registerdsn -add -dsn  alias
   

   where:

   • alias is an alias you created with the db2cli writecfg command.

   By default, the DSN is created as a user DSN.