Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DB2 - check if product installed on Solaris/AIX/HPUX

 
   Database Help (Home) -> DB2 RSS
Next:  date_create  
Author Message
pwu

External


Since: Oct 09, 2008
Posts: 2



(Msg. 1) Posted: Thu Oct 09, 2008 11:37 pm
Post subject: DB2 - check if product installed on Solaris/AIX/HPUX
Archived from groups: comp>databases>ibm-db2 (more info?)

Hi,

I am doing an automated scan of a large number of UNIX machines which
can be Solaris, AIX or HPUX.

I want to find out for a machine via a script if:
1) DB2 is installed?
2) If installed what version is installed

What file/process/user can I check to achieve this?

Thanks for any help.

 >> Stay informed about: DB2 - check if product installed on Solaris/AIX/HPUX 
Back to top
Login to vote
Saurabh.Nr

External


Since: Oct 10, 2008
Posts: 6



(Msg. 2) Posted: Fri Oct 10, 2008 2:04 am
Post subject: Re: DB2 - check if product installed on Solaris/AIX/HPUX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Oct 10, 11:37 am, p....DeleteThis@qantas.com.au wrote:
> Hi,
>
> I am doing an automated scan of a large number of UNIX machines which
> can be Solaris, AIX or HPUX.
>
> I want to find out for a machine via a script if:
> 1) DB2 is installed?
> 2) If installed what version is installed
>
> What file/process/user can I check to achieve this?
>
> Thanks for any help.

you can write a script using db2ls and db2level ...command

 >> Stay informed about: DB2 - check if product installed on Solaris/AIX/HPUX 
Back to top
Login to vote
Christian Tanner

External


Since: Oct 10, 2008
Posts: 1



(Msg. 3) Posted: Fri Oct 10, 2008 6:25 am
Post subject: Re: DB2 - check if product installed on Solaris/AIX/HPUX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

DB2 v9 is default installed in /opt, older version may have a default
install in /usr. You might have a custom install directory.
you might check these directories for the occurence of the file db2level

find /opt /usr -name db2level -print
/opt/IBM/db2/V9.5/bin/db2level
/usr/opt/db2_08_01/bin/db2level
/usr/opt/db2_08_01/bin64/db2level
/usr/opt/db2_08_01/das/bin/db2level
/usr/opt/db2_08_01/das/bin64/db2level

this shows i have v9.5 and v8.1 db2 products installed on my AIX machine



<pwu.DeleteThis@qantas.com.au> wrote in message
news:bc0ef6aa-0f02-4531-b6fd-f5f048be399b@p10g2000prf.googlegroups.com...
> Hi,
>
> I am doing an automated scan of a large number of UNIX machines which
> can be Solaris, AIX or HPUX.
>
> I want to find out for a machine via a script if:
> 1) DB2 is installed?
> 2) If installed what version is installed
>
> What file/process/user can I check to achieve this?
>
> Thanks for any help.
 >> Stay informed about: DB2 - check if product installed on Solaris/AIX/HPUX 
Back to top
Login to vote
stefan.albert

External


Since: Jan 31, 2008
Posts: 14



(Msg. 4) Posted: Fri Oct 10, 2008 8:37 am
Post subject: Re: DB2 - check if product installed on Solaris/AIX/HPUX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I can only speak for AIX - but it might work for HP-UX and Solaris
also...

In the directory /var/db2 (if it exists - if not DB2 should not be
installed)
you'll find a file named "global.reg"
It contains all informations about installed software and instances.
It is a binary file - so a bit hard to get informations from...

First of all: If it exists, this is an indicator that DB2 is installed
- or was installed.

You can use "strings" to look for pathnames in this file and parse
them and check if it contains a subdirectory "bin" and a program
"db2ilist" or "db2greg". The last one gives readable output for the /
var/db2/global.reg
This you can use to obtain the software installed (might be deleted)
and the instances with their software level.

The informations about instances should be actual, the ones about
installed software not - we delete manually "old" fixpack versions and
so they stay in this file. Check the directories if they are
populated.

Keep in mind, that you can have several versions of DB2 and fixpack
levels installed and active.
For each instance you'll find the level inside /var/db2/global.reg


On Oct 10, 8:37 am, p... DeleteThis @qantas.com.au wrote:
> Hi,
>
> I am doing an automated scan of a large number of UNIX machines which
> can be Solaris, AIX or HPUX.
>
> I want to find out for a machine via a script if:
> 1) DB2 is installed?
> 2) If installed what version is installed
>
> What file/process/user can I check to achieve this?
>
> Thanks for any help.
 >> Stay informed about: DB2 - check if product installed on Solaris/AIX/HPUX 
Back to top
Login to vote
Darin McBride

External


Since: Jul 17, 2003
Posts: 72



(Msg. 5) Posted: Fri Oct 10, 2008 1:53 pm
Post subject: Re: DB2 - check if product installed on Solaris/AIX/HPUX [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

pwu.DeleteThis@qantas.com.au wrote:

> Hi,
>
> I am doing an automated scan of a large number of UNIX machines which
> can be Solaris, AIX or HPUX.
>
> I want to find out for a machine via a script if:
> 1) DB2 is installed?
> 2) If installed what version is installed
>
> What file/process/user can I check to achieve this?
>
> Thanks for any help.

The way as defined by IBM:

/usr/local/bin/db2ls -c

This will give you an output that should be relatively easily parsed by
code. If db2ls is not found, then DB2 9 or later is not installed (or at
least, not installed properly).
 >> Stay informed about: DB2 - check if product installed on Solaris/AIX/HPUX 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
db2 procedure in solaris - Here are two simple stored procedures which were there in a database on a SOLARIS machine, one with an input parameter and the other with no parameter. From a Linux DB2 client command prompt, the call to stored procedure with no parameter works fine wher...

Just installed DB/2 9.1 on AIX, no db2cc? - I was using DB2 9.1 on Linux which came with db2cc The same level of DB2 on AIX 5.3 with the same install options and there is no db2cc in the sqllib. I know that db2cc is a script so trying to run the command on the AIX box gives: $ db2javit -j:CC....

Yellowfin seeks resellers for BI product - By Jenny Eagle , August 6th 2008 02:45PM Business Intelligence developer, Yellowfin, has taken two mature technologies - BI and GIS - and combined them to create its flagship solution, Yellowfin Business Intelligence 4.0. According to CEO Glen Rabie..

Product / license for z/OS Universal Driver on clients - I apologize if this is available in a FAQ somewhere. My question is this: The DB2 Universal Driver jars are shipped with DB2 for z/OS (db2jcc.jar and db2jcc_license_cisuz.jar). If a developer wants to use these on his workstation (for type-4..

Hepl please - Product stop to work on DB2 v9.1! - Hello. Our product works fine on all 7.x and 8.x DB2 versions. But stops to work on DB2 v9.1. The main problem is - duplicate primary key (sqlcode=-803) happens when inserting records in QUEUE table. The primary key of QUEUE table is - 3 fields - QID ....
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]