The schema is SYSPROC.
The SNAP_GET_CONTAINER table function returns snapshot information from the tablespace_container logical data group.
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 |
TBSP_NAME | VARCHAR(128) | tablespace_name - Table space name |
TBSP_ID | BIGINT | tablespace_id - Table space identification |
CONTAINER_NAME | VARCHAR(256) | container_name - Container name |
CONTAINER_ID | BIGINT | container_id - Container identification |
CONTAINER_TYPE | SMALLINT | container_type - Container type |
TOTAL_PAGES | BIGINT | container_total_pages - Total pages in container |
USABLE_PAGES | BIGINT | container_usable_pages - Usable pages in container |
ACCESSIBLE | SMALLINT | container_accessible - Accessibility of container |
STRIPE_SET | BIGINT | container_stripe_set - Stripe set |
DBPARTITIONNUM | SMALLINT | node_number - Node number |