VSH wrote:
Dear Friends
First i like to introduce myself. I am satish working as Oracle and Ms-SQL
DBA from last 4yrs.
My compnay recently introduced DB2 Database in one of our projects.
I installed DB2 8.1 successfully.
I have some doubts in DB2 Can any one of you pls provide the following
outputs.
1. Is there any select statement or any table to see the instance status.
2. Select statement or any table to see Database Status
3. Database backup status whether it is successful or not.
4. Is there any select statment to see list of all archive log files.
5. pls provide any sample script where i can execute all above commands in
one script.
I need to prepare checklists like as follows
Instance Name
Instance Status
Database Name
Database Status
Backup Startup
Backup Endtime
DB2 provides a lot of admin table functions.
For example:
http://publib.boulder.ibm.com/infoce...n/r0012548.htm
You can also get the DB and DBM configuration.
Just check the list of table functions in the SQL Ref.
Make sure you're on Db2 V8.1.9 (aka V8.2.2) or higher to get the full
benefit.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab