Hello Everybody,

I have just joined -- New ! So I will start with simple things.

I need to find state of the machine (Windows for now)
i.e if
1. DB2 Server is running - or not running ?
2. DB2 is installed or not installed ?

Secondly
If DB2 Server is Running - How could I interact with it without logging into just to find its existance. i.e. DB2 Get Connection State

Thanks
DBFinder

To see if the system is up, you can try either of these two commands:

db2 list active databases
db2 list applications

To see if DB2 is installed, try this command:

db2level


For the second part, see the first question above.

Andy

Thanks ARWinner
DB2LEVEL was actually I needed to use for now.

My Next step will be to find free %age usage of on various Servers TABLESPACE

Any help will be appreciated

What DB2 version and OS are you using?

Andy

Working on DB2 V8.2 servers on Windows
Going to upgrade to v9.5 soon

Thanks for your time
DBFinder

For V8.2 look here:

http://publib.boulder.ibm.com/infoce...n/r0007091.htm

For V9.5, look here:

http://publib.boulder.ibm.com/infoce.../r0022016.html

Andy

Thanks

DBFinder