Archives

DB2 z/OS: Traditional Maintenance Versus Real Time Maintenance On Demand (B12)

Topic: 2008 EU

Subtopic: DB2 for z/OS

---

DATE: 2008-10-15 (16:15 - 17:15)
SPEAKERS: Stephan Terhorst (LVM Versicherungen)

IBM's utilities get better and better with every version.In particular,today's utilities support the coexistence of maintenance in parallel to online. But how can a DBA most efficiently use the functions of the current utility generation?At LVM,maintenance procedures have been implemented that get the best out of all available utility functions in order to insure efficient and secure operations of our applications.I will present our methodology to design a maintenance procedure based on Real Time Statistics that efficiently fulfils all maintenance requirements, while saving resources.I will show years of experiences in using real time statistics.With our real-time maintenance procedures,we are not only in the position to guarantee shorter recovery times and more efficient access paths,but also to save money by running maintenance on demand.A real time maintenance process saves system resources and economically realizes the many advantages of using the z/OS platform.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Traditional Maintenance - the starting point for database maintenance

Real Time Statistics - what DB2 knows about the data without analysis runs

Real Time Statistics - Which problems can the DBA expect to solve?

Batch Maintenance versus Maintenance on Demand - How flexible can utility jobs be? - Working all the day!

Savings and efficiency - Does On Demand maintenance calculate itself?

---

Click to Download

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