DB2 Version 9.7 for Linux, UNIX, and Windows

SNAP_GET_CONTAINER table function

Note: This table function has been deprecated and replaced by the SNAPCONTAINER administrative view and SNAP_GET_CONTAINER_V91 table function - Retrieve tablespace_container logical data group snapshot information


>>-SNAP_GET_CONTAINER--(--dbname--,--dbpartitionnum--)---------><

The schema is SYSPROC.

The SNAP_GET_CONTAINER table function returns snapshot information from the tablespace_container logical data group.

dbname: An input argument of type VARCHAR(255) that specifies a valid database name in the same instance as the currently connected database when calling this function. Specify a database name that has a directory entry type of either "Indirect" or "Home", as returned by the LIST DATABASE DIRECTORY command. Specify the null value to take the snapshot from the currently connected database.
dbpartitionnum: An input argument of type INTEGER that specifies a valid database partition number. Specify -1 for the current database partition. 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.

Authorization

To access snapshot monitor data, one of the following authorities is required:

EXECUTE privilege on the SNAP_GET_CONTAINER table function
DATAACCESS authority

To access snapshot monitor data, one of the following authorities is required:

SYSMON authority
SYSCTRL authority
SYSMAINT authority
SYSADM authority

The function returns a table as shown in the following section.

Table 1. Information returned by the SNAP_GET_CONTAINER table function
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