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