Articles & Content


Hell’s Kitchen; DB2 9, A DBA’s Recipe for Success (B01)

Topic: DB2 for z/OS

Subtopic: 2010

DATE: 2010-5-11 (12:30 PM - 01:30 PM)
SPEAKERS: Rob Crane II (FedEx)

Finding the right recipe for success with your DB2 9 implementation can be a challenge. Come gain insight into a recipe that served FedEx well during their implementation of DB2 9. Learn about their experiences, best practices and issues faced along the way. Come away with ideas for a tasty recipe tailored for your shops needs.

EXP. LEVEL: Beginner,Intermediate


Preparing your environment for DB2 9 - DB2 9 rollout schedule, managing the modes of DB2 to meet your needs across your enterprise. - Enabling ease of maintenance and SMPE work - Getting your client environment ready for DB2 9 (db2jcc.jar, db2 connect, OSC)

Performance & Environment Validation, how will you show the effect of DB2 9 on your system and applications? - System level metrics, are you healthy? Can you measure and compare these metrics? Memory, DBM1 and Memusage. The pools (EDM, RID, Buffer Pools). - Performance Triage and Surgery, to ensure rebind and the new Optimizer has provided your applications with value. o Prior to Rebinds, what have you done to seed DB2 with statistics gathered while on DB2 9? Manage the migration plan or the migration plan will manage you. o Access Paths, metrics & comparisons. o Access Plan Management, for package based DBRMs. How will you manage this process and know when to fall back your access path? o Access Paths don't show the entire picture, supplement with execution measurements to get the true picture of the optimizer's decision. o Managing new and prior Opthints through the migration and modes of DB2. o OSC, Stats Advisor, ETR for any issues or hints required.

What happened to my workfile? Make sure your mix is right our the recipe will suffer. - Understanding your existing environment and application footprint. What are you using today for workfile and temp database storage? - Best practice for selecting a DGTT versus a CGTT, along with a naming standard for these objects. - DB2 9 changes and how to adapt to them. o MaxTemps o Workfile Tablespace monitoring, naming and creation tips o Finding DGTT post DB2 9. o Should you segregate your DGTT objects? If so what are your choices? - Examples of recipes gone bad and some PTFs to help them revive.

Partitioned Reorgs, what to look for and NPI changes tied to elimination of the Build2 phase. - Elimination of the Build2 phase. Impact to runtime and switch phase timing. - Shadow space for the index, ensuring you can manage the needs through proper SMS allocations and segregation of reorg activity. - Date based partitions; do you really need to reorg if all you want is the compression dictionary for the new growth? Load Copy compression dictionary, consider your alternatives. - DB2 9 Issues and alternatives including a few PTFs and Zparms to be aware of.

Just when you thought you had the winning recipe, you're ingredients run out, how to put the spice back into the RBA. - Calculating Current log rba and number of days before you run out or RBA range. - DSNJ032I -DBP1 DSNJW307 WARNING - APPROACHING END OF THE LOG RBA RANGE - Steps to conduct a log RBA reset

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.