DB2 Workload Manager for Linux, UNIX, and Windows, 382 Pages

0.0

DB2 Workload Manager (WLM) introduces a significant evolution in the capabilities available to database administrators for controlling and monitoring executing work within DB2. Thisnew WLM technology is directly incorporated into the DB2 engine infrastructure to allow handling higher volumes with minimal overhead. It is also enabled for tighter integration with external workload management products, such as those provided by AIX WLM. This paper IBM Redbooks publication discusses the features and functions of DB2 Workload Manager for Linux, UNIX, and Windows. It describes DB2 WLM architecture, components, and WLM-specific SQL statements. It demonstrates installation, WLM methodology for customizing the DB2 WLM environment, new workload monitoring table functions, event monitors, and stored procedures. It provides examples and scenarios using DB2 WLM to manage database activities in DSS and OLTP mixed database systems, so you learn about these advanced workload management capabilities and see how they can be used to explicitly allocate CPU priority, detect and prevent "runaway" queries, and closely monitor database activity in many different ways. Using Data Warehouse Edition Design Studio and DB2 Performance Expert with DB2 WLM is covered. Lastly, the primary differences between Workload Manager and Query Patroller are explained, along with how they interact in DB2 9.5. Table of Contents Chapter 1. Introduction Chapter 2. Workload Manager architecture and features Chapter 3. Customizing the WLM execution environments Chapter 4. Monitoring DB2 workload management information Chapter 5. WLM sample scenarios -mMixed OLTP and DSS environment Chapter 6. AIX Workload Manager considerations Chapter 7. WLM sample scenarios - other usage Chapter 8. DWE Design Studio and DB2 WLM Chapter 9. DB2 Workload Manager and DB2 Performance Expert Chapter 10. Administering a DB2 workload management environment Chapter 11. Query Patroller and DB2 Governor

0.0

s Whei-Jen Chen is a Project Leader at the International Technical Support Organization, San Jose Center. She has extensive experience in application development, database design and modeling, and DB2 system administration. Whei-Jen is an IBM Certified Solutions Expert in Database Administration and Application Development, as well as an IBM Certified IT Specialist. Bill Comeau is the technical manager for the WLM development team based in Toronto. He has worked for IBM for 17 years, including seven years of developing workload management solutions for DB2 LUW. In addition, Bill holds an Honours degree in Computing Science from Dalhousie University in Halifax, Nova Scotia. Tomoko Ichikawa is an IT Specialist with IBM Systems Engineering Co., Ltd. in Japan. She has worked in DB2 technical support for four years. She has planned, developed, and delivered transition workshops of DB2 UDB V8.2, V8.2.2, and V9.1 for IBM personnel in Japan. Tomoko's areas of expertise include application development, database performance and monitoring, and problem determination in three-tier environment (DB2 for LUW and WebSphere Application Server). S. Sadish Kumar is a Senior DB2 Database Administrator in IBM India. He holds a Masters degree in Computer Science and has more than 12 years of IT experience. During his nine years with IBM, his areas of expertise have included administration, capacity planning, performance monitoring and tuning, problem determination, and database recovery with DB2 ESE on AIX, Linux, and Windows platforms. Sadish was part of the DB2 World Trade Support level 2 Engine and Application Support team in Toronto for a year and a half, supporting customers on Intel and UNIX platforms. He has been working as a Senior DB2 DBA on systems and applications for leading financial companies in the USA on assignment from IBM India. He has co-authored the IBM Redbooks publication DB2 UDB V7.1 Performance Tuning Guide.