DB2 SAP Performance Monitoring and Tuning (SAP Perf)
This workshop is intended for experienced SAP Basis Administrators as well as DB2 database administrators that want to get an insight into DB2 LUW performance monitoring and tuning in SAP environments.
This bootcamp will highlight the following:
Introduction of basic DB2 performance concepts like database configuration, memory tuning, table space management
Performance monitoring tools for DB2 (db2pd, snapshot), SAP (DBA Cockpit)
How to perform a basic system health check (introduction of major KPIs in regards of database performance and health)
Get the complete picture: OS, Storage, Backup
Introduction to the DB2 Optimizer and the DB2 explain facility (using db2exfmt as well as the DBA Cockpit)
How to influence the DB2 optimizer by using RUNSTATS, REORG, guidelines and statistical views
Database tuning a SAP BW environment
Problem analysis - how to identify and solve issues
The material is presented at a technical level assuming a working knowledge of DB2 and SAP basis.
Intermediate knowledge of DB2 and/or prior attendance of the DB2 LUW Administration for SAP work shop is required.
No events scheduled at this time.
There is no charge to attend.