By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

DB2 Instance Status

P: n/a
Dear Friends
Is there any systables in DB2 Database for the following :

How to display instance name and instance status

How to display database name and database status

How to display backup information

How to display any locks created on db or not

Pls i need select statements for all above questions

Appreciate your help

Satish

Apr 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
V_S_H_Satish wrote:
Dear Friends
Is there any systables in DB2 Database for the following :

How to display instance name and instance status

How to display database name and database status

How to display backup information

How to display any locks created on db or not

Pls i need select statements for all above questions

Take a look at teh snapshot table functions.
There are also some GET_DB and GET_DBM functions

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.