COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
TBS_ID |
✔ |
id: Tablespace ID |
|
DEC |
22 |
|
CALLERFLAG |
✔ |
Who Has Called this Program |
|
CHAR |
1 |
|
DBMSTRTTME |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PRGVERS |
|
Version of Program Inserted this Row |
|
CHAR |
20 |
|
TBS_NAME |
|
DB6: Tablespace Name |
DB6TSPNAME |
CHAR |
30 |
|
TBS_TYPE |
|
type: For Example, SMS or DMS |
|
CHAR |
50 |
|
CONTENTS |
|
contents: For Example, Regular Contents, Temporary Data |
|
CHAR |
50 |
|
TBSSTATE |
|
tbsstate: For Example, Normal, Load Pending |
|
CHAR |
50 |
|
TOTALPAGES |
|
totalpages: Total Pages |
|
DEC |
22 |
|
USABLEPGS |
|
usablepages: Total Pages Minus Overhead |
|
DEC |
22 |
|
PAGESIZE |
|
pagesize: Page Size in Bytes |
|
DEC |
22 |
|
EXTSIZE |
|
extsize: Extent Size in Pages |
|
DEC |
22 |
|
PF_SZ |
|
prefetchsize: Prefetch Size from SYSCAT (AUTOMATIC or Fix) |
|
DEC |
22 |
|
NUM_CONT |
|
ncontainers: Number of Containers |
|
DEC |
22 |
|
USEDPAGES |
|
usedpages: Used Pages |
|
DEC |
22 |
|
FREEPAGES |
|
freepages: Usable Pages Minus Used Pages |
|
DEC |
22 |
|
HGHWTRMRK |
|
highwatermark: High Water Mark of Used Page Numbers |
|
DEC |
22 |
|
AUTOSTOR |
|
is_automatic_storage:Managed by AUTOSTORAGE |
|
CHAR |
3 |
|
AUTORESIZ |
|
is_auto_resize_enabled: automatic RESIZE enabled |
|
CHAR |
3 |
|
INITSIZ |
|
tbsp_initial_size: Initial tablespace size |
|
DEC |
22 |
|
CURRSIZ |
|
tbsp_current_size: Current tablespace size |
|
DEC |
22 |
|
INCRSIZABS |
|
increase_size: Absolute value for automatich increase |
|
DEC |
22 |
|
INCRSIZPCT |
|
increase_size_percent: percentual value of automatic resize |
|
DEC |
22 |
|
LASTRESIZ |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
LASTRSZFAI |
|
last_resize_attempt_failed: status of failed resize |
|
INT2 |
5 |
|
MAX_SIZE |
|
tbsp_max_size: maximum allowed size for auto extent |
|
DEC |
22 |
|
FS_CACHING |
|
fs_caching: status of filesystem caching |
|
CHAR |
3 |
|
TBSP_CUR_POOL_ID |
|
tbsp_curr_pool_id: current bufferpool ID |
|
DEC |
22 |
|
TBSP_NXT_POOL_ID |
|
tbsp_next_pool_id: bufferpool ID at next startup |
|
DEC |
22 |
|
TBSP_PENDING_FREE_PAGES |
|
tbsp_pending_free_pages |
|
DEC |
22 |
|
TBSP_MIN_RECOVERY_TIME |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
TBSP_NUM_RANGES |
|
tbsp_num_ranges |
|
DEC |
22 |
|
TBSP_PAGE_TOP |
|
|
|
DEC |
22 |
|
RECLAIMABLE_SPACE_ENABLED |
|
Replacement for Real Boolean Type: 'X' == True '' == False |
WDY_BOOLEAN |
CHAR |
1 |
|
TBSP_PATHS_DROPPED |
|
Replacement for Real Boolean Type: 'X' == True '' == False |
WDY_BOOLEAN |
CHAR |
1 |
|
PF_SZ_CURRENT |
|
prefetch_size. Current Prefetch Size |
|
DEC |
22 |
|