Articles & Content

Archives

Implementing Real Time statistics for utility automation at JN Data (B16)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-16 (11:45 - 12:45)
SPEAKERS: Svenn-Aage Sønderskov (JN Data)

As a merged company, JN Data is automating as many of the daily routines as possible, and we have built a utility-automatition tool whch handles backup, reorg, Runstats and DSN1COMP.The System is built on top of Real Time Statistics which is part of the DB2-installationThe system generates jobs and cooperates with TWS to avoid schedule-conflicts.The implementation of this tool has resulted in significant reduction in CPU, IO and storage, which actuallly postponed a CPU-upgrade worth 2 million Euro.

EXP. LEVEL: Intermediate

OBJECTIVES:

How to set up Real Time Statistics

How to standardize Utility-workload

How to optimize utility-workload

How to benefit from automating utilities

How to become a happy DBA



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.