Articles & Content

Archives

To REORG or not to REORG, That is the Question (H12)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-21 (04:00 PM - 05:00 PM)
SPEAKERS: Kevin Baker (BMC Software, Inc.)

Do you run REORGS on a fixed schedule or when certain statistics thresholds are reached? Are they actually helping your applications? This session will explore techniques for correlating real I/O performance to the need for pageset reorganizations. There are potentially savings to be had if REORGS are only done when needed, which might be much less than you think.

EXP. LEVEL: Intermediate

OBJECTIVES:

Identify object and application triggers that help identify objects in need of reorganization

Establish a process for identifying application pagesets for analysis

Identify I/O performance trends for DB2 pagesets

Correlate reorganization benefits to I/O performance trends

Understand the best methods for collecting I/O performance data



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.