Evaluating Db2 system performance using system assessments
Evaluating Db2 system performance and health is a key aspect of using IBM® Z Database Assistant.
Before you begin
About this task
Db2 applies rules and domain expertise to evaluate Db2 for system anomalies and then displays them in priority order and provides recommended actions for you to take.
After you configure IBM Z Database Assistant for Db2 system assessments, you can begin monitoring for exception situations and take action on the provided recommendations.
Procedure
To view assessments and assessment statuses:
- From the Manage connections page, you can see the status of the last Db2 system assessment at the bottom of each connection tile.
- From the Global overview page, click the connection for which you want to see the Db2 system assessment data.
- Click the System assessment tab.
Results
The status of the evaluated
subsystems is indicated by the color of the icons in the subsystem column:
- Red icon - indicates that there are critical exceptions to be reviewed.
- Yellow icon - indicates that there are exceptions for which there are highly recommended actions to be taken.
- Blue icon - indicates that there are exceptions for which there are nice-to-address recommendations.
- No icon - indicates that there are no exceptions.
On-demand assessments show "userid through Assessment on Demand" in the Started by column.
What to do next
- Evaluating exception details for a system assessment in a table view
- Evaluating a system assessment's exception details in a tree view
You can also View the assessment workload metrics to understand your Db2 system workload.