A DB2 administration tool that provides a set of predefined reports to assist a database administrator in monitoring application performance and concurrency, resource consumption, and SQL or XQuery statement usage of a database or database partition. The tool also provides recommendations to help a database administrator to diagnose the cause of database performance problems and to tune queries for optimal use of database resources.