DB2 Monitor complements Agileload by extending the range of data collection and monitoring options available, by adding the ability to monitor and record performance data from DB2 components of target systems. It enables the creation of Collectors that can include a number of monitoring and data collection options. Results data generated by DB2 Monitor Collectors can be displayed and analyzed to help to identify bottlenecks that occur on target DB2 Systems during Job-runs.
Only DB2 9.1, 9.5 and 9.7 can be monitored
A DB2 9.1/9.5/9.7 Client and ODBC driver must be installed in order to make Agileload DB2 Monitor work.
Switches must be set to 'ON' for all : Lock,
Sort, Bufferpool, Statement, Table,
Timestamp and UOW. It must also be set to 'ON'
for Health monitor.
In order to set these values to 'ON', run DB2 Control Center.
On the instance node where your database is, open the 'configure parameters' dialog:
Under the Monitor category, verify that all monitor values are set to 'ON'. If not, set the values to 'ON' with option dynamic checked.
You must use a login with SYSMON authority.
With the exception of
SYSIBMADM.AUTHORIZATIONIDS, SYSIBMADM.OBJECTOWNERS, and
SYSIBMADM.PRIVILEGES, you also need EXECUTE privilege on the
underlying administrative table function. The underlying
administrative table function is listed in the authorization
section of the administrative view. This can be validated with the
SELECT GRANTEE, GRANTEETYPE
WHERE SCHEMA = 'SYSPROC' AND SPECIFICNAME = '<routine_name>' AND
EXECUTEAUTH <> 'N'
where <routine_name> is the name of the underlying administrative table function as :
Copyright © AgileLoad. All rights reserved.