By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Difference between DB2 Client and DB2 Connect

P: n/a
What is the difference between DB2 Client and DB2 Connect?

Our databases are DB2 8 on AIX and z/OS. Can we use DB2 Connect to
connect to DB2 server on AIX and DB2 on z/OS?

Thanks!
-Jane

May 8 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Jane,
What is the difference between DB2 Client and DB2 Connect?
DB2 Client is free client for DB2 Linux, Unix, Windows (LUV).

DB2 Connect is chargeable client (can be also server), and (in addition
to LUV connectivity) includes OS/400 and/or z/OS connectivity/license.
So, you pay for only OS/400 or z/OS connectivity.
Our databases are DB2 8 on AIX and z/OS. Can we use DB2 Connect to

connect to DB2 server on AIX and DB2 on z/OS?

Yes, you can use DB2 Connect to access DB2 on AIX and z/OS. Next
question is: how would you like to connect the servers? Federation? Or,
just catalog z/OS database on AIX. Both are possible. Remember that
there are different connect editions (different pricing models).

-- Artur Wronski

May 8 '06 #2

P: n/a
Artur:

Thank you for answering. We are going to catalog the z/OS database on
AIX.

db2level doesn't tell me if I have db2connect or db2 client. How do I
find out what's installed? It's hard to tell the difference between
DB2 Client and DB2 Connect.

-Jane

May 10 '06 #3

P: n/a

jane wrote:
Artur:

Thank you for answering. We are going to catalog the z/OS database on
AIX.

db2level doesn't tell me if I have db2connect or db2 client. How do I
find out what's installed? It's hard to tell the difference between
DB2 Client and DB2 Connect.

-Jane


db2 get dbm cfg would give you whether its Client/Connect I guess. ( I
dont have a db3 connect to test the same but its shows for db2 server &
runtime client clearly)

May 10 '06 #4

P: n/a
jane wrote:
Thank you for answering. We are going to catalog the z/OS database on
AIX.

db2level doesn't tell me if I have db2connect or db2 client. How do I
find out what's installed? It's hard to tell the difference between
DB2 Client and DB2 Connect.


"db2licm -l" should tell you. If you get "command not found" (but db2level
works), you have an unlicensed (and unlicensable) client. If you get
anything else, the output should tell you what it is.
May 10 '06 #5

P: n/a
When I type "db2licm -l" I get is message 'db2licm' is not recognized
as an internal or external command, operable program or batch file.

I have DB2 Administration Client and I am able to catalog the DB2 z/os
database. Looks like you can use DB2 Connect or DB2 Adminstration
Client to connect to z/os database.

Thanks for all the replies.
-Jane

May 12 '06 #6

P: n/a
"jane" <ja**********@sympatico.ca> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
When I type "db2licm -l" I get is message 'db2licm' is not recognized
as an internal or external command, operable program or batch file.

I have DB2 Administration Client and I am able to catalog the DB2 z/os
database. Looks like you can use DB2 Connect or DB2 Adminstration
Client to connect to z/os database.

Thanks for all the replies.
-Jane


You can connect to z/OS from a DB2 V8 Administration Client without DB2
Connect, but supposedly you need a DB2 Connect License installed.
May 12 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.