Articles & Content
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
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?
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.