DB2 FOR i5/OS SQL PERFORMANCE WORKSHOP
March 17 -19 Three day course (09.00 - 17.00 each day): Mike Cain, IBM:
Learn a methodology for tuning IBM DB2 for i5/OS Structured Query Language (SQL) data access and query processing for optimum performance. Explore the science and methods behind the DB2 for i5/OS query optimizer and how they relate to database performance. Discuss performance issues affecting the design of the database and the applications using the database, database performance parameters, and the various tools that assist in performance monitoring, analysis and tuning.
Understand the art and science of DB2 query optimization within i5/OS Explain the methodology for tuning and monitoring DB2 for i5/OS SQL and query performance Discuss how to design high-performing SQL applications on the iSeries and System i Recognize the database and system parameters that can impact performance DB2 for i5/OS Query Optimizer Parallel database processing - DB2 Symmetric Multiprocessing (SMP) Indexing and statistics strategies SQL application design and programming issues Tools to use for monitoring and evaluating performance Best practices for popular SQL interfaces, such as Open Database Connectivity (ODBC), Call Level Interface (CLI), and Java Database Connectivity (JDBC)
Target audience:
i5/OS database designers, performance analysts, and application developers who are concerned about SQL and query performance. The course is highly recommended for individuals interested in SQL and query performance within OS/400 and i5/OS on the iSeries and System i.
Where:
Iptor Konsult AB
Falkenbergsgatan 3
Göteborg
Registration:
To register, please send an email directly to se.training@iptor.com.
The fee for this workshop is 18.480 SEK.
