How to see the client type?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen_db2 - 16 Feb 2006 11:40 GMT

Hi All
I have db2 client installed in my machine.I wanted to see which client it
is-Runtime or administration or application development client.
Please tell me how to ensure this. I tried using db2level but it showed me
this information.
C:\>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
FixPak
"2".
Product is installed at "D:\PROGRA~1\IBM\SQLLIB".

Praveen

Reply to this Message

Shyam Peri - 16 Feb 2006 13:52 GMT

Praveen,
The variations among the db2 client level installable is totally
pertinent to its feature set.

Runtime client: Provides the basic non-gui access to the database
Administration client:Provides necessary tools to administer remote
database, along with the run-time client capabilities
Application development client:Provides necessary tools to develop
application which includes development center, along with the run-time
client capabilities.

More detailed information can be found at
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/start/c0007217.htm

Reply to this Message

pshindle@comcast.net - 16 Feb 2006 16:08 GMT

In order to definitively know what "flavor" of the DB2 Client is
installed on a machine you can do one of the following:

1. For DB2 V8 only, open up the Add/Remove Programs applet in the
Control Panel. It will show the actual product installed.

2. You can look at the Windows Registry. I believe the hierarchy is
HKEY_LOCAL_MACHINE--> SOFTWARE->IBM->DB2. There should be complete
info as to the product/component and actual version.

Hope this helps.

Perry Shindle
BearingPoint

Reply to this Message

Praveen_db2 - 20 Feb 2006 08:00 GMT

Thanks Perry
This is what I needed.I found out one more method for it. You can check at
D:\Program Files\IBM\SQLLIB\cfg\DB2<PRODUCT_TYPE>.LVL.Here product_type
will give an idea about the client type.
Thanks again
Praveen

Reply to this Message

Darin McBride - 18 Feb 2006 00:29 GMT

> Hi All
> I have db2 client installed in my machine.I wanted to see which client it
[quoted text clipped - 11 lines]
>
> Praveen

I have to wonder ... why? As long as it does what you want it to do, isn't
that sufficient?

The reason I ask is that we do as much as possible to ensure that which
client you have installed is irrelevant to your day-to-day job as long as
it has the features you need, and they are installed.

So, in other words, if what you want to know is whether ODBC is available
and configured, your best bet is just to look at the ODBC settings. Or, if
you want to compile stuff, check for the headers and .lib files. Or, if
you want to launch the Control Center, look for db2cc.bat.

The reason we do this is that you can get all of these things in many ways.
Including, for example, via DB2 Personal Developer's Edition. Which is not
any of those three clients, but can be used as a client. Although, with
DB2 Personal Edition, you may have to perform a custom installation to get
the headers and libraries, whereas that is a core part of the application
development client.

Reply to this Message

Gert van der Kooij - 18 Feb 2006 00:41 GMT

> > Hi All
> > I have db2 client installed in my machine.I wanted to see which client it
[quoted text clipped - 14 lines]
> I have to wonder ... why? As long as it does what you want it to do, isn't
> that sufficient?

My major reason is to be sure all required fixpacks are downloaded. I
can download using a fast internet connection at home and when I'm at
a customers location they aren't very pleased when I have to download
another fixpack, they don't pay me for waiting at a download.
The installer can check what is installed so I guess it shouldn't be
a big problem to put these checks in a stand-alone utility and
display the installed software.

Reply to this Message

Praveen_db2 - 20 Feb 2006 07:56 GMT

Hi Darin
Thanks for the repply.
The need to know about the type of client arises when a guy(newbie in db2)
from some other project approaches you and asks you which is the db2
client version installed in your machine as he also neeeds to install db2
client on his machine for projet requirements and he needs the same
functionalities as in my db2 client.I faced such a situation and I was not
able to give a prompt answer as I joined this project mid way with all the
setup done and like you rightly said I also never bothered to look at the
client type as it was doing the things I wanted it to do.

Praveen

Reply to this Message

mike_li - 20 Feb 2006 15:26 GMT

try command db2lic -l to list your product license, it might give
you the product type.

mike

> Hi Darin
> Thanks for the repply.
[quoted text clipped - 8 lines]
>
> Praveen

Reply to this Message