Articles & Content

Archives

How I Learned to Stop Worrying and Love Plan Management (B01)

Topic: 2011 NA

Subtopic: DB2 for z/OS



DATE: 2011-5-3 (12:45 PM - 01:45 PM)
SPEAKERS: Gerald Hodge (HLS Technologies, Inc.)

Plan Management was introduced in DB2 9 and brought forward to DB2 10. Access Path Stability introduces new bind options in DB2 10. Both of these functions are proving to be invaluable tools when doing conversions to DB2 9 and DB2 10. However, for IT Professionals who started with DB2 Version 1 these features can produce challenges to their hard learned belief systems. This is the story of how IT Professionals can exploit these high-value features and how their use in multiple Version-to-Version migrations will make them a necessary part of any safe future conversion.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Understand why IBM is forcing rebinds of older packages with each new DB2 Version.

Understand the potential impacts and improvements theses rebinds will cause

Find out how to estimate your exposure to these rebinds

Understand the methods for using Plan Management and what the different choices mean.

Find out how Access Path Stability closes an exposure that can occur with Plan Management



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.