DB2 Client 8.2 on AIX

I have installed a DB2 Server on a remote machine and I want to connect to that database using a DB2 Client on AIX.  I have installed the DB2 run time client but I cannot find the db2ca command to configure the client.  Or let me re pharase    how do I configure the DB2 client on AIX?  Thanks
LVL 1
KhalidJAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

momi_sabagCommented:
hi
you can configure it using the command line center
in order to access the remote machine using tcpip you will need to perform 2 operations
1) catalog tcpip node
2) catalog a database
for example
catalog tcpip node MyNode remote ServerIpAddr server DB2TCPPort
catalog database myDB at node MyNode
0
KhalidJAuthor Commented:
Thanks.  Where can i run catalog from?  The DB2 Client?  
0
momi_sabagCommented:
the command line processor
in order to enter the command line processor you just enter the command "db2" from a console window
note that when you install the db2 client it creates a file called ". db2profile" under one of it's directories
you need to call that file in order to set some envrionment variables and then you can use the command line processor
if you don't wish to use the command line processor, you can just prefix each of the above commands with the word db2 and it will execute it
for example
db2 catalog tcpip node MyNode remote ServerIpAddr server DB2TCPPort
db2 catalog database myDB at node MyNode
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

KhalidJAuthor Commented:
Ok I can see the db2profile file.  What do I edit in order to enter the CLP mode?  thanks

DB2 command just gives me /usr/bin/ksh: db2 not found
0
KhalidJAuthor Commented:
Ok I am in
0
KhalidJAuthor Commented:
Thanks managed to get in but still trying to get this to work
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.