This chapter will teach you how to monitor Db2 instances, databases, objects, and workloads using monitor table functions and administrative views. You will be able to troubleshoot instance, database, and application-related issues using the Db2 problem determination (db2pd) and Db2 text-based monitoring (dsmtop) tool commands. You will also learn how to utilize the event monitors and explain facilities within Db2.
After the completion of this chapter, you will be able to demonstrate the ability to:
- Use the monitoring table functions and administrative views to collect the activity data and analyze it in an ESE, BLU Acceleration, and pureScale database environment
- Create and activate event monitors and analyze event monitor information
- Use the explain facility to capture and analyze comprehensive explaination information
- Use the MONREPORT module to generate...