Articles & Content

Archives

IBM REORG Utility and Real Time Statistics ? Smooth Transition Tips and Tricks (A04)

Topic: DB2 for z/OS

Subtopic: 2011



DATE: 2011-5-3 (04:30 PM - 05:30 PM)
SPEAKERS: Paul Walters (Sallie Mae )

Present transition method for converting from a 3rd party Reorganization Utility to IBM's Reorganization Utility. Discuss options and management techniques for IBM Reorganization Utility. Tips for balancing tablespace and index reorganization. How to select Reorganization based on Real Time Statistics (RTS). Leverage RTS data for SQL tuning. Content Outline:1.

EXP. LEVEL: Beginner

OBJECTIVES:

Planning and executing a conversion of utility products.

Review advantages and disadvantages of IBM REORG utility.

Review changes to the Reorg utility that are with DB2 V9 and beyond.

How to manage object test? Deliver a balance between indexes and tablespaces reorganization.

Real Time Statistics (RTS) are excellent sources for reorganization selection. A successful implementation requires accurate RTS information. RTS information provides other valuable data points for other tasks including SQL tuning.



Click Here to Download

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