Properties

Name: DB_XXXXX 
Schema: USER 
Status: NORMAL 
Create time: 01.07.2006 
Tablespace: USERSPACE1 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  APPL_SECTION_INSERTS  BIGINT         
  APPL_SECTION_LOOKUPS  BIGINT         
  BINDS_PRECOMPILES  BIGINT         
  CAT_CACHE_HEAP_FULL  BIGINT         
  CAT_CACHE_INSERTS  BIGINT         
  CAT_CACHE_LOOKUPS  BIGINT         
  CAT_CACHE_OVERFLOWS  BIGINT         
  CAT_CACHE_SIZE_TOP  BIGINT         
  CATALOG_NODE  BIGINT         
  CATALOG_NODE_NAME  VARCHAR  32  1251         
  COMMIT_SQL_STMTS  BIGINT         
  CONNECTIONS_TOP  BIGINT         
  DB_HEAP_TOP  BIGINT         
  DDL_SQL_STMTS  BIGINT         
  DEADLOCKS  BIGINT         
  DIRECT_READ_REQS  BIGINT         
  DIRECT_READ_TIME  BIGINT         
  DIRECT_READS  BIGINT         
  DIRECT_WRITE_REQS  BIGINT         
  DIRECT_WRITE_TIME  BIGINT         
  DIRECT_WRITES  BIGINT         
  DISCONN_TIME  TIMESTAMP  10         
  DYNAMIC_SQL_STMTS  BIGINT         
  ELAPSED_EXEC_TIME  BIGINT         
  EVMON_ACTIVATES  BIGINT         
  EVMON_FLUSHES  BIGINT         
  FAILED_SQL_STMTS  BIGINT         
  FILES_CLOSED  BIGINT         
  HASH_JOIN_OVERFLOWS  BIGINT         
  HASH_JOIN_SMALL_OVERFLOWS  BIGINT         
  INT_AUTO_REBINDS  BIGINT         
  INT_COMMITS  BIGINT         
  INT_ROLLBACKS  BIGINT         
  INT_ROWS_DELETED  BIGINT         
  INT_ROWS_INSERTED  BIGINT         
  INT_ROWS_UPDATED  BIGINT         
  LOCK_ESCALS  BIGINT         
  LOCK_TIMEOUTS  BIGINT         
  LOCK_WAIT_TIME  BIGINT         
  LOCK_WAITS  BIGINT         
  LOG_FILE_ARCHIVE  BIGINT         
  LOG_FILE_NUM_CURR  BIGINT         
  LOG_FILE_NUM_FIRST  BIGINT         
  LOG_FILE_NUM_LAST  BIGINT         
  LOG_HELD_BY_DIRTY_PAGES  BIGINT         
  LOG_READ_TIME  BIGINT         
  LOG_READS  BIGINT         
  LOG_TO_REDO_FOR_RECOVERY  BIGINT         
  LOG_WRITE_TIME  BIGINT         
  LOG_WRITES  BIGINT         
  NUM_LOG_BUFF_FULL  BIGINT         
  NUM_LOG_DATA_IN_BUFF  BIGINT         
  NUM_LOG_PART_PAGE_IO  BIGINT         
  NUM_LOG_READ_IO  BIGINT         
  NUM_LOG_WRITE_IO  BIGINT         
  PARTIAL_RECORD  SMALLINT         
  PKG_CACHE_INSERTS  BIGINT         
  PKG_CACHE_LOOKUPS  BIGINT         
  PKG_CACHE_NUM_OVERFLOWS  BIGINT         
  PKG_CACHE_SIZE_TOP  BIGINT         
  POOL_ASYNC_DATA_READ_REQS  BIGINT         
  POOL_ASYNC_DATA_READS  BIGINT         
  POOL_ASYNC_DATA_WRITES  BIGINT         
  POOL_ASYNC_INDEX_READ_REQS  BIGINT         
  POOL_ASYNC_INDEX_READS  BIGINT         
  POOL_ASYNC_INDEX_WRITES  BIGINT         
  POOL_ASYNC_READ_TIME  BIGINT         
  POOL_ASYNC_WRITE_TIME  BIGINT         
  POOL_DATA_FROM_ESTORE  BIGINT         
  POOL_DATA_L_READS  BIGINT         
  POOL_DATA_P_READS  BIGINT         
  POOL_DATA_TO_ESTORE  BIGINT         
  POOL_DATA_WRITES  BIGINT         
  POOL_DRTY_PG_STEAL_CLNS  BIGINT         
  POOL_DRTY_PG_THRSH_CLNS  BIGINT         
  POOL_INDEX_FROM_ESTORE  BIGINT         
  POOL_INDEX_L_READS  BIGINT         
  POOL_INDEX_P_READS  BIGINT         
  POOL_INDEX_TO_ESTORE  BIGINT         
  POOL_INDEX_WRITES  BIGINT         
  POOL_LSN_GAP_CLNS  BIGINT         
  POOL_NO_VICTIM_BUFFER  BIGINT         
  POOL_READ_TIME  BIGINT         
  POOL_TEMP_DATA_L_READS  BIGINT         
  POOL_TEMP_DATA_P_READS  BIGINT         
  POOL_TEMP_INDEX_L_READS  BIGINT         
  POOL_TEMP_INDEX_P_READS  BIGINT         
  POOL_WRITE_TIME  BIGINT         
  PREFETCH_WAIT_TIME  BIGINT         
  PRIV_WORKSPACE_NUM_OVERFLOWS  BIGINT         
  PRIV_WORKSPACE_SECTION_INSERTS  BIGINT         
  PRIV_WORKSPACE_SECTION_LOOKUPS  BIGINT         
  PRIV_WORKSPACE_SIZE_TOP  BIGINT         
  ROLLBACK_SQL_STMTS  BIGINT         
  ROWS_DELETED  BIGINT         
  ROWS_INSERTED  BIGINT         
  ROWS_READ  BIGINT         
  ROWS_SELECTED  BIGINT         
  ROWS_UPDATED  BIGINT         
  SEC_LOG_USED_TOP  BIGINT         
  SELECT_SQL_STMTS  BIGINT         
  SERVER_PLATFORM  INTEGER         
  SHR_WORKSPACE_NUM_OVERFLOWS  BIGINT         
  SHR_WORKSPACE_SECTION_INSERTS  BIGINT         
  SHR_WORKSPACE_SECTION_LOOKUPS  BIGINT         
  SHR_WORKSPACE_SIZE_TOP  BIGINT         
  SORT_OVERFLOWS  BIGINT         
  SORT_SHRHEAP_TOP  BIGINT         
  STATIC_SQL_STMTS  BIGINT         
  TOT_LOG_USED_TOP  BIGINT         
  TOTAL_CONS  BIGINT         
  TOTAL_HASH_JOINS  BIGINT         
  TOTAL_HASH_LOOPS  BIGINT         
  TOTAL_SORT_TIME  BIGINT         
  TOTAL_SORTS  BIGINT         
  UID_SQL_STMTS  BIGINT         
  UNREAD_PREFETCH_PAGES  BIGINT         
  X_LOCK_ESCALS  BIGINT         
Total: 118 column(s)

Autherisations

Grantor Grantee Authorities
  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)

SQL

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

See Also

List of tables