SNAP_GET_CONTAINER_V91 returns table space snapshot information from the tablespace_container logical data group.
Refer to Table 1 for a complete list of information that can be returned.
>>-SNAP_GET_CONTAINER_V91--(--dbname--+------------------+--)-->< '-, dbpartitionnum-'
The schema is SYSPROC.
If both dbname and dbpartitionnum are set to NULL, an attempt is made to read data from the file created by SNAP_WRITE_FILE procedure. Note that this file could have been created at any time, which means that the data might not be current. If a file with the corresponding snapshot API request type does not exist, then the SNAP_GET_CONTAINER_V91 table function takes a snapshot for the currently connected database and database partition number.
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
SELECT SNAPSHOT_TIMESTAMP, TBSP_NAME, TBSP_ID, CONTAINER_NAME,
CONTAINER_ID, CONTAINER_TYPE, ACCESSIBLE
FROM TABLE(SNAP_GET_CONTAINER_V91('',-1)) AS T
SNAPSHOT_TIMESTAMP TBSP_NAME TBSP_ID ...
-------------------------- -------------------- ------- ...
2005-04-25-14.42.10.899253 SYSCATSPACE 0 ...
2005-04-25-14.42.10.899253 TEMPSPACE1 1 ...
2005-04-25-14.42.10.899253 USERSPACE1 2 ...
2005-04-25-14.42.10.899253 SYSTOOLSPACE 3 ...
2005-04-25-14.42.10.899253 MYTEMP 4 ...
2005-04-25-14.42.10.899253 WHATSNEWTEMPSPACE 5 ...
... CONTAINER_NAME CONTAINER_ID ...
... ---------------------------------------- ------------ ...
... D:\DB2\NODE0000\SQL00002\SQLT0000.0 0 ...
... D:\DB2\NODE0000\SQL00002\SQLT0001.0 0 ...
... D:\DB2\NODE0000\SQL00002\SQLT0002.0 0 ...
... D:\DB2\NODE0000\SQL00002\SYSTOOLSPACE 0 ...
... D:\DB2\NODE0000\SQL003 0 ...
... d:\DGTTsWhatsNewContainer 0 ...
... CONTAINER_TYPE ACCESSIBLE
... -------------- ----------
... CONT_PATH 1
... CONT_PATH 1
... CONT_PATH 1
... CONT_PATH 1
... CONT_PATH 1
... CONT_PATH 1
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | The date and time that the snapshot was taken. |
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 | VARCHAR(16) | container_type - Container type . This
is a text identifier based on the defines in sqlutil.h and is one of:
|
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 | dbpartitionnum - Database partition number monitor element |
FS_ID | VARCHAR(22) | fs_id - Unique file system identification number |
FS_TOTAL_SIZE | BIGINT | fs_total_size - Total size of a file system |
FS_USED_SIZE | BIGINT | fs_used_size - Amount of space used on a file system |