The MON_GET_TABLESPACE_RANGE table function returns information about table space ranges. A single row is returned for each member.
None
Use the MON_GET_TABLESPACE_RANGE table function in place of the SNAP_GET_TBSP_RANGE table function and SNAPTBSP_RANGE view, which have been deprecated.
SELECT TBSP_ID, SUBSTR(TBSP_NAME, 1, 15) AS TBSP_NAME, RANGE_NUMBER,
RANGE_STRIPE_SET_NUMBER, RANGE_OFFSET, RANGE_MAX_PAGE,
RANGE_MAX_EXTENT, RANGE_START_STRIPE, RANGE_END_STRIPE,
RANGE_ADJUSTMENT, RANGE_NUM_CONTAINER, RANGE_CONTAINER_ID,
DBPARTITIONNUM FROM TABLE(MON_GET_TABLESPACE_RANGE(-2))
ORDER BY DBPARTITIONNUM
The following is sample output
from this query:TBSP_ID TBSP_NAME RANGE_NUMBER RANGE_STRIPE_SET_NUMBER ...
-------- --------------- ------------- ----------------------- ...
0 SYSCATSPACE 0 0 ...
2 USERSPACE1 0 0 ...
3 SYSTOOLSPACE 0 0 ...
2 USERSPACE1 0 0 ...
2 USERSPACE1 0 0 ...
5 record(s) selected.
Output from this query (continued):... RANGE_OFFSET RANGE_MAX_PAGE RANGE_MAX_EXTENT ...
... ------------- -------------------- -------------------- ...
... 0 11515 2878 ...
... 0 479 14 ...
... 0 251 62 ...
... 0 479 14 ...
... 0 479 14 ...
Output
from this query (continued):... RANGE_START_STRIPE RANGE_END_STRIPE RANGE_ADJUSTMENT ...
... -------------------- -------------------- -------------------- ...
... 0 2878 0 ...
... 0 14 0 ...
... 0 62 0 ...
... 0 14 0 ...
... 0 14 0 ...
Output
from this query (continued):... RANGE_NUM_CONTAINER RANGE_CONTAINER_ID DBPARTITIONNUM
... -------------------- -------------------- --------------
... 1 0 0
... 1 0 0
... 1 0 0
... 1 0 1
... 1 0 2
SELECT TBSP_ID, SUBSTR(TBSP_NAME, 1, 15) AS TBSP_NAME, RANGE_NUMBER,
RANGE_STRIPE_SET_NUMBER, RANGE_OFFSET, RANGE_MAX_PAGE, RANGE_MAX_EXTENT,
RANGE_START_STRIPE, RANGE_END_STRIPE, RANGE_ADJUSTMENT,
RANGE_NUM_CONTAINER, RANGE_CONTAINER_ID
FROM TABLE(MON_GET_TABLESPACE_RANGE(-1)) AS T WHERE TBSP_ID = 2
The
following is sample output from this query: TBSP_ID TBSP_NAME RANGE_NUMBER ...
-------- --------------- ------------- ...
2 USERSPACE1 0 ...
1 record(s) selected.
Output from this query (continued):... RANGE_STRIPE_SET_NUMBER RANGE_OFFSET RANGE_MAX_PAGE ...
... ----------------------- ------------- ------------------ ...
... 0 0 3967 ...
Output
from this query (continued):... RANGE_MAX_EXTENT RANGE_START_STRIPE RANGE_END_STRIPE ...
... -------------------- -------------------- -------------------- ...
... 123 0 123 ...
Output
from this query (continued):... RANGE_ADJUSTMENT RANGE_NUM_CONTAINER RANGE_CONTAINER_ID
... -------------------- -------------------- --------------------
... 0 1 0