Blog
DB2utor

Categories

August 21, 2012

Real Memory, Rebind are Key Migration Considerations

After attending some IBM briefings and special panels, I've concluded that customers that migrate to DB2 10 for z/OS will see varying levels of CPU savings. However, to get the most from your move to DB2 10, there are steps you can and should take in advance of the migration.

The IBM developerWorks DB2 for z/OS best practice page contains some excellent material on migration. In particular, IBMer John Campbell, Distinguished Engineer, DB2 for z/OS development, has an amazing presentation on DB2 10 migration planning. One key point is where he recommends increasing real memory from 10 percent to 30 percent (see slide 10 in part one).

In addition to adding memory, you should rebind all of your packages and set page fix to Yes (PGFIX=YES). Then make sure you've allocated enough real storage to support the 1M page frames. One hundred percent of your bufferpools must be supported by real memory.

Taking these steps will help you maximize CPU savings from your DB2 10 migration. I also highly recommend John's presentation to anyone who's planning a migration. Here are the links to the two-part video.

* DB2 10 for z/OS Migration Planning and Very Early Experiences Part 1:
                Video

                Presentation 

                Transcript

* DB2 10 for z/OS Migration Planning and Very Early Experiences Part 2:

                Video 

                Presentation 

                Transcript
 
Have you recently migrated to DB2 10? How much memory did you add? Have you seen the CPU improvements you hoped for? Please share your thoughts in Comments.