“Show Me What You Got, Db2!” (my favorite Db2 for z/OS -DISPLAY commands)

Robert Catterall, IBM

Download PDF

Various Db2 for z/OS monitoring and management tools are of great value in gaining insight into the operations of a Db2 system, but Db2 itself can also provide very useful and actionable information via a variety of commands that start with one word: DISPLAY. In this session, I’ll explain how I utilize the output of various of my favorite Db2 commands of this nature, including:



Robert Catterall is a Principal Db2 for z/OS Technical Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company’s Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG’s Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/