|
|
| |
 Workshop description: SAP and IBM DB2 for i SQL Performance Monitoring and Tuning Workshop
| | |
| |
|
|
|
| Workshop code |
SQLOPTSAPoni |
Skill level |
Intermediate |
| Duration |
3.5 days |
Delivery type |
Classroom or instructor led distance learning |
| Workshop type |
Public or Private on-site |
|
|
| Public price |
USD $2000 plus tax |
|
|
|
Learn a methodology for tuning IBM DB2 for i Structured Query Language (SQL) data access and query processing for optimum performance in an SAP environment.
Explore the science and art behind the DB2 for i query optimizer and how they relate to database performance. Learn the methods and strategies used by the database engine to run SQL queries.
Discuss and use the various database performance parameters and both IBM i and SAP tools that assist in database performance monitoring, analysis and tuning.
|
|
IBM i (previously i5/OS) database engineers, performance analysts, system administrators, and SAP Basis administrators who are concerned about SQL and query performance. The course is tailored for individuals running SAP on IBM i.
|
- Intermediate knowledge of SQL and relational database concepts
- Basic understanding of DB2 for i
- Basic understanding of IBM i work management
- SAP on IBM i Basis experience
|
- Understand the art and science of DB2 query optimization within IBM i
- Explain the methodology for tuning and monitoring DB2 for i SQL and query performance
- Discuss how to monitor, analyze and tune DB2 specific to SAP on the IBM i platform
- Recognize the database, system, and application parameters that can impact performance
|
- DB2 for i Query Optimizer and database engine
- Index creation and use strategies
- Tools to use for monitoring and evaluating SQL performance
|
| |
|
|
|
