Why take this course?
After completing this course, you will be able to
- Understand and explain the major components of the DB2 architecture.
- Use EXPLAIN output to determine DB2 access strategies and diagnose concurrency and performance difficulties.
- Understand and analyze DB2's strategy for performing joins, accessing cursors, and implementing subqueries.
- Understand DB2's strategy for selecting and using Indexes in data access.
- Arrange for efficient batch and utility processing using DB2.
- Use SQL to modify DB2 System Catalog Tables to influence DB2's choice of access paths.
- Understand the performance implications of using the DB2 security facilities.
- Understand and specify the parameters for the CICS and IMS attachment facilities
- Understand the performance implications of Data Base Design decisions and Data Definition parameters.
5 Days : Fee - $ 2,947.00 (CAD) : 
Multi-seat - $ 1,997.00 (CAD)
Multi-seat - $ 1,997.00 (CAD)Audience
Technical personnel who need to optimize the performance of a DB2 application system.Prerequisites
The student should have experience in using DB2, either in the areas of applications development or data base administration.Major topics covered
- DB2 architecture
- Application program tuning
- Access Strategies
- EXPLAIN, PLAN_TABLEs, DSN_STATEMNT_TABLEs, and DSN_STATEMENT_CACHE_TABLEs
- Indexable, Stage 1, and Stage 2 predicates
- Catalog tables and filter factors
- Catalog table modification
- Join and subquery access strategies
- BIND parameter considerations
- Concurrency and locking
- Batch issues
- Security issues and strategies
- Sequential and list prefetch
- Visual Explain
- Attachment facility issues, RCT parameters, and thread reuse
- Data base design considerations
- Utility issues
- DB2 traces and Instrumentation Facility
- DB2 system parameters
- z/OS issues