A unique identifier for the package.

The elapsed time spent executing sections within the package. Value is in milliseconds.

The number of entries that are present within the package listing for a particular unit of work

Indicates whether the number of packages used within the unit of work has exceeded the capacity of the package list. Possible values are YES and NO.

The count of the number of package identifiers included in the package list.

The name of the package that contains the SQL statement.

The schema name of the package associated with an SQL statement.

Number of errors receiving packets since the network adapter started.

Number of packets received since the network adapter started.

Number of errors sending packets since the network adapter started.

Number of packets sent since the network adapter started.

Number of pages that have been allocated to the index.

The number of page reorganizations executed for a table.

The number of times a page related to the object was reclaimed by another member in the Db2® pureScale® instance before its planned release, where the member that reclaimed the page required exclusive access.

The number of times a page related to the object was reclaimed by another member in the Db2 pureScale instance before its planned release, where the member that reclaimed the page required shared access.

The number of times a page accessed in exclusive mode caused the page to be reclaimed from another member. Page reclaims related to internally maintained object space maps are counted separately.

The number of times a page accessed in shared mode caused the page to be reclaimed from another member. Page reclaims related to internally maintained object space maps are counted separately.

The total number of pages read by block I/O into the block area of the buffer pool.

The total number of pages read by vectored I/O into the page area of the buffer pool.

Number of index pages that have been merged.

The number of pages (data, index, and XML) read in from the physical table space containers for regular and large table spaces.

The number of pages (data, index, and XML) physically written to the table space container.

The unique ID of the activity's parent activity within the parent activity's unit of work. If there is no parent activity, the value of this monitor element is NULL.

The unique unit of work identifier within an application handle. The ID of the unit of work in which the activity's parent activity originates. If there is no parent activity, the value is NULL.

Indicates that an event monitor record is only a partial record.

A sequence number uniquely identifying this participant within this deadlock.

The participant number of the application that is holding a lock on the object that this application is waiting to obtain.

The type of lock participant which can be either Requestor or Owner.

The partitioning key for the event monitor tables. This value is chosen so that each event monitor process inserts data into the database partition on which the process is running; that is, insert operations are performed locally on the database partition where the event monitor process is running.

This element is only used in the target SQL tables by write-to-table event monitors in a partitioned database environment or Db2 pureScale environment. This value indicates the number of the member where event monitor data is inserted.

This element contains a count of the total number of SQL statements that the federated server has passed through directly to this data source on behalf of any application since the start of the federated server instance or the last reset of the database monitor counters, whichever is latest.

Reflects peer wait limit configuration (set via the registry variable DB2_HADR_PEER_WAIT_LIMIT). Units are milliseconds.

The EVENT_ID of corresponding UTILPHASESTART.

Time of the corresponding UTILPHASESTART

During extent movement, this monitor element shows the cumulative time taken to do disk I/O on an extent to move it from one position to another. The value is given in milliseconds.

The number of piped sorts that have been accepted.

The number of piped sorts that have been requested.

The total number of times that a requested section was not available for use and had to be loaded into the package cache. This count includes any implicit prepares performed by the system.

 
    1 - (Package Cache Inserts / Package Cache Lookups)

The number of times that the package cache overflowed the bounds of its allocated memory.

The largest size reached by the package cache.

   maximum package cache size / 4096

The hash key value which identifies a query plan for a section.

The number of group buffer pool (GBP) independent column-organized pages found in a local buffer pool by a prefetcher.

The number of times a column-organized page was attempted to be read from the group buffer pool by a prefetcher because the page was invalid in the local buffer pool.

The number of times a Group Buffer Pool (GBP) dependent column-organized page was attempted to be read from the group buffer pool by a prefetcher because the page was either invalid or not present in the local buffer pool.

The number of times a Group Buffer Pool (GBP) dependent column-organized page was read into the local buffer pool by a prefetcher from disk because it was not found in the GBP.

The number of times a data page was present in the local buffer pool when a prefetcher attempted to access it.

The number of asynchronous column-organized read requests by the prefetcher to the operating system.

 pool_async_col_reads / pool_async_col_read_reqs

Indicates the number of column-organized pages which have been asynchronously read by prefetchers from the table space containers (physical) for all types of table spaces.

The number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher might have written dirty pages to disk to make space for the pages being prefetched.

  pool_col_writes - pool_async_col_writes

The number of group buffer pool (GBP) independent data pages found in a local buffer pool by asynchronous EDUs.

The number of times a data page was attempted to be read from the group buffer pool by a prefetcher because the page was invalid in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_data_gbp_l_reads - pool_async_data_gbp_p_reads ) / pool_async_data_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent data page was attempted to be read from the group buffer pool by a prefetcher because the page was either invalid or not present in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_data_gbp_l_reads - pool_async_data_gbp_p_reads ) / pool_async_data_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent data page was read into the local buffer pool by a prefetcher from disk because it was not found in the GBP. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_data_gbp_l_reads - pool_async_data_gbp_p_reads ) / pool_async_data_gbp_l_reads

The number of times a data page was present in the local buffer pool when a prefetcher attempted to access it.

GBP = ( pool_async_data_gbp_l_reads - pool_async_data_gbp_p_reads ) / pool_async_data_gbp_l_reads

The number of asynchronous read requests by the prefetcher to the operating system. These requests are typically large block I/Os of multiple pages.

 pool_async_data_reads / pool_async_data_read_reqs

Indicates the number of data pages which have been asynchronously read by prefetchers from the table space containers (physical) for all types of table spaces.

# of sync data reads = pool_data_p_reads + pool_temp_data_p_reads - pool_async_data_reads

(pool_async_data_reads + pool_async_index_reads)/
(pool_data_p_reads + pool_temp_data_p_reads + pool_index_p_reads + pool_temp_index_p_reads)

The number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

The number of group buffer pool (GBP) independent index pages found in a local buffer pool by asynchronous EDUs.

The number of times an index page was attempted to be read from the group buffer pool by a prefetcher because the page was invalid in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_index_gbp_l_reads - pool_async_index_gbp_p_reads ) / pool_async_index_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent index page was attempted to be read from the group buffer pool by a prefetcher because the page was either invalid or not present in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_index_gbp_l_reads - pool_async_index_gbp_p_reads ) / pool_async_index_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent index page was read into the local buffer pool by a prefetcher from disk because it was not found in the GBP. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_index_gbp_l_reads - pool_async_index_gbp_p_reads ) / pool_async_index_gbp_l_reads

The number of times an index page was present in the local buffer pool when a prefetcher attempted to access it.

GBP = ( pool_async_index_gbp_l_reads - pool_async_index_gbp_p_reads ) / pool_async_index_gbp_l_reads

The number of asynchronous read requests for index pages.

Indicates the number of index pages which have been asynchronously read by prefetchers from the table space containers (physical) for all types of table spaces.

# of sync index reads = pool_index_p_reads + pool_temp_index_p_reads - pool_async_index_reads

(pool_async_index_reads) / (pool_index_p_reads + pool_temp_index_p_reads)

The number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

  pool_index_writes - pool_async_index_writes

Indicates the total amount of time spent reading in data and index pages from the table space containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of table spaces. This value is given in milliseconds.

Cumulative elapsed time for each asynchronous write to complete. This value is reported in milliseconds.

 pool_write_time - pool_async_write_time

 pool_async_write_time
  / (pool_async_data_writes 
    + pool_async_index_writes)

The number of group buffer pool (GBP) independent XML storage object (XDA) pages found in a local buffer pool by asynchronous EDUs.

The number of times a request for a data page for an XML storage object (XDA) was made from the group buffer pool by a prefetcher due to the page being marked invalid in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_xda_gbp_l_reads - pool_async_xda_gbp_p_reads ) / pool_async_xda_gbp_l_reads

The number of times a GBP dependent data page for an XML storage object (XDA) was attempted to be read from the group buffer pool by a prefetcher because the page was either invalid or not present in the local buffer pool. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_xda_gbp_l_reads - pool_async_xda_gbp_p_reads ) / pool_async_xda_gbp_l_reads

The number of times a GBP dependent data page for an XML storage object (XDA) was read into the local buffer pool by a prefetcher from disk because it was not found in the GBP. Outside of a Db2 pureScale environment, this value is null.

GBP = ( pool_async_xda_gbp_l_reads - pool_async_xda_gbp_p_reads ) / pool_async_xda_gbp_l_reads

The number of times a data page for an XML storage object (XDA) was requested by a prefetcher from and found in the local buffer pool.

GBP = ( pool_async_xda_gbp_l_reads - pool_async_xda_gbp_p_reads ) / pool_async_xda_gbp_l_reads

The number of asynchronous read requests for XML storage object (XDA) data.

Indicates the number of XML storage object (XDA) data pages which have been asynchronously read by prefetchers from the table space containers (physical) for all types of table spaces.

 
 pool_xda_p_reads + pool_temp_xda_p_reads - pool_async_xda_reads

The number of times a buffer pool data page for an XML storage object (XDA) was physically written to disk by either an asynchronous page cleaner, or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

The number of group buffer pool (GBP) independent column-organized pages found in a local buffer pool (LBP) by an agent.

The number of times a column-organized page was invalid in the local buffer pool and was read from the group buffer pool instead. Outside of a Db2 pureScale environment, this value is null.

The number of column-organized pages which have been requested from the buffer pool (logical) for regular and large table spaces.

(pool_col_lbp_pages_found - pool_async_col_lbp_pages_found) / pool_col_l_reads

(pool_col_gbp_l_reads - pool_col_gbp_p_reads) / pool_col_gbp_l_reads

Indicates the number of column-organized pages read in from the table space containers (physical) for regular and large table spaces.

(pool_col_lbp_pages_found - pool_async_col_lbp_pages_found) / pool_col_l_reads

(pool_col_gbp_l_reads - pool_col_gbp_p_reads) / pool_col_gbp_l_reads

Indicates the number of column-organized pages which have been synchronously read by agents from the buffer pool (logical) for regular and large table spaces.

(pool_col_lbp_pages_found - pool_async_col_lbp_pages_found) / pool_col_l_reads

Indicates the number of column-organized pages which have been synchronously read by agents and asynchronously read by prefetchers from the local buffer pool (logical) for regular and large table spaces.

(pool_col_lbp_pages_found - pool_async_col_lbp_pages_found) / pool_col_l_reads

(pool_col_gbp_l_reads - pool_col_gbp_p_reads) / pool_col_gbp_l_reads

Indicates the number of column-organized pages which have been synchronously read by agents and asynchronously read by prefetchers from the table space containers (physical) for regular and large table spaces.

The number of times a buffer pool column-organized page was physically written to disk.

The internally configured size of a memory pool in the database system. The value is in bytes.

The current size of a memory pool. The value is given in bytes.

The number of group buffer pool (GBP) independent data pages found in a local buffer pool (LBP) by an agent. Outside of a Db2 pureScale environment, this value is null.

The number of times a data page was invalid in the local buffer pool and was read from the group buffer pool instead. Outside of a Db2 pureScale environment, this value is null.

(pool_data_lbp_pages_found - pool_async_data_lbp_pages_found) / pool_data_l_reads

(pool_data_gbp_l_reads - pool_data_gbp_p_reads) / pool_data_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent data page was attempted to be read from the group buffer pool because the page was either invalid or not present in the Local Buffer Pool (LBP). Outside of a Db2 pureScale environment, this value is null.

(pool_data_lbp_pages_found - pool_async_data_lbp_pages_found) / pool_data_l_reads

(pool_data_gbp_l_reads - pool_data_gbp_p_reads) / pool_data_gbp_l_reads

The number of times a Group Buffer Pool (GBP) dependent data page was read into the local buffer pool from disk because it was not found in the GBP. Outside of a Db2 pureScale environment, this value is null.

(pool_data_lbp_pages_found - pool_async_data_lbp_pages_found) / pool_data_l_reads

(pool_data_gbp_l_reads - pool_data_gbp_p_reads) / pool_data_gbp_l_reads

Indicates the number of data pages which have been synchronously read by agents and asynchronously read by prefetchers from the local buffer pool (logical) for regular and large table spaces.

(pool_data_lbp_pages_found - pool_async_data_lbp_pages_found) / pool_data_l_reads

(pool_data_gbp_l_reads - pool_data_gbp_p_reads) / pool_data_gbp_l_reads

Indicates the number of data pages which have been synchronously read by agents from the buffer pool (logical) for regular and large table spaces.

((pool_data_lbp_pages_found
- pool_async_data_lbp_pages_found) / (pool_data_l_reads + pool_temp_data_l_reads))
× 100 

Indicates the number of data pages which have been synchronously read by agents and asynchronously read by prefetchers from the table space containers (physical) for regular and large table spaces.

(pool_async_data_reads + pool_async_index_reads)/
(pool_data_p_reads + pool_temp_data_p_reads + pool_index_p_reads + pool_temp_index_p_reads)

The number of times a buffer pool data page was physically written to disk.

The number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database.

        pool_drty_pg_steal_clns
     / (pool_drty_pg_steal_clns
      + pool_drty_pg_thrsh_clns
      + pool_lsn_gap_clns)

The number of times a page cleaner was invoked because a buffer pool had reached the dirty page threshold criterion for the database.

The number of times an attempt to queue a column-organized prefetch request was made but failed. One possible reason is the prefetch queue is full.

The number of times an attempt to queue a data prefetch request was made but failed. One possible reason is the prefetch queue is full.

   1 - 
    (
    POOL_FAILED_ASYNC_DATA_REQS + 
    POOL_FAILED_ASYNC_INDEX_REQS + 
    POOL_FAILED_ASYNC_XDA_REQS + 
    POOL_FAILED_ASYNC_COL_REQS + 
    POOL_FAILED_ASYNC_TEMP_DATA_REQS + 
    POOL_FAILED_ASYNC_TEMP_INDEX_REQS + 
    POOL_FAILED_ASYNC_TEMP_XDA_REQS +
    POOL_FAILED_ASYNC_TEMP_COL_REQS 
    ) 
    ÷ 
    (
      (
      POOL_FAILED_ASYNC_DATA_REQS + 
      POOL_FAILED_ASYNC_INDEX_REQS + 
      POOL_FAILED_ASYNC_XDA_REQS + 
      POOL_FAILED_ASYNC_COL_REQS + 
      POOL_FAILED_ASYNC_TEMP_DATA_REQS + 
      POOL_FAILED_ASYNC_TEMP_INDEX_REQS + 
      POOL_FAILED_ASYNC_TEMP_XDA_REQS +
      POOL_FAILED_ASYNC_TEMP_COL_REQS 
      )
    + 
      (
      POOL_QUEUED_ASYNC_DATA_REQS + 
      POOL_QUEUED_ASYNC_INDEX_REQS + 
      POOL_QUEUED_ASYNC_XDA_REQS + 
      POOL_QUEUED_ASYNC_COL_REQS + 
      POOL_QUEUED_ASYNC_TEMP_DATA_REQS + 
      POOL_QUEUED_ASYNC_TEMP_INDEX_REQS + 
      POOL_QUEUED_ASYNC_TEMP_XDA_REQS +
      POOL_QUEUED_ASYNC_TEMP_COL_REQS 
      )
    ) × 100

The number of times an attempt to queue an index prefetch request was made but failed. One possible reason is the prefetch queue is full and a request could not be obtained from the free list.

   1 - 
    (
    POOL_FAILED_ASYNC_DATA_REQS + 
    POOL_FAILED_ASYNC_INDEX_REQS + 
    POOL_FAILED_ASYNC_XDA_REQS + 
    POOL_FAILED_ASYNC_COL_REQS + 
    POOL_FAILED_ASYNC_TEMP_DATA_REQS + 
    POOL_FAILED_ASYNC_TEMP_INDEX_REQS + 
    POOL_FAILED_ASYNC_TEMP_XDA_REQS +
    POOL_FAILED_ASYNC_TEMP_COL_REQS 
    ) 
    ÷ 
    (
      (
      POOL_FAILED_ASYNC_DATA_REQS + 
      POOL_FAILED_ASYNC_INDEX_REQS + 
      POOL_FAILED_ASYNC_XDA_REQS + 
      POOL_FAILED_ASYNC_COL_REQS + 
      POOL_FAILED_ASYNC_TEMP_DATA_REQS + 
      POOL_FAILED_ASYNC_TEMP_INDEX_REQS + 
      POOL_FAILED_ASYNC_TEMP_XDA_REQS +
      POOL_FAILED_ASYNC_TEMP_COL_REQS 
      )
    + 
      (
      POOL_QUEUED_ASYNC_DATA_REQS + 
      POOL_QUEUED_ASYNC_INDEX_REQS + 
      POOL_QUEUED_ASYNC_XDA_REQS + 
      POOL_QUEUED_ASYNC_COL_REQS + 
      POOL_QUEUED_ASYNC_TEMP_DATA_REQS + 
      POOL_QUEUED_ASYNC_TEMP_INDEX_REQS + 
      POOL_QUEUED_ASYNC_TEMP_XDA_REQS +
      POOL_QUEUED_ASYNC_TEMP_COL_REQS 
      )
    ) × 100

The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed. One possible reason is the prefetch queue is full and a request could not be obtained from the free list.