|
APPL_SECTION_INSERTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
APPL_SECTION_LOOKUPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
BINDS_PRECOMPILES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CAT_CACHE_HEAP_FULL |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CAT_CACHE_INSERTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CAT_CACHE_LOOKUPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CAT_CACHE_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CAT_CACHE_SIZE_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CATALOG_NODE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CATALOG_NODE_NAME |
VARCHAR |
32 |
0 |
1251 |
|
|
|
|
|
COMMIT_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
CONNECTIONS_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DB_HEAP_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DDL_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DEADLOCKS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_READ_REQS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_READ_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_WRITE_REQS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_WRITE_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DIRECT_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
DISCONN_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
DYNAMIC_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ELAPSED_EXEC_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
EVMON_ACTIVATES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
EVMON_FLUSHES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
FAILED_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
FILES_CLOSED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
HASH_JOIN_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
HASH_JOIN_SMALL_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_AUTO_REBINDS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_COMMITS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_ROLLBACKS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_ROWS_DELETED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_ROWS_INSERTED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
INT_ROWS_UPDATED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOCK_ESCALS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOCK_TIMEOUTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOCK_WAIT_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOCK_WAITS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_FILE_ARCHIVE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_FILE_NUM_CURR |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_FILE_NUM_FIRST |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_FILE_NUM_LAST |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_HELD_BY_DIRTY_PAGES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_READ_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_TO_REDO_FOR_RECOVERY |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_WRITE_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
LOG_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
NUM_LOG_BUFF_FULL |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
NUM_LOG_DATA_IN_BUFF |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
NUM_LOG_PART_PAGE_IO |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
NUM_LOG_READ_IO |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
NUM_LOG_WRITE_IO |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PARTIAL_RECORD |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
PKG_CACHE_INSERTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PKG_CACHE_LOOKUPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PKG_CACHE_NUM_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PKG_CACHE_SIZE_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_DATA_READ_REQS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_DATA_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_DATA_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_INDEX_READ_REQS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_INDEX_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_INDEX_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_READ_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_ASYNC_WRITE_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DATA_FROM_ESTORE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DATA_L_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DATA_P_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DATA_TO_ESTORE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DATA_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DRTY_PG_STEAL_CLNS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_DRTY_PG_THRSH_CLNS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_INDEX_FROM_ESTORE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_INDEX_L_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_INDEX_P_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_INDEX_TO_ESTORE |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_INDEX_WRITES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_LSN_GAP_CLNS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_NO_VICTIM_BUFFER |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_READ_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_TEMP_DATA_L_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_TEMP_DATA_P_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_TEMP_INDEX_L_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_TEMP_INDEX_P_READS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
POOL_WRITE_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PREFETCH_WAIT_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PRIV_WORKSPACE_NUM_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PRIV_WORKSPACE_SECTION_INSERTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PRIV_WORKSPACE_SECTION_LOOKUPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
PRIV_WORKSPACE_SIZE_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROLLBACK_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROWS_DELETED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROWS_INSERTED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROWS_READ |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROWS_SELECTED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
ROWS_UPDATED |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SEC_LOG_USED_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SELECT_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SERVER_PLATFORM |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SHR_WORKSPACE_NUM_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SHR_WORKSPACE_SECTION_INSERTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SHR_WORKSPACE_SECTION_LOOKUPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SHR_WORKSPACE_SIZE_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SORT_OVERFLOWS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
SORT_SHRHEAP_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
STATIC_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOT_LOG_USED_TOP |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOTAL_CONS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOTAL_HASH_JOINS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOTAL_HASH_LOOPS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOTAL_SORT_TIME |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
TOTAL_SORTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
UID_SQL_STMTS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
UNREAD_PREFETCH_PAGES |
BIGINT |
8 |
0 |
0 |
|
|
|
|
|
X_LOCK_ESCALS |
BIGINT |
8 |
0 |
0 |
|
|
|
|
Total: 118 column(s)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."DB_XXXXX" (
"APPL_SECTION_INSERTS" BIGINT NOT NULL ,
"APPL_SECTION_LOOKUPS" BIGINT NOT NULL ,
"BINDS_PRECOMPILES" BIGINT NOT NULL ,
"CAT_CACHE_HEAP_FULL" BIGINT NOT NULL ,
"CAT_CACHE_INSERTS" BIGINT NOT NULL ,
"CAT_CACHE_LOOKUPS" BIGINT NOT NULL ,
"CAT_CACHE_OVERFLOWS" BIGINT NOT NULL ,
"CAT_CACHE_SIZE_TOP" BIGINT NOT NULL ,
"CATALOG_NODE" BIGINT NOT NULL ,
"CATALOG_NODE_NAME" VARCHAR(32) NOT NULL ,
"COMMIT_SQL_STMTS" BIGINT NOT NULL ,
"CONNECTIONS_TOP" BIGINT NOT NULL ,
"DB_HEAP_TOP" BIGINT NOT NULL ,
"DDL_SQL_STMTS" BIGINT NOT NULL ,
"DEADLOCKS" BIGINT NOT NULL ,
"DIRECT_READ_REQS" BIGINT NOT NULL ,
"DIRECT_READ_TIME" BIGINT NOT NULL ,
"DIRECT_READS" BIGINT NOT NULL ,
"DIRECT_WRITE_REQS" BIGINT NOT NULL ,
"DIRECT_WRITE_TIME" BIGINT NOT NULL ,
"DIRECT_WRITES" BIGINT NOT NULL ,
"DISCONN_TIME" TIMESTAMP NOT NULL ,
"DYNAMIC_SQL_STMTS" BIGINT NOT NULL ,
"ELAPSED_EXEC_TIME" BIGINT NOT NULL ,
"EVMON_ACTIVATES" BIGINT NOT NULL ,
"EVMON_FLUSHES" BIGINT NOT NULL ,
"FAILED_SQL_STMTS" BIGINT NOT NULL ,
"FILES_CLOSED" BIGINT NOT NULL ,
"HASH_JOIN_OVERFLOWS" BIGINT NOT NULL ,
"HASH_JOIN_SMALL_OVERFLOWS" BIGINT NOT NULL ,
"INT_AUTO_REBINDS" BIGINT NOT NULL ,
"INT_COMMITS" BIGINT NOT NULL ,
"INT_ROLLBACKS" BIGINT NOT NULL ,
"INT_ROWS_DELETED" BIGINT NOT NULL ,
"INT_ROWS_INSERTED" BIGINT NOT NULL ,
"INT_ROWS_UPDATED" BIGINT NOT NULL ,
"LOCK_ESCALS" BIGINT NOT NULL ,
"LOCK_TIMEOUTS" BIGINT NOT NULL ,
"LOCK_WAIT_TIME" BIGINT NOT NULL ,
"LOCK_WAITS" BIGINT NOT NULL ,
"LOG_FILE_ARCHIVE" BIGINT NOT NULL ,
"LOG_FILE_NUM_CURR" BIGINT NOT NULL ,
"LOG_FILE_NUM_FIRST" BIGINT NOT NULL ,
"LOG_FILE_NUM_LAST" BIGINT NOT NULL ,
"LOG_HELD_BY_DIRTY_PAGES" BIGINT NOT NULL ,
"LOG_READ_TIME" BIGINT NOT NULL ,
"LOG_READS" BIGINT NOT NULL ,
"LOG_TO_REDO_FOR_RECOVERY" BIGINT NOT NULL ,
"LOG_WRITE_TIME" BIGINT NOT NULL ,
"LOG_WRITES" BIGINT NOT NULL ,
"NUM_LOG_BUFF_FULL" BIGINT NOT NULL ,
"NUM_LOG_DATA_IN_BUFF" BIGINT NOT NULL ,
"NUM_LOG_PART_PAGE_IO" BIGINT NOT NULL ,
"NUM_LOG_READ_IO" BIGINT NOT NULL ,
"NUM_LOG_WRITE_IO" BIGINT NOT NULL ,
"PARTIAL_RECORD" SMALLINT NOT NULL ,
"PKG_CACHE_INSERTS" BIGINT NOT NULL ,
"PKG_CACHE_LOOKUPS" BIGINT NOT NULL ,
"PKG_CACHE_NUM_OVERFLOWS" BIGINT NOT NULL ,
"PKG_CACHE_SIZE_TOP" BIGINT NOT NULL ,
"POOL_ASYNC_DATA_READ_REQS" BIGINT NOT NULL ,
"POOL_ASYNC_DATA_READS" BIGINT NOT NULL ,
"POOL_ASYNC_DATA_WRITES" BIGINT NOT NULL ,
"POOL_ASYNC_INDEX_READ_REQS" BIGINT NOT NULL ,
"POOL_ASYNC_INDEX_READS" BIGINT NOT NULL ,
"POOL_ASYNC_INDEX_WRITES" BIGINT NOT NULL ,
"POOL_ASYNC_READ_TIME" BIGINT NOT NULL ,
"POOL_ASYNC_WRITE_TIME" BIGINT NOT NULL ,
"POOL_DATA_FROM_ESTORE" BIGINT NOT NULL ,
"POOL_DATA_L_READS" BIGINT NOT NULL ,
"POOL_DATA_P_READS" BIGINT NOT NULL ,
"POOL_DATA_TO_ESTORE" BIGINT NOT NULL ,
"POOL_DATA_WRITES" BIGINT NOT NULL ,
"POOL_DRTY_PG_STEAL_CLNS" BIGINT NOT NULL ,
"POOL_DRTY_PG_THRSH_CLNS" BIGINT NOT NULL ,
"POOL_INDEX_FROM_ESTORE" BIGINT NOT NULL ,
"POOL_INDEX_L_READS" BIGINT NOT NULL ,
"POOL_INDEX_P_READS" BIGINT NOT NULL ,
"POOL_INDEX_TO_ESTORE" BIGINT NOT NULL ,
"POOL_INDEX_WRITES" BIGINT NOT NULL ,
"POOL_LSN_GAP_CLNS" BIGINT NOT NULL ,
"POOL_NO_VICTIM_BUFFER" BIGINT NOT NULL ,
"POOL_READ_TIME" BIGINT NOT NULL ,
"POOL_TEMP_DATA_L_READS" BIGINT NOT NULL ,
"POOL_TEMP_DATA_P_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDEX_L_READS" BIGINT NOT NULL ,
"POOL_TEMP_INDEX_P_READS" BIGINT NOT NULL ,
"POOL_WRITE_TIME" BIGINT NOT NULL ,
"PREFETCH_WAIT_TIME" BIGINT NOT NULL ,
"PRIV_WORKSPACE_NUM_OVERFLOWS" BIGINT NOT NULL ,
"PRIV_WORKSPACE_SECTION_INSERTS" BIGINT NOT NULL ,
"PRIV_WORKSPACE_SECTION_LOOKUPS" BIGINT NOT NULL ,
"PRIV_WORKSPACE_SIZE_TOP" BIGINT NOT NULL ,
"ROLLBACK_SQL_STMTS" BIGINT NOT NULL ,
"ROWS_DELETED" BIGINT NOT NULL ,
"ROWS_INSERTED" BIGINT NOT NULL ,
"ROWS_READ" BIGINT NOT NULL ,
"ROWS_SELECTED" BIGINT NOT NULL ,
"ROWS_UPDATED" BIGINT NOT NULL ,
"SEC_LOG_USED_TOP" BIGINT NOT NULL ,
"SELECT_SQL_STMTS" BIGINT NOT NULL ,
"SERVER_PLATFORM" INTEGER NOT NULL ,
"SHR_WORKSPACE_NUM_OVERFLOWS" BIGINT NOT NULL ,
"SHR_WORKSPACE_SECTION_INSERTS" BIGINT NOT NULL ,
"SHR_WORKSPACE_SECTION_LOOKUPS" BIGINT NOT NULL ,
"SHR_WORKSPACE_SIZE_TOP" BIGINT NOT NULL ,
"SORT_OVERFLOWS" BIGINT NOT NULL ,
"SORT_SHRHEAP_TOP" BIGINT NOT NULL ,
"STATIC_SQL_STMTS" BIGINT NOT NULL ,
"TOT_LOG_USED_TOP" BIGINT NOT NULL ,
"TOTAL_CONS" BIGINT NOT NULL ,
"TOTAL_HASH_JOINS" BIGINT NOT NULL ,
"TOTAL_HASH_LOOPS" BIGINT NOT NULL ,
"TOTAL_SORT_TIME" BIGINT NOT NULL ,
"TOTAL_SORTS" BIGINT NOT NULL ,
"UID_SQL_STMTS" BIGINT NOT NULL ,
"UNREAD_PREFETCH_PAGES" BIGINT NOT NULL ,
"X_LOCK_ESCALS" BIGINT NOT NULL )
IN "USERSPACE1" ;
List of tables