Articles & Content

Archives

Managing Your DB2 Maintenance - With RealTime DBAExpert (I06)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-20 (10:30 AM - 11:30 AM)
SPEAKERS: Ulf Heinrich (SOFTWARE ENGINEERING)

Some of the Europe's largest computer centers are using RealTime DBAExpert to manage their DB2 database maintenance 24x7 in real-time. This presentation will focus on how the tool monitors all objects of an entire DB2 subsystem and supports just-in-time online utility generation based on real-time statistics (RTS). In this presentation, we show how to set up real-time maintenance, what to consider when setting up RTS for maintenance decisions, and how to eliminate unnecessary RUNSTATS. We will demonstrate the tools integration with typical job scheduling systems like TWS (aka OPC), CONTROL-M, CA-7 and UC4 through the Dynamic Job Scheduler Interface (e.g., Batch Loader). Live examples of a running system are presented as well.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Utility Monitoring with RealTime DBAExpert

Real-time Statistics

Job Scheduler Integration for Utilities On Demand

Live example

Triggering utilities based on Recovery Time Objectives



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.