Articles & Content

Archives

Diagnose Types for DB2 Utilities (A08)

Topic: DB2 for z/OS

Subtopic: 2011



DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Patrick Gannon (IBM )

The DIAGNOSE utility is one of the most unknown of all the DB2 utilities available in IBM's suite. It serves a specialized function and yet a very valuable one. It not only helps database administrators and system programmers to control their environment but provides valuable information back to IBM DB2 Level 2 and development support. This presentation will touch on some of the available parameters in DB2 z/OS V10 as well as provide some valuable insight into one of the more obscure keywords, TYPE. DIAGNOSE TYPE is primarily requested by DB2 support to provide diagnostic output and/or a feature exploitation in support of problem determination or to help the customer in a work around situation. We will discuss some of the more pervasive ones and how to best use them in your own environment in an as needed basis.

EXP. LEVEL: Advanced

OBJECTIVES:

Learn what DIAGNOSE Utility and it's keywords

Understand how to use DIAGNOSE TYPES appropriately and why DB2 support occasionally asks for them.

How to use and benefit from parameters used by support when running DB2 Utilities.

Understand the output of DIAGNOSE TYPE parms

Achieve performance and availability benefits by using DIAGNOSE TYPES



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.