Improved Db2 for z/OS CHECK LOB performance

By Haakon Roberts and Ann Hernandez

If you run the CHECK LOB utility in Db2 12 or Db2 11 for z/OS, you will be happy to learn that performance has just gotten better. The IBM Db2 Development team has recently changed the code so that the CHECK LOB utility now uses more prefetch than before. This can result in a dramatic reduction in synchronous read I/O and a significant reduction in CPU and elapsed times.

Internal testing shows a reduction in CPU time of 47% and a reduction in elapsed time of 92%, due to the use of prefetch engines. Your results will undoubtedly vary, but performance should be significantly better than before.

To take advantage of this enhancement, apply the relevant PTF for APAR PI83928 PERFORMANCE ISSUE FOR CHECK LOB ON SYSPUXA, based on your version of Db2:

  •     Db2 12 PTF: UI49578
  •     Db2 11 PTF: UI49584

#Db2z  #Db2News #Db212 #Db211 #Db2Utilities

Views: 171

Add a Comment

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

Join The World of DB2

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

Top Discussions 

User Groups


  • Add Videos
  • View All

IDUG Conference News

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service