Articles & Content


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

Topic: 2010 NA

Subtopic: DB2 for z/OS

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

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.