14.4. Monitoring and Tuning the DB2 Agents
It is crucial to make sure that the number of agents you configure in the database manager is enough to service your applications. If an agent is needed but is not available, the application will get an error. If it is a new database and you are not sure what its workload is going to be, use the database Monitoring tools to get a sense of what the workload is like.
The database manager Snapshot Monitor will give you the most information on DB2 agent usage (use the GET SNAPSHOT FOR DBM command). Figure 14.6 shows a snippet of the database manager snapshot output.
Figure 14.6. Example of database manager snapshot output
Database Manager Snapshot Node type = Enterprise Server Edition with local and remote ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
