Articles & Content


DB2 UDB Monitoring with Scripts (D11)

Topic: DB2 for LUW

Subtopic: 2005

DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: Thomas Horner (S1 Corporation)

This presentation will cover in detail ten shells that I have implemented to monitor our DB2 UDB production databases on AIX. These shells are quick and easy to implement, and for our DB2 installations give us warning of potential or real problems. They include full backups, log backups, update statistics and reorg checks, get status, and file cleanup. This seminar will go through each script in some detail, showing what they do and how to implement them in an AIX/UNIX environment.

EXP. LEVEL: Beginner


Purpose of these database administration shells

Overall design philosophy of these shells

Details of each shell

Limitations of shells

Questions and comments

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.