Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
DB2 Visual Explain for SQL Application Performance Analysis
Overview

This course gives a brief overview of DB2 SQL performance considerations, including establishing goals for Application SQL performance.

We explore the capabilities of Visual Explain that are beyond those of the Explain Plan SQL statement - Filter Factor analysis, Stage1 and Stage2 analysis, number of rows returned.

The Visual Explain performance analysis capabilities are used to explore several SQL statements to illustrate the major DB2 data accesses - Table Space scans, Non-Matching and Matching Index scans, Index only access, and understanding sort impact.

Extensive, guided workshop sessions give additional insights into performance analysis using Visual Explain. One workshop improves performance of SQL statements via rewriting them.

LEARNING OBJECTIVES

As a result of this class, the attendee will be able to

  • Examine Application performance goals
  • Explain the additional capabilities of Visual Explain that are beyond those of the Explain Plan SQL statement - Filter Factor analysis, Stage1 and Stage2 analysis, number of rows returned.
  • Use Visual Explain to discover DB2 SQL Access Paths
  • Use Visual Explain to discover DB2 SQL Filter Factors
  • Use Visual Explain to discover whether predicates are Stage 1 (early) or Stage 2 (late)
  • Use Visual Explain to discover if DB2 SQL access is Table Space (TS) scan or Matching Index (MIS) scan or Non-Matching Index (NMIS) access or Index Only access
  • Verify the validity of the number of rows returned Visual Explain
  • Develop a list of Tuning Tips for DB2 SQL Developers
Audience

This course is for experienced Data Processing personnel who need to use IBM's Visual Explain tool to analyze SQL statements to determine their performance "goodness".

Prerequisites

At least six months experience using DB2 SQL is needed. Previous DB2 SQL application performance analysis experience will be helpful, but, is not needed.

Course duration

1 day

Course outline

DAY 1
 
  1. Review the capabilities of Visual Explain
  2. Walk-thru how Visual Explain examines SQL access paths
  3. Use Visual Explain to examine SQL access paths
  4. Workshops using Visual Explain
Appendices

Appendix A - IBM Sample Tables
Appendix B - Bibliography
Appendix C - EXPLAIN PLAN Statement - PLAN_TABLE and DSN_STATEMNT_TABLE
Appendix D - Visual Explain Overview
Appendix E - Workshop Exercises

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy