Local Object Activity Attributes
Use the Local Object Activity attributes to create situations that you can use to monitor the I/O and getpage activity by database.
ASYNC Write Rate The number of asynchronous writes per second during the collection interval. Valid format is a decimal number, with 1 decimal place allowed, in the range 0.0 - 9999.9; for example, 2.1.
Data Sharing Group The name of a data sharing group. It is an alphanumeric text string, with a maximum of 8 characters; for example, TDDB241G.
Database The name of a DB2 database. It is an alphanumeric text string with a maximum of 8 characters; for example, DSNDB06.
DB2 ID The name of a DB2 subsystem.
Getpage Rate The number of getpage requests per second for the database or space name. Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.3.
Getpage RIO Ratio The ratio of getpage requests to read I/Os for the database.
- Number of synchronous reads
- Number of prefetch read I/Os
Valid format is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 1.8.
IDNAME An internal attribute used for navigation, it contains either the Data Sharing Group Name or the DB2ID.
MVS System The MVS System Management Facility (SMF) ID. It is an alphanumeric text string with a maximum of 4 characters; for example SP11.
Number of ASYNC Writes The number of asynchronous writes during the collection interval. Valid value is an integer in the range 0 - 2147483647.
Number of Getpages The number of getpage requests for the database or space name. Valid value is an integer in the range 0 - 2147483647.
Number of Other Writes The number of immediate and format writes. Valid value is an integer in the range 0 - 2147483647.
Number of Prefetch Reads The number of prefetch read I/Os for the database. Valid value is an integer in the range 0 - 2147483647.
Number of SYNC Reads The number of synchronous reads for the database or space name. Valid value is an integer in the range 0 - 2147483647.
Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Other Write Rate The number of immediate and format writes per second. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 0.6.
Percent of Getpage Activity The percentage of total getpage activity that is applicable to the database, space name, or thread. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.6.
Percent of I/O The percentage of total I/O activity that is applicable to the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 100.0; for example, 2.0.
Prefetch Read Rate The number of prefetch read I/Os per second for the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 0.9.
Space Name The name of the selected space for which thread activity has occurred. It is an alphanumeric text string, with a maximum of 8 characters; for example, DSNUCX01.
SYNC Read Rate The number of synchronous reads per second for the database or space name. Valid value is a decimal number, with one decimal place allowed, in the range 0.0 - 9999.9; for example, 2.2.
Time Stamp Represents the end of data collection or the end of an interval, and is the local time where the system is running.