Terry Purcell
  • Male
  • United States
Share

Terry Purcell's Friends

  • Manali Maity
  • Bill Gallagher
  • Greg Parrish
  • Larry Kirkpatrick
  • Craig S. Mullins
  • Kevin Harrison
  • Ron Brown
  • Howie Hirsch
  • Kate Riley Tennant
  • Nick Manu
  • Surekha Parekh

Gifts Received

Gift

Terry Purcell has not received any gifts yet

Give a Gift

 

Terry Purcell's Page

Profile Information

What best describes your job role?
Application Architecture, Application Development, Database Administration, IBM Employee / Business Partner

Terry Purcell's Blog

Got static (SQL)? Then you need to do this (somewhat) regularly in DB2 10 or 11 for z/OS.

Posted on September 26, 2016 at 4:00 0 Comments

By Terry Purcell

When DB2 9 for z/OS delivered plan management, the goal was to allow a backup of your static SQL packages such that you could “switch” back to the prior “good” access path if a new REBIND resulted in regression. Although optional in DB2 9, EXTENDED became the default in DB2 10 for z/OS – which allowed an “original” and a “previous” to be stored. The previous would be replaced each REBIND, but the original – that is populated upon first REBIND when…

Continue

Ensure you have a simple base of statistics before exploiting the Optimizer’s externalization of missing statistics in DB2 11 for z/OS

Posted on August 16, 2016 at 21:02 0 Comments

I recently wrote about the most common mistakes that are made with respect to RUNSTATS collection in DB2 for z/OS. [[LINK: http://destinationz.org/Mainframe-Solution/Systems-Administration/Make-No-Mistake ]] The responses were positive, but looking into this further, I see that these mistakes are being made more frequently…

Continue

Common DB2 for z/OS RUNSTATS collection mistakes

Posted on June 13, 2016 at 15:58 8 Comments

The DB2 optimizer exploits the catalog information to choose an access path for a given SQL statement, and RUNSTATS is what populates the catalog. It is important therefore to collect a good base of statistics to give the optimizer a fighting chance of choosing well-performing access paths for your SQL.

Here we will discuss some common mistakes that are made when running RUNSTATS.…

Continue

Comment Wall

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

  • No comments yet!
 
 
 

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

Posted by Paul McWilliams on September 21, 2018 at 17:26 0 Comments

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out…

Continue

Videos

  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service