DB2 Instance Status
This is a discussion on DB2 Instance Status within the DB2 forums, part of the Database Server Software category; --> Dear Friends Is there any systables in DB2 Database for the following : How to display instance name and ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:49 AM
| ||||
| ||||
 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      |
|
02-27-2008, 07:49 AM
| ||||
| ||||
| Re: DB2 Instance Status 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 |
Linear Mode
