Difference between DB2 Client and DB2 Connect

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jane - 08 May 2006 15:34 GMT

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

Reply to this Message

Artur - 08 May 2006 21:18 GMT

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

Reply to this Message

jane - 10 May 2006 17:13 GMT

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

Reply to this Message

reachsamdurai@gmail.com - 10 May 2006 18:28 GMT

> Artur:
>
[quoted text clipped - 6 lines]
>
> -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)

Reply to this Message

Darin McBride - 11 May 2006 00:41 GMT

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

Reply to this Message

jane - 12 May 2006 18:29 GMT

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

Reply to this Message

Mark A - 13 May 2006 00:39 GMT

> When I type "db2licm -l" I get is message 'db2licm' is not recognized
> as an internal or external command, operable program or batch file.
[quoted text clipped - 5 lines]
> 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.

Reply to this Message