Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2006

Tip: Looking for answers? Try searching our database.

DB2 DAILY CHECK LISTS SCRIPT

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
VSH - 30 Apr 2006 09:13 GMT
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

Appreciate your help

cheers

satish
Serge Rielau - 30 Apr 2006 12:40 GMT
> Dear Friends
>
[quoted text clipped - 27 lines]
> Backup Startup
> Backup Endtime
DB2 provides a lot of admin table functions.
For example:
http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/ad
min/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
Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

VSH - 03 May 2006 16:33 GMT
Thank you friends. Very usable information

cheers

satish
Dave Hughes - 30 Apr 2006 19:20 GMT
> Dear Friends

[snip]

> I need to prepare checklists like as follows
>
[quoted text clipped - 10 lines]
>
> satish

Didn't you ask this same question a week or so ago? Yup, here we go:

http://groups.google.com/group/comp.databases.ibm-db2/browse_frm/thread/
5f030376568c9515/2332888e7b4b4813#2332888e7b4b4813

Was there something wrong / incomplete with the two responses you
received? If so, please elaborate and explain what was missing.

Dave.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.