Articles & Content

Archives

Advanced EXPLAIN for Green Screens (E15)

Topic: DB2 for z/OS

Subtopic: 2008



DATE: 2008-10-16 (10:30 - 11:30)
SPEAKERS: Daniel Luksetich (YL&A)

With recent enhancements to the DB2 for z/OS product, IBM has delivered some extremely useful and advanced features for query performance analysis. These features come in the form of GUI based tools that run on a PC, and connect remotely to a DB2 for z/OS data server. What happens, however, when shop standards don't allow remote access to the data server? What happens when PC software standardization does not allow for these tools to be installed on a PC? Are those users out of luck? No. This presentation will intoduce users some of the EXPLAIN tables used by these tools for advanced query analysis, and demonstrate how SQL queries can be used to gather and analyze the advanced information without having to use the tools. All you need is SPUFI and some cool queries!

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

To understand the purpose of the advanced EXPLAIN tools

To understand the advanced EXPLAIN tables and how to create them yourself

Writing queries to get EXPLAIN information within SPUFI

To focus only on the EXPLAIN columns needed for quick performance analysis

Tuning queries with the additional EXPLAIN information



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.