Returns activity information from a table space snapshot.
The schema is SYSPROC.
If the null value is specified, -1 is set implicitly.
If both parameters are set to NULL, the snapshot is taken only if a file has not previously been created by the SNAPSHOT_FILEW stored procedure for the corresponding snapshot API request type.
The function returns a table as shown in the following section.
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
POOL_DATA_L_READS | BIGINT | pool_data_l_reads - Buffer pool data logical reads |
POOL_DATA_P_READS | BIGINT | pool_data_p_reads - Buffer pool data physical reads |
POOL_ASYNC_DATA_READS | BIGINT | pool_async_data_reads - Buffer pool asynchronous data reads |
POOL_DATA_WRITES | BIGINT | pool_data_writes - Buffer pool data writes |
POOL_ASYNC_DATA_WRITES | BIGINT | pool_async_data_writes - Buffer pool asynchronous data writes |
POOL_INDEX_L_READS | BIGINT | pool_index_l_reads - Buffer pool index logical reads |
POOL_INDEX_P_READS | BIGINT | pool_index_p_reads - Buffer pool index physical reads |
POOL_INDEX_WRITES | BIGINT | pool_index_writes - Buffer pool index writes |
POOL_ASYNC_INDEX_WRITES | BIGINT | pool_async_index_writes - Buffer pool asynchronous index writes |
POOL_READ_TIME | BIGINT | pool_read_time - Total buffer pool physical read time |
POOL_WRITE_TIME | BIGINT | pool_write_time - Total buffer pool physical write time |
POOL_ASYNC_READ_TIME | BIGINT | pool_async_read_time - Buffer pool asynchronous read time |
POOL_ASYNC_WRITE_TIME | BIGINT | pool_async_write_time - Buffer pool asynchronous write time |
POOL_ASYNC_DATA_ |
BIGINT | pool_async_data_read_reqs - Buffer pool asynchronous read requests |
DIRECT_READS | BIGINT | direct_reads - Direct reads from database |
DIRECT_WRITES | BIGINT | direct_writes - Direct writes to database |
DIRECT_READ_REQS | BIGINT | direct_read_reqs - Direct read requests |
DIRECT_WRITE_REQS | BIGINT | direct_write_reqs - Direct write requests |
DIRECT_READ_TIME | BIGINT | direct_read_time - Direct read time |
DIRECT_WRITE_TIME | BIGINT | direct_write_time - Direct write time |
UNREAD_PREFETCH_PAGES | BIGINT | unread_prefetch_pages - Unread prefetch pages |
POOL_ASYNC_INDEX_READS | BIGINT | pool_async_index_reads - Buffer pool asynchronous index reads |
POOL_DATA_TO_ESTORE | BIGINT | The pool_data_to_estore ESTORE monitor element is discontinued. A NULL value is returned for the discontinued monitor element. |
POOL_INDEX_TO_ESTORE | BIGINT | The pool_index_to_estore ESTORE monitor element is discontinued. A NULL value is returned for the discontinued monitor element. |
POOL_INDEX_FROM_ESTORE | BIGINT | The pool_index_from_estore ESTORE monitor element is discontinued. A NULL value is returned for the discontinued monitor element. |
POOL_DATA_FROM_ESTORE | BIGINT | The pool_data_from_estore ESTORE monitor element is discontinued. A NULL value is returned for the discontinued monitor element. |
FILES_CLOSED | BIGINT | files_closed - Database files closed |
TABLESPACE_NAME | VARCHAR(128) | tablespace_name - Table space name |