Tuesday, April 15, 2025

 The english version of ultimate dua with the help of CHATGPT:

You are the One who honors whom You will,
And bring down those You choose to humble still.

Merciful Lord of all living beings,
You saved Prophet Yunus from the ocean's wings.

You gave the throne to Suleiman, the wise,
And summoned Musa to Mount Sinai’s rise.

You gifted Daud a voice so divine,
That iron softened at his song’s chime.

You filled Yaqub's heart with love so true,
And granted Ayyub patience to pull through.

You raised Isa to the skies above,
And pardoned Adam with endless love.

You gave Shaddad power and high decree,
To build a heaven from earth’s beauty—

But peace, he found not — not even briefly.

Monday, February 28, 2022

Killing process using command prompt in windows machine

Let say you are getting port 9061 already acquired and not able run your services, then kill the process which is using the port. 
Run the below command to get the process id,
 1. netstat -ano | findstr :9061 

Let say you get 8544 as PID then run the below command to kill it.
2. Replace the PID - taskkill /PID <<PID>> /F 

ex - taskkill /PID 8544 /F

Friday, December 24, 2021

[IBM][CLI Driver] SQL1109N The command was not processed because the database manager failed to load the following DLL: "GSKit Error: 408". SQLSTATE=42724

Able to configured the db2 catalog, that was working fine. However when using the DBI connection in perl script getting GSKit Error: 408. Though the environment variable is all set. Then I ran that script with Run as administrator and found working. So the issue is with access rights.

Thursday, November 18, 2021

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

Wednesday, November 10, 2021

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: _

Tuesday, October 5, 2021

To check the running process on AIX:
 ps -ef | grep mqm 
Here mqm is the process name. 

To kill the process using PID on AIX: 
kill -1287384 
Here 1287384 is the PID which I want to kill

Tuesday, August 31, 2021

The below line sung by legendary Dilip Kumar in an interview:

Ae .. sukun-e-dil k liye .. kuchh to ehtamaam karoon... Zara nazar jo mile ... phir unhein salaam karoon.... Mujhe to hosh nahin...aap mashwara dijiye... Ae ... kahan se chhedu fasana ... kahan tamam karoon...