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

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

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

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

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

National Anthem

National Anthem Full

You do not believe that there are five stanza in our national anthem written by Tagore, only one stanza taken as anthem.

Stanza 1:

Jano Gano Mano Adhinaayako Jayo Hey,Bhaarato Bhaagyo Bidhaataa Panjaabo Sindhu Gujaraato Maraathaa,Draabiro Utkalo Bango Bindhyo Himaachalo Jamunaa Gangaa, Uchchhalo Jalodhi Tarango Tabo Shubho Naamey Jaagey, Tabo Shubho Aashisho Maagey Gaahey Tabo Jayogaathaa

Jano Gano Mangalo Daayako, Jayo Hey Bhaarato Bhaagyo Bidhaataa Jayo Hey, Jayo Hey, Jayo Hey,Jayo Jayo Jayo, Jayo Hey

O, the ruler of the minds of people, Victory be to You, dispenser of the destiny of India! Punjab, Sindhu, Gujarat, Maharashtra,Dravida(South India), Orissa, and Bengal, The Vindhya, the Himalayas, the Yamuna, the Ganges,and the oceans with foaming waves all around Wake up listening to Your auspicious name, Ask for Your auspicious blessings, And sing to Your glorious victory.

Oh! You who impart well being to the people! Victory be to you, dispenser of the destiny of India! Victory to you, victory to you, victory to you...

Stanza 2:

Ohoroho Tobo Aahbaano Prachaarito,Shuni Tabo Udaaro Baani Hindu Bauddho Shikho Jaino,Parashiko Musholmaano Christaani Purabo Pashchimo Aashey,Tabo Singhaasano Paashey Premohaaro Hawye Gaanthaa

Jano Gano Oikyo Bidhaayako Jayo Hey,Bhaarato Bhaagyo Bidhaataa Jayo Hey, Jayo Hey, Jayo Hey,Jayo Jayo Jayo, Jayo Hey

Your call is announced continuously, we heed your gracious call The Hindus, Buddhists, Sikhs, Jains, Parsis, Muslims and Christians, The east and the west come, to your throne And weave the garland of love...

Oh! You who bring in the unity of the people! Victory be to you, dispenser of the destiny of India!

Stanza 3:

Potono Abhbhudoy Bandhuro Ponthaa, Jugo Jugo Dhaabito Jaatri Hey Chiro Saarothi, Tabo Ratha Chakrey Mukhorito Potho Dino Raatri Daaruno Biplabo Maajhey,Tabo Shankhodhwoni Bajey Sankato Dukkho Traataa

Jano Gano Potho Parichaayako,Jayo Hey Bhaarato Bhaagyo Bidhaataa Jayo Hey, Jayo Hey, Jayo Hey,Jayo Jayo Jayo, Jayo Hey

The way of life is somber, as it moves through ups and downs. But we, the pilgrims, have followed it through the ages. Oh! Eternal charioteer, the wheels of your chariot echo day and night in the path In the midst of fierce revolution, your conch shell sounds. You save us from fear and misery

Oh! You who guide the people through tortuous path... Victory be to you, dispenser of the destiny of India! Victory to you, victory to you, victory to you...

Stanza 4:

Ghoro Timiro Ghono Nibiro,Nishithey Peerito Murchhito Deshey Jagrato Chhilo Tabo Abicholo Mangalo,Noto Nayoney Animeshey Duhswapney Aatankey,Rokkhaa Koriley Ankey Snehamoyi Tumi Maataaa

Jano Gano Duhkho Trayako,Jayo Hey Bhaarato Bhaagyo Bidhaataa Jayo Hey, Jayo Hey, Jayo Hey,Jayo Jayo Jayo, Jayo Hey

During the bleakest of nights, when the whole country was sick and in swoon Wakeful remained Your incessant blessings, through your lowered but winkless eyes Through nightmares and fears, you protected us on Your lap. Oh loving mother

Oh! You who have removed the misery of the people... Victory be to you, dispenser of the destiny of India! Victory to you, victory to you, victory to you...

Stanza 5:

Raatri Prabhatilo Udilo Rabichhabi, Purbo Udayo Giri Bhaaley Gaahey Bihangamo Punyo Samirano, Nabo Jibano Rasho Dhaley Tabo Karunaaruno Ragey,Nidrito Bhaarato JageyTabo Chorone Noto Maatha

Jayo Jayo Jayo Hey, Jayo Rajeshwaro, Bhaarato Bhaagyo Bidhaataa Jayo Hey, Jayo Hey, Jayo Hey,Jayo Jayo Jayo, Jayo Hey

The night is over, and the sun has risen over the hills of the eastern horizon. The birds are singing, and a gentle auspicious breeze is pouring the elixir of new life. By the halo of your compassion, India that was asleep is now waking. On your feet we lay our heads.

Victory, victory, victory be to you, the supreme king, the dispenser of the destiny of India! Victory to you, victory to you, victory to you...