| 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 |
|