Articles & Content


DB2 UDB Monitoring with Scripts (D11)

Topic: 2005 NA

Subtopic: DB2 for LUW

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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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