Monday, May 23, 2011

ITIM DB2

Connecting to itim db2 is easy , but most of us forget to profile db.

Login to itim db2 server as root

Then profile the db :

# . /home/db2admin/sqllib/db2profile
db2 connect to user itimuser using

Easy as it gets :)

if u want to run select commands, put db2 "Select * from abc where d = 'gupta'"

No comments:

Post a Comment