|
Home > Training >
|
WA1887 DB2 Query Management Facility (QMF) Training and Courseware
|
|
The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build “custom:” reports from DB2 data using the extensive powers of the QMF FORMs panels. Use several other QMF facilities such as Help, Retrieve/”?”, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs. |
|
|
|
| Topics |
| |
- Performance Overview with Guidelines
- Stage 1 and Stage 2 Predicates
- EXPLAIN Plan / VISUAL EXPLAIN with Examples – TS, MIS, NMIS, IXONLY, SORT, Part Scan
- SQL RE-Coding Guidelines
- Using EXPLAIN Plan / VISUAL EXPLAIN to improve SQL Performance
- The DSN_STATEMNT_TABLE
- Improving SQL statements using EXPLAIN Plan / VISUAL EXPLAIN results
- Join Performance Analysis - The 3 Join Methods, Influencing the Join Method????
- SubQuery Analysis - Single Valued, Multiple Valued, Correlated
- UNION Analysis - The “Good“ and the “Bad“ of UNION
- Application Program Performance Analysis – REOPT, Optimize for N rows, Dynamic SQL, PK & FK, Prefetch, Correlated Columns, Massive Batch Jobs, Massive Online Jobs
- VQUBE – Very Quick Upper Bound Estimate
- Visual Explain, Performance Analyzer
|
| |
| What you will learn |
| |
After completing this course, the student should be able to:
- Explain DB2 concepts, terminology and components
- SELECT rows of data from DB2 tables using the WHERE clause to retrieve specific rows
- Format QMF Reports by modifying the QMF FORM
- Use several QMF Commands – LIST, RUN, SAVE/DISPLAY, EXPORT/IMPORT, SHOW
- Build Queries with the PROMPTED MODE
- JOIN tables together to get information from each
- Use the SQL SubSelect feature of SQL
- Build QMF Reports “beyond the basics” using FORM.MAIN, FORM.PAGE, FORM.COLUMNS,
FORM.FINAL, FORM.BREAK1-6, and the (form) LAYOUT command
- Build QMF Reports using “additional FORM features” such as FORM.OPTIONS, FORM.DETAIL,
FORM.CALC, FORM.COND
- Build QMF PROCedures to Run a series of QMF commands allowing for user input of Data and SQL as VARIABLES
- Use the QMF TABLE EDIT facility to SEARCH through a table and to make CHANGES to a table
- Build SQL SELECT, INSERT and UPDATE statements using the QMF DRAW command
|
| |
| Audience |
| |
End-Users and Information Technology personnel who need use the Query Management Facility (QMF) to build reports from DB2 data.
|
| |
| Prerequisites |
| |
At least six months of TSO/ISPF experience is recommended. No previous database experience is needed.
|
| |
| Duration |
| |
Three Days. |
|
|
Course Outline
Day 1
- DB2 Concepts and Terminology
- The SELECT Statement
- QMF Basics
- QMF PROMPTED Query - Introduction
- Join and SubSelect
- QMF PROMOTED Join 1
- QMF PROMOTED Join 2
Day 2
- QMF Report Formatting 1
- QMF Report Formatting 2
- QMF Forms Show
- QMF Export Import
- QMF Form Detail
Day 3
- QMF PROCs – Multiple QMF Commands
- QMF PROCs – VARIABLES as Data and as SQL components
- QMF TABLE EDITOR - Search
- QMF TABLE EDITOR - Change
- QMF DRAW
|
|
|
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston,
Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
|
|
|
