DB2 for z/OS & OS/390: Exploiting the Optimizer
Wise Ltd -
1 day - Advanced - Public & In-House - £300
Course Code: DZOOPT
Send A Message
Description and objective: AUDIENCE: Application Developers, Programmers, System
Programmers, Database Administrators and System
Administrators.
PREREQUISITES: A working knowledge of SQL predicate types, I/O types and
SQL statements such as SELECTs, UPDATEs, JOINs,
UNIONs, etc.
DURATION: 1 day
SUMMARY: This course uses information gained from our instructor's
empirical knowledge coupled with that gained from a variety
of IBM capacity planning and other publications to
consolidate conclusions about the DB2 Optimizer. These
conclusions, when observed, should assist those
concerned with SQL and application performance in
optimising the following:
= Use of filter factors
= I/O costs
= CPU costs
= Indexing
= Access path selection
= BIND/REBIND choices
= ZPARM choices
= IRLM choices
OBJECTIVES: Upon completion of this presentation, the participant should
be conversant with how the DB2 Optimizer for z/OS &
OS/390 chooses an access path, how the user can override
the chosen access path, etc.
For more information visit our website: www.wiselimited.com
Contact Wise Ltd
| Phone | 01403 269247 When calling be sure to mention Training Pages
|
Send a Message
Back to Top