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.
- $ 2,947.00 (CAD) : Multi-seat - $ 1,997.00 (CAD)
The student will learn how to tune applications that use the DB2 environment, as well as design data bases to minimize the use of system resources.
Technical personnel who need to optimize the performance of a DB2 application system.
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