The schema is SYSPROC.
The SNAP_GET_TAB table function returns snapshot information from the table logical data group.
If the null value is specified, -1 is set implicitly.
If both parameters are set to NULL, the snapshot will be 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 |
TABSCHEMA | VARCHAR(128) | table_schema - Table schema name |
TABNAME | VARCHAR(128) | table_name - Table name |
TAB_FILE_ID | BIGINT | table_file_id - Table file identification |
TAB_TYPE | BIGINT | table_type - Table type |
DATA_OBJECT_PAGES | BIGINT | data_object_pages - Data object pages |
INDEX_OBJECT_PAGES | BIGINT | index_object_pages - Index object pages |
LOB_OBJECT_PAGES | BIGINT | lob_object_pages - LOB object pages |
LONG_OBJECT_PAGES | BIGINT | long_object_pages - Long object pages |
ROWS_READ | BIGINT | rows_read - Rows read |
ROWS_WRITTEN | BIGINT | rows_written - Rows written |
OVERFLOW_ACCESSES | BIGINT | overflow_accesses - Accesses to overflowed records |
PAGE_REORGS | BIGINT | page_reorgs - Page reorganizations |
DBPARTITIONNUM | SMALLINT | node_number - Node number |