Need to connect DB2 database using unix shell script

Question

Need to connect to DB2 database by using unix shell script I am using QMF tool to run DB2 queries everytime. Now i need to connect this through shell script. DSN name --GM2P DB name-- DPPRICMG table name--item Any help and suggestions would be appreciated. can anyone please answer this ASAP. Thanks

is db2 running on the unix box?

MrG
– MrG

2012-07-12 19:44:36 +00:00
Commented Jul 12, 2012 at 19:44 — MrG
– MrG, Commented Jul 12, 2012 at 19:44

ramazan polat · Accepted Answer · 2012-10-19 10:54:33Z

1

In order to run the script properly you must be cataloged the remote database as this:

db2 catalog tcpip node NODE1 remote ip.ip.ip.ip server 50000
db2 catalog database mydb1 at node NODE1 authentication server

Then you can use this script to issue any sql you want:

db2 connect to mydb2 user username using password
db2 "update bla bla bla "
db2 connect reset

Note that if you are using DB2 for z/OS, then cataloging will be a bit different.

answered Oct 19, 2012 at 10:54

ramazan polat

8,0484 gold badges57 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to connect DB2 database using unix shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related