“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:
- -DISPLAY BUFFERPOOL
- -DISPLAY GROUPBUFFERPOOL
- -DISPLAY DDF
- -DISPLAY GROUP
- -DISPLAY LOCATION
Bio
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/