Or somethinhg like

for i in `db2ilist`
do
echo "number of processes for $i"
ps -eaf | grep $i | grep db2sysc | wc -l
Done



-----Original Message-----
From: abraham
[mailto:db2udbdba-ezmlmshield-x20896832.[Email address protected]
Sent: Thursday, September 30, 2004 5:03 PM
To: LazyDBA Discussion
Subject: Re: How to the status of all instances on a unix server



Ps -ef | grep -i <instance_name> | uniq

do for every instance




"Stephane Paquette "

<db2udbdba-ezmlmshield-x33303185.[Email address protected]
To:
om>
"LazyDBA Discussion"

<[Email address protected]

cc:
Thursday September 30, 2004 04:50 PM
Subject: How to the status of all

instances on a unix server






Hi,

We are using db2 udb 8.1 on aix .
After a server reboot, what is the easiest way to check that all instances
are up ?

It seems that by doing ps -ef|grep db2loggwr is ok since all our db used
logretain on. Is there another more secure way (in case logreatin if off) ?




Thanks,


Stéphane Paquette<?xml:namespace prefix = o ns
= "urn:schemas-microsoft-com:office:office" />


Administrateur de bases de données

Database Administrator

Standard Life

www.standardlife.ca

Tél. (514) 499-7999 poste 7470 stephane.[Email address protected]




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page