467,198 Members | 1,113 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

DB2 Instance Status

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
  • viewed: 1713
Share:
1 Reply
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.

Similar topics

6 posts views Thread by Vance Kessler | last post: by
reply views Thread by XML newbie: Urgent pls help! | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.