DB2 10.5 for Linux, UNIX, and WindowsF
failed_sql_stmts - Failed Statement Operations monitor element
The number of SQL statements that were attempted, but failed.
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | dbase | Basic |
| Database | dbase_remote | Basic |
| Application | appl | Basic |
| Application | appl_remote | Basic |
| DCS Database | dcs_dbase | Basic |
| DCS Application | dcs_appl | Basic |
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Connection | event_conn | Always collected |
| Database | event_db | Always collected |
| Statistics | event_scmetrics | REQUEST METRICS BASE |
| Statistics | event_wlmmetrics | REQUEST METRICS BASE |
| Unit of work | uow_metrics | REQUEST METRICS BASE |
- Usage
- You can use this element to calculate the total number of successful
SQL statements at the database or application level:
dynamic_sql_stmts + static_sql_stmts - failed_sql_stmts = throughput during monitoring periodThis count includes all SQL statements that received a negative SQLCODE.
This element may also help you in determining reasons for poor performance, since failed statements mean time wasted by the database manager and as a result, lower throughput for the database.
fcm_congested_sends - FCM congested sends monitor element
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
fcm_congestion_time - FCM congestion time monitor element
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
fcm_message_recv_volume - FCM message received volume monitor element
The amount of data received for internal requests (such as RPCs) distributed by the FCM communications layer. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine how much of the data volume being sent through the FCM subsystem is for request or reply message traffic as opposed to actual table data.
fcm_message_recv_wait_time - FCM message received wait time monitor element
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
This element can be used to determine how much time was spent on a given partition waiting for requests to be processed on other partitions in a multi-partition instance.
fcm_message_recv_waits_total - Number of times spent waiting for FCM reply message monitor element
The total number of times that the DB2 system spent waiting for an FCM reply message containing the results of a previously sent FCM request message.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_message_recvs_total - Total FCM message receives monitor element
The total number of buffers received as part of an FCM reply message containing the results of a previously sent FCM request message.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
| Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
Usage
This element can be used to determine both the average volume per FCM message received, as well as the average time spent waiting for a single FCM message to be received.
fcm_message_send_volume - FCM message send volume monitor element
Amount of data volume sent via internal FCM requests. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
| Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
Usage
Use this element to determine how much of the data volume being sent through the FCM subsystem is used for sending request and reply message traffic, as opposed to sending actual table data.
fcm_message_send_wait_time - FCM message send wait time monitor element
The time spent blocking on an FCM message send. The value is given in milliseconds. This monitor element reflects the time spent blocking for FCM buffers to be flushed from an FCM channel when distributing internal requests on the database system.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
| Unit of work |
Reported in the system_metrics document. |
REQUEST METRICS BASE |
Usage
Use this element to determine how much time agents are spending waiting to send an FCM request message through the FCM subsystem. Depending on how busy the FCM daemons are, an agent may need to wait when attempting to send messages.
fcm_message_send_waits_total - Number of times spent blocking on an FCM message send monitor element
The total number of times that the DB2 system spent blocking on an FCM message send.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_message_sends_total - Total FCM message sends monitor element
The total number of buffers distributed as part of internal requests using the FCM communications mechanism.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine both the average amount of data sent per FCM request message, as well as the average amount of time waited per FCM message.
fcm_num_congestion_timeouts - FCM congestion timeouts monitor element
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
fcm_num_conn_lost - FCM lost connections monitor element
The number of times that an FCM network connection to a remote member was unexpectedly disconnected.
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
fcm_num_conn_timeouts - FCM connection timeouts monitor element
The number of times outs out when attempting to establish an FCM network connection with a remote member.
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections | Always collected |
fcm_recv_volume - FCM received volume monitor element
The total amount of data received via the FCM communications layer. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Indicates the total volume of data received on this partition using FCM, including both message traffic and table queue data.
fcm_recv_wait_time - FCM received wait time monitor element
The total time spent waiting to receive data through FCM. The value is given in milliseconds.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine the total time spent waiting to receive data through FCM on this database partition. This includes both data from replies to request messages as well as table queue data.
fcm_recv_waits_total - Number of times spent waiting to receive data through FCM monitor element
The total number of times that the DB2 system spent waiting to receive data through FCM.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_recvs_total - FCM receives total monitor element
Total number of buffers received for internal requests using the FCM communications mechanism. The fcm_recvs_total monitor element value is the sum of the values for the fcm_message_recvs_total and fcm_tq_recvs_total monitor elements.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element together with the fcm_recv_wait_time monitor element to determine the average wait time per FCM receive operation as well as the average volume returned from an FCM receive operation.
fcm_send_volume - FCM send volume monitor element
The total amount of data distributed by the FCM communications layer. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this monitor element to determine the total volume of data sent using FCM, including both message traffic and table queue data.
fcm_send_wait_time - FCM send wait time monitor element
The time spent blocking on an FCM send operation. This includes time spent waiting for buffers for internal requests to be flushed and time spent waiting for window count acknowledgements when sending data over table queues. The value is given in milliseconds.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine the total time spent waiting to send data through FCM. This includes both request messages and table queue data.
fcm_send_waits_total - Number of times spent blocking on an FCM send operation monitor element
The total number of times that the DB2 system spent blocking on an FCM send operation.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_sends_total - FCM sends total monitor element
The total number of buffers sent using the internal FCM communications layer.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine the average wait time per FCM receive operation as well as the average volume returned from an FCM receive operation.
fcm_tq_recv_volume - FCM table queue received volume monitor element
The amount of data received on table queues by the FCM communications layer. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this monitor element to determine the total volume of data received through table queues.
fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
The time spent waiting to receive the next buffer from a table queue. The value is given in milliseconds.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element to determine how much time agents are spending waiting to receive data on table queues.
fcm_tq_recv_waits_total - Number of times spent waiting to receive the next buffer monitor element
The total number of times that the DB2 system spent waiting to receive the next buffer from a table queue.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_tq_recvs_total - FCM table queue receives total monitor element
The total number of buffers received from table queues using the internal FCM communications mechanism.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element in conjunction with fcm_tq_recv_volume and fcm_tq_recv_wait_time to determine the average wait time and volume per table queue buffer received.
fcm_tq_send_volume - FCM table queue send volume monitor element
The amount of data sent over table queues by the FCM communications layer. This value is reported in bytes.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this monitor element to determine the total volume of data sent over FCM through table queue buffer sends.
fcm_tq_send_wait_time - FCM table queue send wait time monitor element
The time spent waiting to send the next buffer through a table queue. This reflects the time spent waiting for window count acknowledgements from the receiver end of the table queue. The value is given in milliseconds.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this monitor element to determine how much time is being spent waiting to send a data buffer over FCM through a table queue.
fcm_tq_send_waits_total - Number of times spent waiting to send the next buffer monitor element
The total number of times that the DB2 system spent waiting to send the next buffer through a table queue.
| Event type | Logical data grouping | Monitor switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
fcm_tq_sends_total - FCM table queue send total monitor element
The total number of buffers containing table queue data sent using the internal FCM communications mechanism.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Activities | event_activity (reported in the details_xml document) | ACTIVITY METRICS BASE |
| Activities | event_activitymetrics | ACTIVITY METRICS BASE |
| Statistics | event_scstats (reported in the metrics document) | REQUEST METRICS BASE |
| Statistics | event_wlstats (reported in the metrics document) | REQUEST METRICS BASE |
| Unit of work | Reported in the system_metrics document. | REQUEST METRICS BASE |
| Package cache | Reported in the activity_metrics document. | ACTIVITY METRICS BASE |
Usage
Use this element in conjunction with fcm_tq_send_volume and fcm_tq_send_wait_time monitor elements to determine the average data volume and time waited for buffer sent using a table queue.
fetch_count - Number of Successful Fetches monitor element
The number of successful physical fetches or the number of attempted physical fetches, depending on the snapshot monitoring level.
- For the stmt and dynsql snapshot monitoring levels and the statement event type: the number of successful fetches performed on a specific cursor.
- For the dcs_stmt snapshot monitoring level: The number of attempted physical fetches during a statement's execution (regardless of how many rows were fetched by the application). In this situation, fetch_count represents the number of times the server needed to send a reply data back to the gateway while processing a statement.
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Application | stmt | Statement |
| DCS Statement | dcs_stmt | Statement |
| Dynamic SQL | dynsql | Statement |
For Dynamic SQL snapshot monitoring, this counter can be reset.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Statements | event_stmt | Always collected |
Usage
You can use this element to gain insight into the current level of activity within the database manager.
For performance reasons, a statement event monitor does not generate a statement event record for every FETCH statement. A record event is only generated when a FETCH returns a non-zero SQLCODE.
files_closed - Database files closed monitor element
The total number of database files closed.
| Table Function | Monitor Element Collection Command and Level |
|---|---|
| MON_GET_BUFFERPOOL table function - Get buffer pool metrics | DATA OBJECT METRICS BASE |
| MON_GET_DATABASE table function - Get database level information | DATA OBJECT METRICS BASE |
| MON_GET_DATABASE_DETAILS table function - Get database information metrics | DATA OBJECT METRICS BASE |
| MON_GET_TABLESPACE table function - Get table space metrics | DATA OBJECT METRICS BASE |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | dbase | Buffer Pool |
| Table Space | tablespace | Buffer Pool |
| Buffer Pool | bufferpool | Buffer Pool |
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | event_db | Always collected |
| Tablespaces | event_tablespace | Always collected |
Usage
The database manager opens files for reading and writing into and out of the buffer pool. The maximum number of database files open by an application at any time is controlled by the maxfilop configuration parameter. If the maximum is reached, one file will be closed before the new file is opened. Note that the actual number of files opened may not equal the number of files closed.
You can use this element to help you determine the best value for the maxfilop configuration parameter.
first_active_log - First Active Log File Number monitor element
The file number of the first active log file.
- Element identifier
- first_active_log
- Element type
- information
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_TRANSACTION_LOG table function - Get log information | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | detail_log | Basic |
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | event_db | Always collected |
- Usage
- Use this element in conjunction with
the last_active_log and current_active_log elements
to determine
the range of active log files. Knowing the range of active log files
helps
you determine the disk space required for log files.
You can also use this element to determine which log files have data to help you identify log files needed for split mirror support.
first_overflow_time - Time of First Event Overflow monitor element
The date and time of the first overflow recorded by this overflow record.
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Overflow Record | event_overflow | - |
- Usage
- Use this element with last_over_flow time to calculate the elapsed time for which the overflow record was generated.
fs_caching - File system caching monitor element
Indicates whether file system caching is intended for a table space.
- 0: File system caching was specified. Direct I/O is not requested for tables space files, usually resulting in caching of I/O in the operating system file cache.
- 1: File system caching was not specified. Direct I/O is requested where possible for table space files, usually resulting in bypassing the file system cache. Exceptions are LOB and long field objects in SMS table spaces, where direct I/O is not requested as to allow operating system-level caching of these objects.
- 2 (Default value): Direct I/O usage is determined at runtime based on operating system preferences, file system preferences, table space type, and object type. See File system caching configurations
| Table Function | Monitor Element Collection Command and Level |
|---|---|
| MON_GET_TABLESPACE table function - Get table space metrics | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Table space | tablespace | Basic |
| Event Type | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Tablespaces | event_tablespace | - |
fs_id - Unique file system identification number monitor element
This element shows the unique identification number provided by the operating system for a file system pointed to by a storage path or container.
| Table Function | Monitor Element Collection Level |
|---|---|
| ADMIN_GET_STORAGE_PATHS table function - Get storage path information for storage groups | Always collected |
| MON_GET_CONTAINER table function - Get table space container metrics | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | db_sto_path_info | Buffer Pool |
Usage
- db_storage_path
- sto_path_free_size
- fs_used_size
- fs_total_size
fs_total_size - Total size of a file system monitor element
This element shows the capacity (in bytes) of a file system pointed to by a storage path or container.
| Table Function | Monitor Element Collection Level |
|---|---|
| ADMIN_GET_STORAGE_PATHS table function - Get storage path information for storage groups | Always collected |
| MON_GET_CONTAINER table function - Get table space container metrics | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | db_sto_path_info | Buffer Pool |
Usage
- db_storage_path
- sto_path_free_size
- fs_used_size
- fs_id
fs_used_size - Amount of space used on a file system monitor element
This element shows the amount of space (in bytes) already used on a file system pointed to by a storage path or container.
| Table Function | Monitor Element Collection Level |
|---|---|
| ADMIN_GET_STORAGE_PATHS table function - Get storage path information for storage groups | Always collected |
| MON_GET_CONTAINER table function - Get table space container metrics | Always collected |
| Snapshot Level | Logical Data Grouping | Monitor Switch |
|---|---|---|
| Database | db_sto_path_info | Buffer Pool |
Usage
- db_storage_path
- sto_path_free_size
- fs_total_size
- fs_id