Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2007

Tip: Looking for answers? Try searching our database.

list of db2 installed products

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Asuwish - 23 Sep 2007 13:34 GMT
Hi To all.
I would like to know please if there is a command that shows which DB2
products were installed on my machine.
Thanks for the help
Mark A - 23 Sep 2007 22:17 GMT
> Hi To all.
> I would like to know please if there is a command that shows which DB2
> products were installed on my machine.
> Thanks for the help

Open the DB2 Command Line Processor and type: db2level
Asuwish - 24 Sep 2007 06:47 GMT
> > Hi To all.
> > I would like to know please if there is a command that shows which DB2
> > products were installed on my machine.
> > Thanks for the help
>
> Open the DB2 Command Line Processor and type: db2level
Hi.
I'm familiar with this command but it shows me the following :

DB21085I  Instance "DB2" uses "32" bits and DB2 code release
"SQL09013" with
level identifier "01040107".
Informational tokens are "DB2 v9.1.300.257", "s070719", "WR21392", and
Fix Pack

"3".
Product is installed at "C:\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".

In my case I have more db2 products like db2 client, how can I know
that according to the output.

Thanks again.
Amir T.
Mark A - 24 Sep 2007 07:36 GMT
"Asuwish" <amirt@oft.co.il> wrote in message > Hi.
> I'm familiar with this command but it shows me the following :
>
[quoted text clipped - 12 lines]
> Thanks again.
> Amir T.

DB2 Client is always installed with the server. If you want to know which
client you have, open the client and look at Help.
Asuwish - 24 Sep 2007 07:50 GMT
> "Asuwish" <am...@oft.co.il> wrote in message > Hi.
> > I'm familiar with this command but it shows me the following :
[quoted text clipped - 18 lines]
>
> -               -

Hi Mark.
Thanks for your help , Have a nice day :)
The Boss - 24 Sep 2007 20:16 GMT
>>> Hi To all.
>>> I would like to know please if there is a command that shows which
[quoted text clipped - 19 lines]
> Thanks again.
> Amir T.

Aha, it seems you are on DB2 9.
In that case you would have the option of using the command db2ls as
described here:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/r0023668.htm

but unfortunately for you it isn't available for Windows.

However, you could try DB2's *uninstall* command db2unins with the -d
parameter:
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.d
oc/doc/r0023371.htm


Take care not to run this command without parameters as this will *remove*
all DB2-products in the current installation directory tree!

HTH.

Signature

Jeroen

1. db2ls command

Asuwish - 30 Sep 2007 14:26 GMT
> >> "Asuwish" <am...@oft.co.il> wrote in message
>
[quoted text clipped - 43 lines]
>
> -               -
Hi again.
What is the reason that the db2ls doesn't exists in all my machines?
Is it exists only in DB2 server installing?
Darin McBride - 09 Oct 2007 14:48 GMT
> Hi again.
> What is the reason that the db2ls doesn't exists in all my machines?
> Is it exists only in DB2 server installing?

No, it exists only in Linux/Unix.  It does not exist in Windows.  Note that
sometimes /usr/local/bin isn't in your PATH, so it may only appear not to
be there - but when you add /usr/local/bin to your PATH, it will now show
up.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.