Course #:WA2281 DB2 UDB: Performance & Tuning in Linux/UNIX/Windows Environments Training This course is designed to teach how to develop, implement and maintain DB2 applications using advanced functions and features, with a view to optimising their performance. The course combines formal classroom tuition with realistic, practical exercises. Objectives On successful completion of this course attendees will be able to: develop DB2 applications with optimised performance attributes maintain and tune applications for optimised performance. describe effective techniques for advanced database management Audience Systems Administrators, Database Administrators and technical personnel who are involved in designing, planning, implementing and/or maintaining DB2 UDB Databases, up to version 9.7. within a Linux, UNIX, or Windows environment. Prerequisites A sound practical understanding of DB2 UDB. Duration 3 days Outline of DB2 UDB: Performance & Tuning in Linux/UNIX/Windows Environments Training 1. DB2 UDB Review Introduction The DB2 Family. 2. Advanced Database Management Advanced database management ( up to DB2 9.7) Tuning The Database Database Configuration File Partitioned Database Advanced Tablespace Management Advanced Table Management Table Partitioning Feature. 3. MQT Generating DDL Set Integrity Deep Compression. 4. DB2 System Catalog Attributes, including changes up to version 9.7 Consolidation of DDL with regard to efficiency and Version 9. Practical Exercise 1. 5. Locking Strategy What resources can be locked How To Set The Locking Locking Configuration Parameters Locking Terms Duration of a lock Commit/Rollback Logging How to find out what Locks are held Savepoints. Practical Exercise 2. 6. Indexing Physical data management Page Indexes Type 1/ 2 Indexes Design Advisor Utilities Runstats Reorg Autonomic Utilities Reorgchk Access Strategy Single Table Access Paths Multi table access path. 7. EXPLAIN Introduction Explain Tables Executing from the CLP Executing from the Command Centre DB2EXPLN Visual Explain 8. Clustering Multidimensional Clustering Range Clustered Tables The Organize by Key Sequence Clause Statistical View. 9. Triggers Stored Procedures Development center Types of stored procedure An external procedure The catalog SPL Stored procedure builder User Defined Functions. 10. Security Security levels Security administrator authority level Label based access contro Security label component Security structure examples. 11. Utilities BACKUP RESTORE LOAD IMPORT/EXPORT Introduction to Automatic Computing Configuration Parameters Collecting Catalog Statistics Health Center Remote Administration DB2 Administration Server. 12. Logs Logs, Snapshot ,Event Monitor, Db2pd And Trace Types of Logging Configuring Database Logging Information DB2DIAG Manual Reading of the Log Snapshot & Event Monitor DB2PD TRACE DB2TRC. We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question
Course #:WA2281 DB2 UDB: Performance & Tuning in Linux/UNIX/Windows Environments Training This course is designed to teach how to develop, implement and maintain DB2 applications using advanced functions and features, with a view to optimising their performance. The course combines formal classroom tuition with realistic, practical exercises. Objectives On successful completion of this course attendees will be able to: develop DB2 applications with optimised performance attributes maintain and tune applications for optimised performance. describe effective techniques for advanced database management Audience Systems Administrators, Database Administrators and technical personnel who are involved in designing, planning, implementing and/or maintaining DB2 UDB Databases, up to version 9.7. within a Linux, UNIX, or Windows environment. Prerequisites A sound practical understanding of DB2 UDB. Duration 3 days Outline of DB2 UDB: Performance & Tuning in Linux/UNIX/Windows Environments Training 1. DB2 UDB Review Introduction The DB2 Family. 2. Advanced Database Management Advanced database management ( up to DB2 9.7) Tuning The Database Database Configuration File Partitioned Database Advanced Tablespace Management Advanced Table Management Table Partitioning Feature. 3. MQT Generating DDL Set Integrity Deep Compression. 4. DB2 System Catalog Attributes, including changes up to version 9.7 Consolidation of DDL with regard to efficiency and Version 9. Practical Exercise 1. 5. Locking Strategy What resources can be locked How To Set The Locking Locking Configuration Parameters Locking Terms Duration of a lock Commit/Rollback Logging How to find out what Locks are held Savepoints. Practical Exercise 2. 6. Indexing Physical data management Page Indexes Type 1/ 2 Indexes Design Advisor Utilities Runstats Reorg Autonomic Utilities Reorgchk Access Strategy Single Table Access Paths Multi table access path. 7. EXPLAIN Introduction Explain Tables Executing from the CLP Executing from the Command Centre DB2EXPLN Visual Explain 8. Clustering Multidimensional Clustering Range Clustered Tables The Organize by Key Sequence Clause Statistical View. 9. Triggers Stored Procedures Development center Types of stored procedure An external procedure The catalog SPL Stored procedure builder User Defined Functions. 10. Security Security levels Security administrator authority level Label based access contro Security label component Security structure examples. 11. Utilities BACKUP RESTORE LOAD IMPORT/EXPORT Introduction to Automatic Computing Configuration Parameters Collecting Catalog Statistics Health Center Remote Administration DB2 Administration Server. 12. Logs Logs, Snapshot ,Event Monitor, Db2pd And Trace Types of Logging Configuring Database Logging Information DB2DIAG Manual Reading of the Log Snapshot & Event Monitor DB2PD TRACE DB2TRC. We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question
