473,385 Members | 1,506 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Difference between DB2 Client and DB2 Connect

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
6 15172
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
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

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
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Tig | last post by:
Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine....
3
by: Glen Scott | last post by:
Hi, I'm writing an ASP app that administers an ISA server remotely. The fact that it's an ISA server isn't my problem I believe. My question? What is the security difference between disabling...
8
by: Kim Bundgaard | last post by:
Hi Anyone know where I can look for problem with codepage conversion between DB2 UDB Connect EE V8.2 (fixpak 3) and DB2 UDB z/OS V7. With DB2 UDB Connect EE V7.2 (fixpak 7) i get Ebcdic X'5A'...
14
by: DaTurk | last post by:
I am makeing a Multicast server client setup and was wondering what the difference is between Socket.Connect, and Socket.Bind. It may be a stupid question, but I was just curious. Because I...
2
by: Burkhard Schultheis | last post by:
There are two packages for download (Linux): DB2 9 client (240 MB) DB2 runtime client (105 MB) What's the difference? Regards, Burkhard -- A: Weil es die Lesbarkeit des Textes...
1
by: bharathreddy | last post by:
This Article gives an introduction to VSTS Team Foundation & fundamental difference between Visual Source Safe (VSS) and VSTS Team Foundation. Team Foundation is a set of tools and technologies...
3
by: Joh | last post by:
I'd like to test a server application and a client application from the same computer. Currently if I let the client try to connect to my IPv4 adress provided by my router in this case 192.168.1.2...
0
by: 85ssp | last post by:
I am creating a small server client program that is meant for up to 70 connections from 70 different computers on a network. Everything in the program functions correctly except when testing...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.