On Delhi Pollution: 

kisne ghole hain hawaon mein zaher,

zimmedari se rahna chahte hain baher,

sabkuch band kar dena munasib nahin,

kuch khud bhi karein, sarkar iske liye kafi nahin...

Step to configure DB2 database ODBC catalog with SSL

Step to configure DB2 database ODBC catalog with SSL:

1. Install gsk8 outside of program files like (C:\dbcert\)

2. Set environment variables like (C:\dbcert\gsk8\lib_64; C:\dbcert\gsk8\bin; C:\dbcert\gsk8\catalogs;)

3. Now you can create the certificate key store with below commands:

gsk8capicmd_64 -keydb -create -db "C:\dbcert\dbkeystore.kdb" -pw "passw0rd" -stash

gsk8capicmd_64 -cert -add -db "C:\dbcert\dbkeystore.kdb" -pw "passw0rd" -label EXPDBSSL -file "C:\dbcert\DigiCertGlobalRootCA.arm"

Here DigiCertGlobalRootCA.arm is the certificate downloaded from db2 server.

4. Go to C:\program files\IBM\SQLLIB\BIN in command prompt with admin rights (where your db2 client is installed) and run the below command:

db2cmd -i -w db2clpsetcp (This command help you to recognize db2 command)

db2 list dcs directory (Check dcs directory if present then uncatalog it with below command)

db2 uncatalog dcs db EXPDB

5. Check if EXPPRDP catalog present then uncatalog those with below command:

db2 list db directory

db2 uncatalog node EXPPRDP

db2 uncatalog database EXPPRDP

6. Configure the ssl with below command:

db2 update dbm cfg using SSL_CLNT_KEYDB "C:\dbcert\dbkeystore.kdb"

db2 update dbm cfg using SSL_CLNT_STASH "C:\dbcert\dbkeystore.sth"

7. Create catalog and connect with userid and password like below:

db2 catalog tcpip node EXPPRDP remote ld9o37j-67639-klkadur93-riwwoas98.bu6tc4nd0urletsa6ufg.databases.appdomain.cloud server 30130 security ssl

db2 catalog db EXPDB as EXPPRDP at node EXPPRDP authentication SERVER_ENCRYPT

db2 connect to EXPPRDP user example

please enter example password: _