Database Design
30.07.2006
Index
Database: SAMPLE
_
3
Tables
_
3
USER.ACT
_
3
USER.CDSTAFF
_
3
USER.CL_SCHED
_
3
USER.CONNHEADER_XXXXX
_
3
USER.CONTROL_XXXXX
_
3
USER.DB_XXXXX
_
3
USER.DBMEMUSE_XXXXX
_
3
USER.DEADLOCK_XXXXX
_
3
USER.DEPARTMENT
_
3
USER.DLCONN_XXXXX
_
3
USER.EMP_ACT
_
3
Foreign keys
_
3
USER.EMP_PHOTO
_
3
USER.EMP_RESUME
_
3
Foreign keys
_
3
USER.EMPLOYEE
_
3
ASN.IBMSNAP_APPENQ
_
3
ASN.IBMSNAP_APPLYTRACE
_
3
ASN.IBMSNAP_APPLYTRAIL
_
3
ASN.IBMSNAP_APPPARMS
_
3
ASN.IBMSNAP_CAPENQ
_
3
ASN.IBMSNAP_CAPMON
_
3
ASN.IBMSNAP_CAPPARMS
_
3
ASN.IBMSNAP_CAPSCHEMAS
_
3
ASN.IBMSNAP_CAPTRACE
_
3
ASN.IBMSNAP_COMPENSATE
_
3
ASN.IBMSNAP_PRUNCNTL
_
3
ASN.IBMSNAP_PRUNE_LOCK
_
3
ASN.IBMSNAP_PRUNE_SET
_
3
ASN.IBMSNAP_REGISTER
_
3
ASN.IBMSNAP_RESTART
_
3
ASN.IBMSNAP_SIGNAL
_
3
ASN.IBMSNAP_SUBS_COLS
_
3
ASN.IBMSNAP_SUBS_EVENT
_
3
ASN.IBMSNAP_SUBS_MEMBR
_
3
ASN.IBMSNAP_SUBS_SET
_
3
ASN.IBMSNAP_SUBS_STMTS
_
3
ASN.IBMSNAP_UOW
_
3
USER.IN_TRAY
_
3
USER.ORG
_
3
USER.PROJECT
_
3
USER.SALES
_
3
USER.STAFF
_
3
Indexes
_
3
USER.CC1151754616344
_
3
USER.CC1151754705266
_
3
USER.CC1151755626422
_
3
USER.CC11517556264220
_
3
USER.CC11517556264221
_
3
USER.CC1151755924953
_
3
USER.CC1151778928062
_
3
ASN.IBMSNAP_APPENQX
_
3
ASN.IBMSNAP_APPLYTRACX
_
3
ASN.IBMSNAP_APPLYTRLX
_
3
ASN.IBMSNAP_APPPARMSX
_
3
ASN.IBMSNAP_CAPMONX
_
3
ASN.IBMSNAP_CAPSCHEMAX
_
3
ASN.IBMSNAP_CAPTRACEX
_
3
ASN.IBMSNAP_COMPENSATX
_
3
ASN.IBMSNAP_PRUNCNTLX
_
3
ASN.IBMSNAP_PRUNCNTLX1
_
3
ASN.IBMSNAP_PRUNCNTLX2
_
3
ASN.IBMSNAP_PRUNCNTLX3
_
3
ASN.IBMSNAP_PRUNE_SETX
_
3
ASN.IBMSNAP_REGISTERX
_
3
ASN.IBMSNAP_REGISTERX1
_
3
ASN.IBMSNAP_REGISTERX2
_
3
ASN.IBMSNAP_SIGNALX
_
3
ASN.IBMSNAP_SUBS_COLSX
_
3
ASN.IBMSNAP_SUBS_EVENX
_
3
ASN.IBMSNAP_SUBS_MEMBX
_
3
ASN.IBMSNAP_SUBS_SETX
_
3
ASN.IBMSNAP_SUBS_STMTX
_
3
ASN.IBMSNAP_UOWX
_
3
USER.IXCDSTAFF
_
3
USER.IXNICK_STAFF_MQT
_
3
USER.IXQQQ_STAFF_MQT
_
3
USER.PK_ACT
_
3
SYSIBM.SQL060616220800090
_
3
SYSIBM.SQL060616220803090
_
3
USER.XACT2
_
3
USER.XACT3
_
3
Constraints
_
3
CC1151413049172
_
3
CC1151754626766
_
3
CC1151754741688
_
3
Views
_
3
USER.AAAAAAAAAAAA
_
3
USER.VDEPT
_
3
USER.VHDEPT
_
3
Aliases
_
3
USER.DEPT
_
3
USER.EMP
_
3
Nicknames
_
3
USER.NICK_CHECK_CONSTRAINTS
_
3
USER.NICK_COLUMNS
_
3
USER.NICK_COLUMNS_S
_
3
USER.NICK_REF_CONSTRAINTS
_
3
USER.NICK_REFERENTIAL_CONSTRAINTS
_
3
USER.NICK_SALES
_
3
USER.NICK_STAFF
_
3
USER.QQQ_STAFF
_
3
Foreign keys
_
3
Materialised views
_
3
USER.NICK_STAFF_MQT
_
3
USER.QQQ_STAFF_MQT
_
3
Triggers
_
3
USER.TR_STAFF_BEFORE
_
3
Procedures
_
3
USER.BONUS_INCREASE
_
3
Functions
_
3
USER.RESIGN_EMPLOYEE.SQL060624144124500
_
3
Packages
_
3
USER.P4434996
_
3
Datatypes
_
3
USER.NEW_TYPE2
_
3
USER.PERSON_T
_
3
Sequences
_
3
USER.SAMPSEQUENCE
_
3
Tablespaces
_
3
NICK_STAFF_MQT_TS
_
3
QQQ_STAFF_MQT_TS
_
3
SYSCATSPACE
_
3
SYSTOOLSPACE
_
3
TEMPSPACE1
_
3
TSASNAA
_
3
TSASNCA
_
3
TSASNUOW
_
3
TSCDSTAFF
_
3
USERSPACE1
_
3
Schemas
_
3
ASN
_
3
NULLID
_
3
SQLJ
_
3
SYSCAT
_
3
SYSFUN
_
3
SYSIBM
_
3
SYSPROC
_
3
SYSSTAT
_
3
SYSTOOLS
_
3
USER
_
3
Bufferpools
_
3
IBMDEFAULTBP
_
3
Eventmonitors
_
3
DB2DETAILDEADLOCK
_
3
XXXXX
_
3
Wrappers
_
3
CONNECT
_
3
Servers
_
3
Users
_
3
DB2ADMIN
_
3
USER
_
3
Groups
_
3
PUBLIC
_
3
Instance Info
_
3
About
_
3
Database: SAMPLE
Properties
Tables
Total: 41 table(s) Indexes
Total: 38 index(s) Constraints
Total: 3 constraint(s) Views
Total: 3 view(s) Aliases
Total: 2 alias(es) Nicknames
Total: 8 nickname(s) Materialised views
Total: 2 materialised view(s) Procedures
Total: 1 procedure(s) Functions
Total: 1 function(s) Triggers
Total: 1 trigger(s) Packages
Total: 1 package(s) Sequences
Total: 1 sequence(s) Datatypes
Total: 2 datatype(s) Schemas
Total: 10 schema(s) Tablespaces
Total: 10 tablespace(s) Bufferpools
Total: 1 bufferpool(s) Eventmonitors
Total: 2 eventmonitor(s) Wrappers
Total: 1 wrapper(s) Users
Total: 2 user(s) Groups
Total: 1 group(s)Instance overview Tables
Table: USER.ACT
Properties
Columns
 | ACTNO | SMALLINT | 2 | 0 | 0 |  | | | |
 | ACTKWD | CHARACTER | 6 | 0 | 1251 | | | | |
| | ACTDESC | VARCHAR | 20 | 0 | 1251 | | | | |
Total: 3 column(s) Indexes
Total: 3 index(s) Constraints
Total: 1 constraint(s) Referencing tables
Total: 1 referencing table(s) Autherisations
 | 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 "."ACT" (
"ACTNO" SMALLINT NOT NULL ,
"ACTKWD" CHAR(6) NOT NULL ,
"ACTDESC" VARCHAR(20) NOT NULL )
IN "USERSPACE1" ;
COMMENT ON TABLE "USER "."ACT" IS 'This is the ACT table';
CREATE UNIQUE INDEX "USER "."XACT2" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC) ALLOW REVERSE SCANS;
CREATE INDEX "USER "."XACT3" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC,
"ACTDESC" ASC) ALLOW REVERSE SCANS;
ALTER TABLE "USER "."ACT"
ADD CONSTRAINT "PK_ACT" PRIMARY KEY
("ACTNO");
ALTER TABLE "USER "."ACT"
ADD CONSTRAINT "CC1151413049172" CHECK
(ACTNO >1000)
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables Table: USER.CDSTAFF
Properties
Columns
| | IBMSNAP_COMMITSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | IBMSNAP_INTENTSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | IBMSNAP_OPERATION | CHARACTER | 1 | 0 | 1251 | | | | |
| | ID | SMALLINT | 2 | 0 | 0 | | | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | |  | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | | | |
Total: 10 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "."CDSTAFF" (
"IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_INTENTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_OPERATION" CHAR(1) NOT NULL ,
"ID" SMALLINT NOT NULL ,
"NAME" VARCHAR(9) ,
"DEPT" SMALLINT ,
"JOB" CHAR(5) ,
"YEARS" SMALLINT ,
"SALARY" DECIMAL(7,2) ,
"COMM" DECIMAL(7,2) )
IN "TSCDSTAFF" ;
ALTER TABLE "USER "."CDSTAFF" VOLATILE CARDINALITY;
CREATE UNIQUE INDEX "USER "."IXCDSTAFF" ON "USER "."CDSTAFF"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_INTENTSEQ" ASC)
PCTFREE 0 ;
List of tables Table: USER.CL_SCHED
Properties
Columns
| | CLASS_CODE | CHARACTER | 7 | 0 | 1251 | | | | |
| | DAY | SMALLINT | 2 | 0 | 0 | | | | |
| | STARTING | TIME | 3 | 0 | 0 | | | | |
| | ENDING | TIME | 3 | 0 | 0 | | | | |
Total: 4 column(s) Autherisations
| | 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 "."CL_SCHED" (
"CLASS_CODE" CHAR(7) ,
"DAY" SMALLINT ,
"STARTING" TIME ,
"ENDING" TIME )
IN "USERSPACE1" ;
COMMENT ON TABLE "USER "."CL_SCHED" IS 'cl_sched comment';
List of tables Table: USER.CONNHEADER_XXXXX
Properties
Columns
| | AGENT_ID | BIGINT | 8 | 0 | 0 | | | | |
| | APPL_ID | CHARACTER | 32 | 0 | 1251 | | | | |
| | APPL_NAME | VARCHAR | 255 | 0 | 1251 | | | | |
| | AUTH_ID | VARCHAR | 30 | 0 | 1251 | | | | |
| | CLIENT_DB_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | CLIENT_NNAME | VARCHAR | 20 | 0 | 1251 | | | | |
| | CLIENT_PID | BIGINT | 8 | 0 | 0 | | | | |
| | CLIENT_PLATFORM | INTEGER | 4 | 0 | 0 | | | | |
| | CLIENT_PRDID | VARCHAR | 20 | 0 | 1251 | | | | |
| | CLIENT_PROTOCOL | INTEGER | 4 | 0 | 0 | | | | |
| | CODEPAGE_ID | INTEGER | 4 | 0 | 0 | | | | |
| | CONN_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | CORR_TOKEN | CHARACTER | 32 | 0 | 1251 | | | | |
| | EXECUTION_ID | VARCHAR | 30 | 0 | 1251 | | | | |
| | SEQUENCE_NO | CHARACTER | 4 | 0 | 1251 | | | | |
| | TERRITORY_CODE | INTEGER | 4 | 0 | 0 | | | | |
Total: 16 column(s) Autherisations
| | 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 "."CONNHEADER_XXXXX" (
"AGENT_ID" BIGINT NOT NULL ,
"APPL_ID" CHAR(32) NOT NULL ,
"APPL_NAME" VARCHAR(255) NOT NULL ,
"AUTH_ID" VARCHAR(30) NOT NULL ,
"CLIENT_DB_ALIAS" CHAR(8) NOT NULL ,
"CLIENT_NNAME" VARCHAR(20) NOT NULL ,
"CLIENT_PID" BIGINT NOT NULL ,
"CLIENT_PLATFORM" INTEGER NOT NULL ,
"CLIENT_PRDID" VARCHAR(20) NOT NULL ,
"CLIENT_PROTOCOL" INTEGER NOT NULL ,
"CODEPAGE_ID" INTEGER NOT NULL ,
"CONN_TIME" TIMESTAMP NOT NULL ,
"CORR_TOKEN" CHAR(32) NOT NULL ,
"EXECUTION_ID" VARCHAR(30) NOT NULL ,
"SEQUENCE_NO" CHAR(4) NOT NULL ,
"TERRITORY_CODE" INTEGER NOT NULL )
IN "USERSPACE1" ;
List of tables Table: USER.CONTROL_XXXXX
Properties
Columns
| | EVENT_MONITOR_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | MESSAGE | VARCHAR | 128 | 0 | 1251 | | | | |
| | MESSAGE_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
Total: 3 column(s) Autherisations
| | 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 "."CONTROL_XXXXX" (
"EVENT_MONITOR_NAME" VARCHAR(128) NOT NULL ,
"MESSAGE" VARCHAR(128) NOT NULL ,
"MESSAGE_TIME" TIMESTAMP NOT NULL )
IN "USERSPACE1" ;
List of tables Table: USER.DB_XXXXX
Properties
Columns
| | 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) Autherisations
| | 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" ;
List of tables Table: USER.DBMEMUSE_XXXXX
Properties
Columns
| | EVMON_ACTIVATES | BIGINT | 8 | 0 | 0 | | | | |
| | EVMON_FLUSHES | BIGINT | 8 | 0 | 0 | | | | |
| | POOL_CUR_SIZE | BIGINT | 8 | 0 | 0 | | | | |
| | POOL_ID | BIGINT | 8 | 0 | 0 | | | | |
| | POOL_MAX_SIZE | BIGINT | 8 | 0 | 0 | | | | |
| | POOL_WATERMARK | BIGINT | 8 | 0 | 0 | | | | |
Total: 6 column(s) Autherisations
| | 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 "."DBMEMUSE_XXXXX" (
"EVMON_ACTIVATES" BIGINT NOT NULL ,
"EVMON_FLUSHES" BIGINT NOT NULL ,
"POOL_CUR_SIZE" BIGINT NOT NULL ,
"POOL_ID" BIGINT NOT NULL ,
"POOL_MAX_SIZE" BIGINT NOT NULL ,
"POOL_WATERMARK" BIGINT NOT NULL )
IN "USERSPACE1" ;
List of tables Table: USER.DEADLOCK_XXXXX
Properties
Columns
| | DEADLOCK_ID | BIGINT | 8 | 0 | 0 | | | | |
| | DL_CONNS | BIGINT | 8 | 0 | 0 | | | | |
| | EVMON_ACTIVATES | BIGINT | 8 | 0 | 0 | | | | |
| | ROLLED_BACK_AGENT_ID | BIGINT | 8 | 0 | 0 | | | | |
| | ROLLED_BACK_APPL_ID | CHARACTER | 32 | 0 | 1251 | | | | |
| | ROLLED_BACK_PARTICIPANT_NO | SMALLINT | 2 | 0 | 0 | | | | |
| | ROLLED_BACK_SEQUENCE_NO | CHARACTER | 4 | 0 | 1251 | | | | |
| | START_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
Total: 8 column(s) Autherisations
| | 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 "."DEADLOCK_XXXXX" (
"DEADLOCK_ID" BIGINT NOT NULL ,
"DL_CONNS" BIGINT NOT NULL ,
"EVMON_ACTIVATES" BIGINT NOT NULL ,
"ROLLED_BACK_AGENT_ID" BIGINT NOT NULL ,
"ROLLED_BACK_APPL_ID" CHAR(32) NOT NULL ,
"ROLLED_BACK_PARTICIPANT_NO" SMALLINT NOT NULL ,
"ROLLED_BACK_SEQUENCE_NO" CHAR(4) NOT NULL ,
"START_TIME" TIMESTAMP NOT NULL )
IN "USERSPACE1" ;
List of tables Table: USER.DEPARTMENT
Properties
Columns
| | DEPTNO | CHARACTER | 3 | 0 | 1251 | | | | |
| | DEPTNAME | VARCHAR | 29 | 0 | 1251 | | | | |
| | MGRNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | ADMRDEPT | CHARACTER | 3 | 0 | 1251 | | | | |
| | LOCATION | CHARACTER | 16 | 0 | 1251 | | | | |
Total: 5 column(s) Dependent objects
Total: 2 dependent object(s) Autherisations
| | 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 "."DEPARTMENT" (
"DEPTNO" CHAR(3) NOT NULL ,
"DEPTNAME" VARCHAR(29) NOT NULL ,
"MGRNO" CHAR(6) ,
"ADMRDEPT" CHAR(3) NOT NULL ,
"LOCATION" CHAR(16) )
IN "USERSPACE1" ;
List of tables Table: USER.DLCONN_XXXXX
Properties
Columns
| | AGENT_ID | BIGINT | 8 | 0 | 0 | | | | |
| | APPL_ID | CHARACTER | 32 | 0 | 1251 | | | | |
| | APPL_ID_HOLDING_LK | CHARACTER | 32 | 0 | 1251 | | | | |
| | DEADLOCK_ID | BIGINT | 8 | 0 | 0 | | | | |
| | EVMON_ACTIVATES | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_ATTRIBUTES | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_COUNT | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_CURRENT_MODE | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_ESCALATION | SMALLINT | 2 | 0 | 0 | | | | |
| | LOCK_HOLD_COUNT | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_MODE | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_MODE_REQUESTED | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_NAME | CHARACTER | 13 | 0 | 1251 | | | | |
| | LOCK_NODE | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_OBJECT_NAME | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_OBJECT_TYPE | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_RELEASE_FLAGS | BIGINT | 8 | 0 | 0 | | | | |
| | LOCK_WAIT_START_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | PARTICIPANT_NO | SMALLINT | 2 | 0 | 0 | | | | |
| | PARTICIPANT_NO_HOLDING_LK | SMALLINT | 2 | 0 | 0 | | | | |
| | SEQUENCE_NO | CHARACTER | 4 | 0 | 1251 | | | | |
| | SEQUENCE_NO_HOLDING_LK | CHARACTER | 4 | 0 | 1251 | | | | |
| | START_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | TABLE_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | TABLE_SCHEMA | VARCHAR | 30 | 0 | 1251 | | | | |
| | TABLESPACE_NAME | VARCHAR | 18 | 0 | 1251 | | | | |
Total: 26 column(s) Autherisations
| | 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 "."DLCONN_XXXXX" (
"AGENT_ID" BIGINT NOT NULL ,
"APPL_ID" CHAR(32) NOT NULL ,
"APPL_ID_HOLDING_LK" CHAR(32) NOT NULL ,
"DEADLOCK_ID" BIGINT NOT NULL ,
"EVMON_ACTIVATES" BIGINT NOT NULL ,
"LOCK_ATTRIBUTES" BIGINT NOT NULL ,
"LOCK_COUNT" BIGINT NOT NULL ,
"LOCK_CURRENT_MODE" BIGINT NOT NULL ,
"LOCK_ESCALATION" SMALLINT NOT NULL ,
"LOCK_HOLD_COUNT" BIGINT NOT NULL ,
"LOCK_MODE" BIGINT NOT NULL ,
"LOCK_MODE_REQUESTED" BIGINT NOT NULL ,
"LOCK_NAME" CHAR(13) NOT NULL ,
"LOCK_NODE" BIGINT NOT NULL ,
"LOCK_OBJECT_NAME" BIGINT NOT NULL ,
"LOCK_OBJECT_TYPE" BIGINT NOT NULL ,
"LOCK_RELEASE_FLAGS" BIGINT NOT NULL ,
"LOCK_WAIT_START_TIME" TIMESTAMP NOT NULL ,
"PARTICIPANT_NO" SMALLINT NOT NULL ,
"PARTICIPANT_NO_HOLDING_LK" SMALLINT NOT NULL ,
"SEQUENCE_NO" CHAR(4) NOT NULL ,
"SEQUENCE_NO_HOLDING_LK" CHAR(4) NOT NULL ,
"START_TIME" TIMESTAMP NOT NULL ,
"TABLE_NAME" VARCHAR(128) NOT NULL ,
"TABLE_SCHEMA" VARCHAR(30) NOT NULL ,
"TABLESPACE_NAME" VARCHAR(18) NOT NULL )
IN "USERSPACE1" ;
List of tables Table: USER.EMP_ACT
Properties
Columns
| | EMPNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | PROJNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | ACTNO | SMALLINT | 2 | 0 | 0 | | | | |
| | EMPTIME | DECIMAL | 5 | 2 | 0 | | | | |
| | EMSTDATE | DATE | 4 | 0 | 0 | | | | |
| | EMENDATE | DATE | 4 | 0 | 0 | | | | |
Total: 6 column(s) Referenced tables
Total: 1 referenced table(s) Autherisations
| | 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 "."EMP_ACT" (
"EMPNO" CHAR(6) NOT NULL ,
"PROJNO" CHAR(6) NOT NULL ,
"ACTNO" SMALLINT NOT NULL ,
"EMPTIME" DECIMAL(5,2) ,
"EMSTDATE" DATE ,
"EMENDATE" DATE )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMP_ACT"
ADD CONSTRAINT "NOACTIONNOACTION" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables Foreign keys
Foreign key: NOACTIONNOACTION
Properties
SQL
ALTER TABLE "USER "."EMP_ACT"
ADD CONSTRAINT "NOACTIONNOACTION" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE NO ACTION
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of foreign keys Table: USER.EMP_PHOTO
Properties
Columns
| | EMPNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | PHOTO_FORMAT | VARCHAR | 10 | 0 | 1251 | | | | |
| | PICTURE | BLOB | 102400 | 0 | 0 | | | | |
Total: 3 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "."EMP_PHOTO" (
"EMPNO" CHAR(6) NOT NULL ,
"PHOTO_FORMAT" VARCHAR(10) NOT NULL ,
"PICTURE" BLOB(102400) LOGGED NOT COMPACT )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMP_PHOTO"
ADD PRIMARY KEY
("EMPNO",
"PHOTO_FORMAT");
List of tables Table: USER.EMP_RESUME
Properties
Columns
| | EMPNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | RESUME_FORMAT | VARCHAR | 10 | 0 | 1251 | | | | |
| | RESUME | CLOB | 5120 | 0 | 1251 | | | | |
Total: 3 column(s) Indexes
Total: 1 index(s) Referenced tables
Total: 1 referenced table(s) Autherisations
| | 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 "."EMP_RESUME" (
"EMPNO" CHAR(6) NOT NULL ,
"RESUME_FORMAT" VARCHAR(10) NOT NULL ,
"RESUME" CLOB(5120) LOGGED NOT COMPACT )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMP_RESUME"
ADD PRIMARY KEY
("EMPNO",
"RESUME_FORMAT");
ALTER TABLE "USER "."EMP_RESUME"
ADD CONSTRAINT "CC1151778995891" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE RESTRICT
ON UPDATE RESTRICT
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of tables Foreign keys
Foreign key: CC1151778995891
Properties
SQL
ALTER TABLE "USER "."EMP_RESUME"
ADD CONSTRAINT "CC1151778995891" FOREIGN KEY
("EMPNO")
REFERENCES "USER "."EMPLOYEE"
("EMPNO")
ON DELETE RESTRICT
ON UPDATE RESTRICT
ENFORCED
ENABLE QUERY OPTIMIZATION;
List of foreign keys Table: USER.EMPLOYEE
Properties
Columns
| | EMPNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | FIRSTNME | VARCHAR | 12 | 0 | 1251 | | | | |
| | MIDINIT | CHARACTER | 1 | 0 | 1251 | | | | |
| | LASTNAME | VARCHAR | 15 | 0 | 1251 | | | | |
| | WORKDEPT | CHARACTER | 3 | 0 | 1251 | | | | |
| | PHONENO | CHARACTER | 4 | 0 | 1251 | | | | |
| | HIREDATE | DATE | 4 | 0 | 0 | | | | |
| | JOB | CHARACTER | 8 | 0 | 1251 | | | | |
| | EDLEVEL | SMALLINT | 2 | 0 | 0 | | | | |
| | SEX | CHARACTER | 1 | 0 | 1251 | | | | |
| | BIRTHDATE | DATE | 4 | 0 | 0 | | | | |
| | SALARY | DECIMAL | 9 | 2 | 0 | | | | |
| | BONUS | DECIMAL | 9 | 2 | 0 | | | | |
| | COMM | DECIMAL | 9 | 2 | 0 | | | | |
Total: 14 column(s) Indexes
Total: 1 index(s) Referencing tables
Total: 2 referencing table(s) Autherisations
| | 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 "."EMPLOYEE" (
"EMPNO" CHAR(6) NOT NULL ,
"FIRSTNME" VARCHAR(12) NOT NULL ,
"MIDINIT" CHAR(1) NOT NULL ,
"LASTNAME" VARCHAR(15) NOT NULL ,
"WORKDEPT" CHAR(3) ,
"PHONENO" CHAR(4) ,
"HIREDATE" DATE ,
"JOB" CHAR(8) ,
"EDLEVEL" SMALLINT NOT NULL ,
"SEX" CHAR(1) ,
"BIRTHDATE" DATE ,
"SALARY" DECIMAL(9,2) ,
"BONUS" DECIMAL(9,2) ,
"COMM" DECIMAL(9,2) )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMPLOYEE"
ADD CONSTRAINT "CC1151778928062" PRIMARY KEY
("EMPNO");
List of tables Table: ASN.IBMSNAP_APPENQ
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
Total: 1 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_APPENQ" (
"APPLY_QUAL" CHAR(18) )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_APPENQX" ON "ASN "."IBMSNAP_APPENQ"
("APPLY_QUAL" ASC);
List of tables Table: ASN.IBMSNAP_APPLYTRACE
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | TRACE_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | OPERATION | CHARACTER | 8 | 0 | 1251 | | | | |
| | DESCRIPTION | VARCHAR | 1024 | 0 | 1251 | | | | |
Total: 4 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_APPLYTRACE" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"TRACE_TIME" TIMESTAMP NOT NULL ,
"OPERATION" CHAR(8) NOT NULL ,
"DESCRIPTION" VARCHAR(1024) NOT NULL )
IN "TSASNAA" ;
CREATE INDEX "ASN "."IBMSNAP_APPLYTRACX" ON "ASN "."IBMSNAP_APPLYTRACE"
("APPLY_QUAL" ASC,
"TRACE_TIME" ASC);
List of tables Table: ASN.IBMSNAP_APPLYTRAIL
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_TYPE | CHARACTER | 1 | 0 | 1251 | | | | |
| | WHOS_ON_FIRST | CHARACTER | 1 | 0 | 1251 | | | | |
| | ASNLOAD | CHARACTER | 1 | 0 | 1251 | | | | |
| | FULL_REFRESH | CHARACTER | 1 | 0 | 1251 | | | | |
| | EFFECTIVE_MEMBERS | INTEGER | 4 | 0 | 0 | | | | |
| | SET_INSERTED | INTEGER | 4 | 0 | 0 | | | | |
| | SET_DELETED | INTEGER | 4 | 0 | 0 | | | | |
| | SET_UPDATED | INTEGER | 4 | 0 | 0 | | | | |
| | SET_REWORKED | INTEGER | 4 | 0 | 0 | | | | |
| | SET_REJECTED_TRXS | INTEGER | 4 | 0 | 0 | | | | |
| | STATUS | SMALLINT | 2 | 0 | 0 | | | | |
| | LASTRUN | TIMESTAMP | 10 | 0 | 0 | | | | |
| | LASTSUCCESS | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SOURCE_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | SOURCE_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | SOURCE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | SOURCE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | SOURCE_VIEW_QUAL | SMALLINT | 2 | 0 | 0 | | | | |
| | TARGET_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | TARGET_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | TARGET_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | TARGET_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | CAPTURE_SCHEMA | VARCHAR | 30 | 0 | 1251 | | | | |
| | TGT_CAPTURE_SCHEMA | VARCHAR | 30 | 0 | 1251 | | | | |
| | FEDERATED_SRC_SRVR | VARCHAR | 18 | 0 | 1251 | | | | |
| | FEDERATED_TGT_SRVR | VARCHAR | 18 | 0 | 1251 | | | | |
| | JRN_LIB | CHARACTER | 10 | 0 | 1251 | | | | |
| | JRN_NAME | CHARACTER | 10 | 0 | 1251 | | | | |
| | COMMIT_COUNT | SMALLINT | 2 | 0 | 0 | | | | |
| | OPTION_FLAGS | CHARACTER | 4 | 0 | 1251 | | | | |
| | EVENT_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | ENDTIME | TIMESTAMP | 10 | 0 | 0 | | | CURRENT TIMESTAMP | |
| | SOURCE_CONN_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SQLSTATE | CHARACTER | 5 | 0 | 1251 | | | | |
| | SQLCODE | INTEGER | 4 | 0 | 0 | | | | |
| | SQLERRP | CHARACTER | 8 | 0 | 1251 | | | | |
| | SQLERRM | VARCHAR | 70 | 0 | 1251 | | | | |
| | APPERRM | VARCHAR | 760 | 0 | 1251 | | | | |
Total: 42 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_APPLYTRAIL" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"SET_TYPE" CHAR(1) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"ASNLOAD" CHAR(1) ,
"FULL_REFRESH" CHAR(1) ,
"EFFECTIVE_MEMBERS" INTEGER ,
"SET_INSERTED" INTEGER NOT NULL ,
"SET_DELETED" INTEGER NOT NULL ,
"SET_UPDATED" INTEGER NOT NULL ,
"SET_REWORKED" INTEGER NOT NULL ,
"SET_REJECTED_TRXS" INTEGER NOT NULL ,
"STATUS" SMALLINT NOT NULL ,
"LASTRUN" TIMESTAMP NOT NULL ,
"LASTSUCCESS" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"SOURCE_SERVER" CHAR(18) NOT NULL ,
"SOURCE_ALIAS" CHAR(8) ,
"SOURCE_OWNER" VARCHAR(30) ,
"SOURCE_TABLE" VARCHAR(128) ,
"SOURCE_VIEW_QUAL" SMALLINT ,
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_ALIAS" CHAR(8) ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"CAPTURE_SCHEMA" VARCHAR(30) NOT NULL ,
"TGT_CAPTURE_SCHEMA" VARCHAR(30) ,
"FEDERATED_SRC_SRVR" VARCHAR(18) ,
"FEDERATED_TGT_SRVR" VARCHAR(18) ,
"JRN_LIB" CHAR(10) ,
"JRN_NAME" CHAR(10) ,
"COMMIT_COUNT" SMALLINT ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"EVENT_NAME" CHAR(18) ,
"ENDTIME" TIMESTAMP NOT NULL WITH DEFAULT ,
"SOURCE_CONN_TIME" TIMESTAMP ,
"SQLSTATE" CHAR(5) ,
"SQLCODE" INTEGER ,
"SQLERRP" CHAR(8) ,
"SQLERRM" VARCHAR(70) ,
"APPERRM" VARCHAR(760) )
IN "TSASNAA" ;
CREATE INDEX "ASN "."IBMSNAP_APPLYTRLX" ON "ASN "."IBMSNAP_APPLYTRAIL"
("LASTRUN" DESC,
"APPLY_QUAL" ASC);
List of tables Table: ASN.IBMSNAP_APPPARMS
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | APPLY_PATH | VARCHAR | 1040 | 0 | 1251 | | | | |
| | COPYONCE | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | DELAY | INTEGER | 4 | 0 | 0 | | | 6 | |
| | ERRWAIT | INTEGER | 4 | 0 | 0 | | | 300 | |
| | INAMSG | CHARACTER | 1 | 0 | 1251 | | | 'Y' | |
| | LOADXIT | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | LOGREUSE | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | LOGSTDOUT | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | NOTIFY | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | OPT4ONE | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | SLEEP | CHARACTER | 1 | 0 | 1251 | | | 'Y' | |
| | SQLERRCONTINUE | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
| | SPILLFILE | VARCHAR | 10 | 0 | 1251 | | | 'DISK' | |
| | TERM | CHARACTER | 1 | 0 | 1251 | | | 'Y' | |
| | TRLREUSE | CHARACTER | 1 | 0 | 1251 | | | 'N' | |
Total: 16 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_APPPARMS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"APPLY_PATH" VARCHAR(1040) ,
"COPYONCE" CHAR(1) WITH DEFAULT 'N' ,
"DELAY" INTEGER WITH DEFAULT 6 ,
"ERRWAIT" INTEGER WITH DEFAULT 300 ,
"INAMSG" CHAR(1) WITH DEFAULT 'Y' ,
"LOADXIT" CHAR(1) WITH DEFAULT 'N' ,
"LOGREUSE" CHAR(1) WITH DEFAULT 'N' ,
"LOGSTDOUT" CHAR(1) WITH DEFAULT 'N' ,
"NOTIFY" CHAR(1) WITH DEFAULT 'N' ,
"OPT4ONE" CHAR(1) WITH DEFAULT 'N' ,
"SLEEP" CHAR(1) WITH DEFAULT 'Y' ,
"SQLERRCONTINUE" CHAR(1) WITH DEFAULT 'N' ,
"SPILLFILE" VARCHAR(10) WITH DEFAULT 'DISK' ,
"TERM" CHAR(1) WITH DEFAULT 'Y' ,
"TRLREUSE" CHAR(1) WITH DEFAULT 'N' )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_APPPARMSX" ON "ASN "."IBMSNAP_APPPARMS"
("APPLY_QUAL" ASC);
List of tables Table: ASN.IBMSNAP_CAPENQ
Properties
Columns
| | LOCK_NAME | CHARACTER | 9 | 0 | 1251 | | | | |
Total: 1 column(s) Autherisations
| | 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 "ASN "."IBMSNAP_CAPENQ" (
"LOCK_NAME" CHAR(9) )
IN "TSASNCA" ;
List of tables Table: ASN.IBMSNAP_CAPMON
Properties
Columns
| | MONITOR_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | RESTART_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | CURRENT_MEMORY | INTEGER | 4 | 0 | 0 | | | | |
| | CD_ROWS_INSERTED | INTEGER | 4 | 0 | 0 | | | | |
| | RECAP_ROWS_SKIPPED | INTEGER | 4 | 0 | 0 | | | | |
| | TRIGR_ROWS_SKIPPED | INTEGER | 4 | 0 | 0 | | | | |
| | CHG_ROWS_SKIPPED | INTEGER | 4 | 0 | 0 | | | | |
| | TRANS_PROCESSED | INTEGER | 4 | 0 | 0 | | | | |
| | TRANS_SPILLED | INTEGER | 4 | 0 | 0 | | | | |
| | MAX_TRANS_SIZE | INTEGER | 4 | 0 | 0 | | | | |
| | LOCKING_RETRIES | INTEGER | 4 | 0 | 0 | | | | |
| | JRN_LIB | CHARACTER | 10 | 0 | 1251 | | | | |
| | JRN_NAME | CHARACTER | 10 | 0 | 1251 | | | | |
| | LOGREADLIMIT | INTEGER | 4 | 0 | 0 | | | | |
| | CAPTURE_IDLE | INTEGER | 4 | 0 | 0 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
Total: 16 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_CAPMON" (
"MONITOR_TIME" TIMESTAMP NOT NULL ,
"RESTART_TIME" TIMESTAMP NOT NULL ,
"CURRENT_MEMORY" INTEGER NOT NULL ,
"CD_ROWS_INSERTED" INTEGER NOT NULL ,
"RECAP_ROWS_SKIPPED" INTEGER NOT NULL ,
"TRIGR_ROWS_SKIPPED" INTEGER NOT NULL ,
"CHG_ROWS_SKIPPED" INTEGER NOT NULL ,
"TRANS_PROCESSED" INTEGER NOT NULL ,
"TRANS_SPILLED" INTEGER NOT NULL ,
"MAX_TRANS_SIZE" INTEGER NOT NULL ,
"LOCKING_RETRIES" INTEGER NOT NULL ,
"JRN_LIB" CHAR(10) ,
"JRN_NAME" CHAR(10) ,
"LOGREADLIMIT" INTEGER NOT NULL ,
"CAPTURE_IDLE" INTEGER NOT NULL ,
"SYNCHTIME" TIMESTAMP NOT NULL )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_CAPMONX" ON "ASN "."IBMSNAP_CAPMON"
("MONITOR_TIME" ASC);
List of tables Table: ASN.IBMSNAP_CAPPARMS
Properties
Columns
| | RETENTION_LIMIT | INTEGER | 4 | 0 | 0 | | | | |
| | LAG_LIMIT | INTEGER | 4 | 0 | 0 | | | | |
| | COMMIT_INTERVAL | INTEGER | 4 | 0 | 0 | | | | |
| | PRUNE_INTERVAL | INTEGER | 4 | 0 | 0 | | | | |
| | TRACE_LIMIT | INTEGER | 4 | 0 | 0 | | | | |
| | MONITOR_LIMIT | INTEGER | 4 | 0 | 0 | | | | |
| | MONITOR_INTERVAL | INTEGER | 4 | 0 | 0 | | | | |
| | MEMORY_LIMIT | SMALLINT | 2 | 0 | 0 | | | | |
| | REMOTE_SRC_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | AUTOPRUNE | CHARACTER | 1 | 0 | 1251 | | | | |
| | TERM | CHARACTER | 1 | 0 | 1251 | | | | |
| | AUTOSTOP | CHARACTER | 1 | 0 | 1251 | | | | |
| | LOGREUSE | CHARACTER | 1 | 0 | 1251 | | | | |
| | LOGSTDOUT | CHARACTER | 1 | 0 | 1251 | | | | |
| | SLEEP_INTERVAL | SMALLINT | 2 | 0 | 0 | | | | |
| | CAPTURE_PATH | VARCHAR | 1040 | 0 | 1251 | | | | |
| | STARTMODE | VARCHAR | 10 | 0 | 1251 | | | | |
Total: 17 column(s) Autherisations
| | 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 "ASN "."IBMSNAP_CAPPARMS" (
"RETENTION_LIMIT" INTEGER ,
"LAG_LIMIT" INTEGER ,
"COMMIT_INTERVAL" INTEGER ,
"PRUNE_INTERVAL" INTEGER ,
"TRACE_LIMIT" INTEGER ,
"MONITOR_LIMIT" INTEGER ,
"MONITOR_INTERVAL" INTEGER ,
"MEMORY_LIMIT" SMALLINT ,
"REMOTE_SRC_SERVER" CHAR(18) ,
"AUTOPRUNE" CHAR(1) ,
"TERM" CHAR(1) ,
"AUTOSTOP" CHAR(1) ,
"LOGREUSE" CHAR(1) ,
"LOGSTDOUT" CHAR(1) ,
"SLEEP_INTERVAL" SMALLINT ,
"CAPTURE_PATH" VARCHAR(1040) ,
"STARTMODE" VARCHAR(10) )
IN "TSASNCA" ;
List of tables Table: ASN.IBMSNAP_CAPSCHEMAS
Properties
Columns
| | CAP_SCHEMA_NAME | VARCHAR | 30 | 0 | 1251 | | | | |
Total: 1 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_CAPSCHEMAS" (
"CAP_SCHEMA_NAME" VARCHAR(30) )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_CAPSCHEMAX" ON "ASN "."IBMSNAP_CAPSCHEMAS"
("CAP_SCHEMA_NAME" ASC);
List of tables Table: ASN.IBMSNAP_CAPTRACE
Properties
Columns
| | OPERATION | CHARACTER | 8 | 0 | 1251 | | | | |
| | TRACE_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | DESCRIPTION | VARCHAR | 1024 | 0 | 1251 | | | | |
Total: 3 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_CAPTRACE" (
"OPERATION" CHAR(8) NOT NULL ,
"TRACE_TIME" TIMESTAMP NOT NULL ,
"DESCRIPTION" VARCHAR(1024) NOT NULL )
IN "TSASNCA" ;
CREATE INDEX "ASN "."IBMSNAP_CAPTRACEX" ON "ASN "."IBMSNAP_CAPTRACE"
("TRACE_TIME" ASC);
List of tables Table: ASN.IBMSNAP_COMPENSATE
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | MEMBER | SMALLINT | 2 | 0 | 0 | | | | |
| | INTENTSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | OPERATION | CHARACTER | 1 | 0 | 1251 | | | | |
Total: 4 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_COMPENSATE" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"MEMBER" SMALLINT NOT NULL ,
"INTENTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"OPERATION" CHAR(1) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_COMPENSATX" ON "ASN "."IBMSNAP_COMPENSATE"
("APPLY_QUAL" ASC,
"MEMBER" ASC);
List of tables Table: ASN.IBMSNAP_PRUNCNTL
Properties
Columns
| | TARGET_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | TARGET_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | TARGET_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | SOURCE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | SOURCE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | SOURCE_VIEW_QUAL | SMALLINT | 2 | 0 | 0 | | | | |
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | CNTL_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | TARGET_STRUCTURE | SMALLINT | 2 | 0 | 0 | | | | |
| | CNTL_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | PHYS_CHANGE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | PHYS_CHANGE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | MAP_ID | VARCHAR | 10 | 0 | 1251 | | | | |
Total: 16 column(s) Indexes
 | ASN.IBMSNAP_PRUNCNTLX | UNIQUE | REGULAR | SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, APPLY_QUAL, SET_NAME, TARGET_SERVER, TARGET_TABLE, TARGET_OWNER | |
| | ASN.IBMSNAP_PRUNCNTLX1 | UNIQUE | REGULAR | MAP_ID | |
| | ASN.IBMSNAP_PRUNCNTLX2 | DUBLICATE | REGULAR | PHYS_CHANGE_OWNER, PHYS_CHANGE_TABLE | |
| | ASN.IBMSNAP_PRUNCNTLX3 | DUBLICATE | REGULAR | APPLY_QUAL, SET_NAME, TARGET_SERVER | |
Total: 4 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_PRUNCNTL" (
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"SYNCHTIME" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"CNTL_SERVER" CHAR(18) NOT NULL ,
"TARGET_STRUCTURE" SMALLINT NOT NULL ,
"CNTL_ALIAS" CHAR(8) ,
"PHYS_CHANGE_OWNER" VARCHAR(30) ,
"PHYS_CHANGE_TABLE" VARCHAR(128) ,
"MAP_ID" VARCHAR(10) NOT NULL )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX" ON "ASN "."IBMSNAP_PRUNCNTL"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC,
"TARGET_TABLE" ASC,
"TARGET_OWNER" ASC);
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX1" ON "ASN "."IBMSNAP_PRUNCNTL"
("MAP_ID" ASC);
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX2" ON "ASN "."IBMSNAP_PRUNCNTL"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX3" ON "ASN "."IBMSNAP_PRUNCNTL"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC);
List of tables Table: ASN.IBMSNAP_PRUNE_LOCK
Properties
Columns
Total: 1 column(s) Autherisations
| | 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 "ASN "."IBMSNAP_PRUNE_LOCK" (
"DUMMY" CHAR(1) )
IN "TSASNCA" ;
List of tables Table: ASN.IBMSNAP_PRUNE_SET
Properties
Columns
| | TARGET_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
Total: 5 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_PRUNE_SET" (
"TARGET_SERVER" CHAR(18) NOT NULL ,
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"SYNCHTIME" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA NOT NULL )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNE_SETX" ON "ASN "."IBMSNAP_PRUNE_SET"
("TARGET_SERVER" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC);
List of tables Table: ASN.IBMSNAP_REGISTER
Properties
Columns
| | SOURCE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | SOURCE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | SOURCE_VIEW_QUAL | SMALLINT | 2 | 0 | 0 | | | | |
| | GLOBAL_RECORD | CHARACTER | 1 | 0 | 1251 | | | | |
| | SOURCE_STRUCTURE | SMALLINT | 2 | 0 | 0 | | | | |
| | SOURCE_CONDENSED | CHARACTER | 1 | 0 | 1251 | | | | |
| | SOURCE_COMPLETE | CHARACTER | 1 | 0 | 1251 | | | | |
| | CD_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | CD_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | PHYS_CHANGE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | PHYS_CHANGE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | CD_OLD_SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | CD_NEW_SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | DISABLE_REFRESH | SMALLINT | 2 | 0 | 0 | | | | |
| | CCD_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | CCD_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | CCD_OLD_SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | CCD_CONDENSED | CHARACTER | 1 | 0 | 1251 | | | | |
| | CCD_COMPLETE | CHARACTER | 1 | 0 | 1251 | | | | |
| | ARCH_LEVEL | CHARACTER | 4 | 0 | 1251 | | | | |
| | DESCRIPTION | CHARACTER | 254 | 0 | 1251 | | | | |
| | BEFORE_IMG_PREFIX | VARCHAR | 4 | 0 | 1251 | | | | |
| | CONFLICT_LEVEL | CHARACTER | 1 | 0 | 1251 | | | | |
| | CHG_UPD_TO_DEL_INS | CHARACTER | 1 | 0 | 1251 | | | | |
| | CHGONLY | CHARACTER | 1 | 0 | 1251 | | | | |
| | RECAPTURE | CHARACTER | 1 | 0 | 1251 | | | | |
| | OPTION_FLAGS | CHARACTER | 4 | 0 | 1251 | | | | |
| | STOP_ON_ERROR | CHARACTER | 1 | 0 | 1251 | | | 'Y' | |
| | STATE | CHARACTER | 1 | 0 | 1251 | | | 'I' | |
| | STATE_INFO | CHARACTER | 8 | 0 | 1251 | | | | |
Total: 32 column(s) Indexes
Total: 3 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_REGISTER" (
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"GLOBAL_RECORD" CHAR(1) NOT NULL ,
"SOURCE_STRUCTURE" SMALLINT NOT NULL ,
"SOURCE_CONDENSED" CHAR(1) NOT NULL ,
"SOURCE_COMPLETE" CHAR(1) NOT NULL ,
"CD_OWNER" VARCHAR(30) ,
"CD_TABLE" VARCHAR(128) ,
"PHYS_CHANGE_OWNER" VARCHAR(30) ,
"PHYS_CHANGE_TABLE" VARCHAR(128) ,
"CD_OLD_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"CD_NEW_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"DISABLE_REFRESH" SMALLINT NOT NULL ,
"CCD_OWNER" VARCHAR(30) ,
"CCD_TABLE" VARCHAR(128) ,
"CCD_OLD_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"CCD_CONDENSED" CHAR(1) ,
"CCD_COMPLETE" CHAR(1) ,
"ARCH_LEVEL" CHAR(4) NOT NULL ,
"DESCRIPTION" CHAR(254) ,
"BEFORE_IMG_PREFIX" VARCHAR(4) ,
"CONFLICT_LEVEL" CHAR(1) ,
"CHG_UPD_TO_DEL_INS" CHAR(1) ,
"CHGONLY" CHAR(1) ,
"RECAPTURE" CHAR(1) ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"STOP_ON_ERROR" CHAR(1) WITH DEFAULT 'Y' ,
"STATE" CHAR(1) WITH DEFAULT 'I' ,
"STATE_INFO" CHAR(8) )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_REGISTERX" ON "ASN "."IBMSNAP_REGISTER"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC);
CREATE INDEX "ASN "."IBMSNAP_REGISTERX1" ON "ASN "."IBMSNAP_REGISTER"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
CREATE INDEX "ASN "."IBMSNAP_REGISTERX2" ON "ASN "."IBMSNAP_REGISTER"
("GLOBAL_RECORD" ASC);
List of tables Table: ASN.IBMSNAP_RESTART
Properties
Columns
| | MAX_COMMITSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | MAX_COMMIT_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | MIN_INFLIGHTSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | CURR_COMMIT_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | CAPTURE_FIRST_SEQ | CHARACTER | 10 | 0 | 0 | | | | |
Total: 5 column(s) Autherisations
| | 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 "ASN "."IBMSNAP_RESTART" (
"MAX_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"MAX_COMMIT_TIME" TIMESTAMP NOT NULL ,
"MIN_INFLIGHTSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"CURR_COMMIT_TIME" TIMESTAMP NOT NULL ,
"CAPTURE_FIRST_SEQ" CHAR(10) FOR BIT DATA NOT NULL )
IN "TSASNCA" ;
List of tables Table: ASN.IBMSNAP_SIGNAL
Properties
Columns
| | SIGNAL_TIME | TIMESTAMP | 10 | 0 | 0 | | | CURRENT TIMESTAMP | |
| | SIGNAL_TYPE | VARCHAR | 30 | 0 | 1251 | | | | |
| | SIGNAL_SUBTYPE | VARCHAR | 30 | 0 | 1251 | | | | |
| | SIGNAL_INPUT_IN | VARCHAR | 500 | 0 | 1251 | | | | |
| | SIGNAL_STATE | CHARACTER | 1 | 0 | 1251 | | | | |
| | SIGNAL_LSN | CHARACTER | 10 | 0 | 0 | | | | |
Total: 6 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SIGNAL" (
"SIGNAL_TIME" TIMESTAMP NOT NULL WITH DEFAULT ,
"SIGNAL_TYPE" VARCHAR(30) NOT NULL ,
"SIGNAL_SUBTYPE" VARCHAR(30) ,
"SIGNAL_INPUT_IN" VARCHAR(500) ,
"SIGNAL_STATE" CHAR(1) NOT NULL ,
"SIGNAL_LSN" CHAR(10) FOR BIT DATA )
DATA CAPTURE CHANGES
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SIGNALX" ON "ASN "."IBMSNAP_SIGNAL"
("SIGNAL_TIME" ASC);
List of tables Table: ASN.IBMSNAP_SUBS_COLS
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | WHOS_ON_FIRST | CHARACTER | 1 | 0 | 1251 | | | | |
| | TARGET_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | TARGET_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | COL_TYPE | CHARACTER | 1 | 0 | 1251 | | | | |
| | TARGET_NAME | VARCHAR | 30 | 0 | 1251 | | | | |
| | IS_KEY | CHARACTER | 1 | 0 | 1251 | | | | |
| | COLNO | SMALLINT | 2 | 0 | 0 | | | | |
| | EXPRESSION | VARCHAR | 254 | 0 | 1251 | | | | |
Total: 10 column(s) Indexes
| | ASN.IBMSNAP_SUBS_COLSX | UNIQUE | REGULAR | APPLY_QUAL, SET_NAME, WHOS_ON_FIRST, TARGET_OWNER, TARGET_TABLE, TARGET_NAME | |
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SUBS_COLS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"COL_TYPE" CHAR(1) NOT NULL ,
"TARGET_NAME" VARCHAR(30) NOT NULL ,
"IS_KEY" CHAR(1) NOT NULL ,
"COLNO" SMALLINT NOT NULL ,
"EXPRESSION" VARCHAR(254) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_COLSX" ON "ASN "."IBMSNAP_SUBS_COLS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC,
"TARGET_NAME" ASC);
List of tables Table: ASN.IBMSNAP_SUBS_EVENT
Properties
Columns
| | EVENT_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | EVENT_TIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | END_SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | END_OF_PERIOD | TIMESTAMP | 10 | 0 | 0 | | | | |
Total: 4 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SUBS_EVENT" (
"EVENT_NAME" CHAR(18) NOT NULL ,
"EVENT_TIME" TIMESTAMP NOT NULL ,
"END_SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"END_OF_PERIOD" TIMESTAMP )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_EVENX" ON "ASN "."IBMSNAP_SUBS_EVENT"
("EVENT_NAME" ASC,
"EVENT_TIME" ASC);
List of tables Table: ASN.IBMSNAP_SUBS_MEMBR
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | WHOS_ON_FIRST | CHARACTER | 1 | 0 | 1251 | | | | |
| | SOURCE_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | SOURCE_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | SOURCE_VIEW_QUAL | SMALLINT | 2 | 0 | 0 | | | | |
| | TARGET_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | TARGET_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
| | TARGET_CONDENSED | CHARACTER | 1 | 0 | 1251 | | | | |
| | TARGET_COMPLETE | CHARACTER | 1 | 0 | 1251 | | | | |
| | TARGET_STRUCTURE | SMALLINT | 2 | 0 | 0 | | | | |
| | PREDICATES | VARCHAR | 1024 | 0 | 1251 | | | | |
| | MEMBER_STATE | CHARACTER | 1 | 0 | 1251 | | | | |
| | TARGET_KEY_CHG | CHARACTER | 1 | 0 | 1251 | | | | |
| | UOW_CD_PREDICATES | VARCHAR | 1024 | 0 | 1251 | | | | |
| | JOIN_UOW_CD | CHARACTER | 1 | 0 | 1251 | | | | |
| | LOADX_TYPE | SMALLINT | 2 | 0 | 0 | | | | |
| | LOADX_SRC_N_OWNER | VARCHAR | 30 | 0 | 1251 | | | | |
| | LOADX_SRC_N_TABLE | VARCHAR | 128 | 0 | 1251 | | | | |
Total: 19 column(s) Indexes
| | ASN.IBMSNAP_SUBS_MEMBX | UNIQUE | REGULAR | APPLY_QUAL, SET_NAME, WHOS_ON_FIRST, SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, TARGET_OWNER, TARGET_TABLE | |
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SUBS_MEMBR" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"TARGET_CONDENSED" CHAR(1) NOT NULL ,
"TARGET_COMPLETE" CHAR(1) NOT NULL ,
"TARGET_STRUCTURE" SMALLINT NOT NULL ,
"PREDICATES" VARCHAR(1024) ,
"MEMBER_STATE" CHAR(1) ,
"TARGET_KEY_CHG" CHAR(1) NOT NULL ,
"UOW_CD_PREDICATES" VARCHAR(1024) ,
"JOIN_UOW_CD" CHAR(1) ,
"LOADX_TYPE" SMALLINT ,
"LOADX_SRC_N_OWNER" VARCHAR(30) ,
"LOADX_SRC_N_TABLE" VARCHAR(128) )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_MEMBX" ON "ASN "."IBMSNAP_SUBS_MEMBR"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC);
List of tables Table: ASN.IBMSNAP_SUBS_SET
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_TYPE | CHARACTER | 1 | 0 | 1251 | | | | |
| | WHOS_ON_FIRST | CHARACTER | 1 | 0 | 1251 | | | | |
| | ACTIVATE | SMALLINT | 2 | 0 | 0 | | | | |
| | SOURCE_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | SOURCE_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | TARGET_SERVER | CHARACTER | 18 | 0 | 1251 | | | | |
| | TARGET_ALIAS | CHARACTER | 8 | 0 | 1251 | | | | |
| | STATUS | SMALLINT | 2 | 0 | 0 | | | | |
| | LASTRUN | TIMESTAMP | 10 | 0 | 0 | | | | |
| | REFRESH_TYPE | CHARACTER | 1 | 0 | 1251 | | | | |
| | SLEEP_MINUTES | INTEGER | 4 | 0 | 0 | | | | |
| | EVENT_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | LASTSUCCESS | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SYNCHPOINT | CHARACTER | 10 | 0 | 0 | | | | |
| | SYNCHTIME | TIMESTAMP | 10 | 0 | 0 | | | | |
| | CAPTURE_SCHEMA | VARCHAR | 30 | 0 | 1251 | | | | |
| | TGT_CAPTURE_SCHEMA | VARCHAR | 30 | 0 | 1251 | | | | |
| | FEDERATED_SRC_SRVR | VARCHAR | 18 | 0 | 1251 | | | | |
| | FEDERATED_TGT_SRVR | VARCHAR | 18 | 0 | 1251 | | | | |
| | JRN_LIB | CHARACTER | 10 | 0 | 1251 | | | | |
| | JRN_NAME | CHARACTER | 10 | 0 | 1251 | | | | |
| | OPTION_FLAGS | CHARACTER | 4 | 0 | 1251 | | | | |
| | COMMIT_COUNT | SMALLINT | 2 | 0 | 0 | | | | |
| | MAX_SYNCH_MINUTES | SMALLINT | 2 | 0 | 0 | | | | |
| | AUX_STMTS | SMALLINT | 2 | 0 | 0 | | | | |
| | ARCH_LEVEL | CHARACTER | 4 | 0 | 1251 | | | | |
Total: 28 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SUBS_SET" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"SET_TYPE" CHAR(1) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"ACTIVATE" SMALLINT NOT NULL ,
"SOURCE_SERVER" CHAR(18) NOT NULL ,
"SOURCE_ALIAS" CHAR(8) ,
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_ALIAS" CHAR(8) ,
"STATUS" SMALLINT NOT NULL ,
"LASTRUN" TIMESTAMP NOT NULL ,
"REFRESH_TYPE" CHAR(1) NOT NULL ,
"SLEEP_MINUTES" INTEGER ,
"EVENT_NAME" CHAR(18) ,
"LASTSUCCESS" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"CAPTURE_SCHEMA" VARCHAR(30) NOT NULL ,
"TGT_CAPTURE_SCHEMA" VARCHAR(30) ,
"FEDERATED_SRC_SRVR" VARCHAR(18) ,
"FEDERATED_TGT_SRVR" VARCHAR(18) ,
"JRN_LIB" CHAR(10) ,
"JRN_NAME" CHAR(10) ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"COMMIT_COUNT" SMALLINT ,
"MAX_SYNCH_MINUTES" SMALLINT ,
"AUX_STMTS" SMALLINT NOT NULL ,
"ARCH_LEVEL" CHAR(4) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_SETX" ON "ASN "."IBMSNAP_SUBS_SET"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC);
List of tables Table: ASN.IBMSNAP_SUBS_STMTS
Properties
Columns
| | APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | | |
| | SET_NAME | CHARACTER | 18 | 0 | 1251 | | | | |
| | WHOS_ON_FIRST | CHARACTER | 1 | 0 | 1251 | | | | |
| | BEFORE_OR_AFTER | CHARACTER | 1 | 0 | 1251 | | | | |
| | STMT_NUMBER | SMALLINT | 2 | 0 | 0 | | | | |
| | EI_OR_CALL | CHARACTER | 1 | 0 | 1251 | | | | |
| | SQL_STMT | VARCHAR | 1024 | 0 | 1251 | | | | |
| | ACCEPT_SQLSTATES | VARCHAR | 50 | 0 | 1251 | | | | |
Total: 8 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_SUBS_STMTS" (
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"WHOS_ON_FIRST" CHAR(1) NOT NULL ,
"BEFORE_OR_AFTER" CHAR(1) NOT NULL ,
"STMT_NUMBER" SMALLINT NOT NULL ,
"EI_OR_CALL" CHAR(1) NOT NULL ,
"SQL_STMT" VARCHAR(1024) ,
"ACCEPT_SQLSTATES" VARCHAR(50) )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_STMTX" ON "ASN "."IBMSNAP_SUBS_STMTS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"BEFORE_OR_AFTER" ASC,
"STMT_NUMBER" ASC);
List of tables Table: ASN.IBMSNAP_UOW
Properties
Columns
| | IBMSNAP_UOWID | CHARACTER | 10 | 0 | 0 | | | | |
| | IBMSNAP_COMMITSEQ | CHARACTER | 10 | 0 | 0 | | | | |
| | IBMSNAP_LOGMARKER | TIMESTAMP | 10 | 0 | 0 | | | | |
| | IBMSNAP_AUTHTKN | VARCHAR | 30 | 0 | 1251 | | | | |
| | IBMSNAP_AUTHID | VARCHAR | 30 | 0 | 1251 | | | | |
| | IBMSNAP_REJ_CODE | CHARACTER | 1 | 0 | 1251 | | | ' ' | |
| | IBMSNAP_APPLY_QUAL | CHARACTER | 18 | 0 | 1251 | | | ' ' | |
Total: 7 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "ASN "."IBMSNAP_UOW" (
"IBMSNAP_UOWID" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_COMMITSEQ" CHAR(10) FOR BIT DATA NOT NULL ,
"IBMSNAP_LOGMARKER" TIMESTAMP NOT NULL ,
"IBMSNAP_AUTHTKN" VARCHAR(30) NOT NULL ,
"IBMSNAP_AUTHID" VARCHAR(30) NOT NULL ,
"IBMSNAP_REJ_CODE" CHAR(1) NOT NULL WITH DEFAULT ,
"IBMSNAP_APPLY_QUAL" CHAR(18) NOT NULL WITH DEFAULT )
IN "TSASNUOW" ;
ALTER TABLE "ASN "."IBMSNAP_UOW" VOLATILE CARDINALITY;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_UOWX" ON "ASN "."IBMSNAP_UOW"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_LOGMARKER" ASC);
List of tables Table: USER.IN_TRAY
Properties
Columns
| | RECEIVED | TIMESTAMP | 10 | 0 | 0 | | | | |
| | SOURCE | CHARACTER | 8 | 0 | 1251 | | | | |
| | SUBJECT | CHARACTER | 64 | 0 | 1251 | | | | |
| | NOTE_TEXT | VARCHAR | 3000 | 0 | 1251 | | | | |
Total: 4 column(s) Autherisations
| | 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 "."IN_TRAY" (
"RECEIVED" TIMESTAMP ,
"SOURCE" CHAR(8) ,
"SUBJECT" CHAR(64) ,
"NOTE_TEXT" VARCHAR(3000) )
IN "USERSPACE1" ;
List of tables Table: USER.ORG
Properties
Columns
| | DEPTNUMB | SMALLINT | 2 | 0 | 0 | | | | |
| | DEPTNAME | VARCHAR | 14 | 0 | 1251 | | | | |
| | MANAGER | SMALLINT | 2 | 0 | 0 | | | | |
| | DIVISION | VARCHAR | 10 | 0 | 1251 | | | | |
| | LOCATION | VARCHAR | 13 | 0 | 1251 | | | | |
Total: 5 column(s) Indexes
Total: 1 index(s) Autherisations
| | 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 "."ORG" (
"DEPTNUMB" SMALLINT NOT NULL ,
"DEPTNAME" VARCHAR(14) ,
"MANAGER" SMALLINT ,
"DIVISION" VARCHAR(10) ,
"LOCATION" VARCHAR(13) )
IN "USERSPACE1" ;
ALTER TABLE "USER "."ORG"
ADD CONSTRAINT "CC1151755924953" PRIMARY KEY
("DEPTNUMB");
List of tables Table: USER.PROJECT
Properties
Columns
| | PROJNO | CHARACTER | 6 | 0 | 1251 | | | | |
| | PROJNAME | VARCHAR | 24 | 0 | 1251 | | | | |
| | DEPTNO | CHARACTER | 3 | 0 | 1251 | | | | |
| | RESPEMP | CHARACTER | 6 | 0 | 1251 | | | | |
| | PRSTAFF | DECIMAL | 5 | 2 | 0 | | | | |
| | PRSTDATE | DATE | 4 | 0 | 0 | | | | |
| | PRENDATE | DATE | 4 | 0 | 0 | | | | |
| | MAJPROJ | CHARACTER | 6 | 0 | 1251 | | | | |
Total: 8 column(s) Autherisations
| | 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 "."PROJECT" (
"PROJNO" CHAR(6) NOT NULL ,
"PROJNAME" VARCHAR(24) NOT NULL ,
"DEPTNO" CHAR(3) NOT NULL ,
"RESPEMP" CHAR(6) NOT NULL ,
"PRSTAFF" DECIMAL(5,2) ,
"PRSTDATE" DATE ,
"PRENDATE" DATE ,
"MAJPROJ" CHAR(6) )
IN "USERSPACE1" ;
List of tables Table: USER.SALES
Properties
Columns
| | SALES_DATE | DATE | 4 | 0 | 0 | | | | |
| | SALES_PERSON | VARCHAR | 15 | 0 | 1251 | | | | |
| | REGION | VARCHAR | 15 | 0 | 1251 | | | | |
| | SALES | INTEGER | 4 | 0 | 0 | | | | |
Total: 4 column(s) Autherisations
| | 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 "."SALES" (
"SALES_DATE" DATE ,
"SALES_PERSON" VARCHAR(15) ,
"REGION" VARCHAR(15) ,
"SALES" INTEGER )
DATA CAPTURE CHANGES
IN "USERSPACE1" ;
List of tables Table: USER.STAFF
Properties
Columns
| | ID | SMALLINT | 2 | 0 | 0 | | | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | | | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | | | |
Total: 7 column(s) Indexes
Total: 1 index(s) Triggers
Total: 1 trigger(s) Dependent objects
Total: 1 dependent object(s) Autherisations
| | 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 "."STAFF" (
"ID" SMALLINT NOT NULL ,
"NAME" VARCHAR(9) ,
"DEPT" SMALLINT ,
"JOB" CHAR(5) ,
"YEARS" SMALLINT ,
"SALARY" DECIMAL(7,2) ,
"COMM" DECIMAL(7,2) )
DATA CAPTURE CHANGES
IN "USERSPACE1" ;
ALTER TABLE "USER "."STAFF"
ADD CONSTRAINT "CC1151755626422" PRIMARY KEY
("ID");
List of tables Indexes
Index: USER.CC1151754616344
Properties
Columns
| | TABLE_CATALOG | ASCENDING |
| | TABLE_SCHEMA | ASCENDING |
| | TABLE_NAME | ASCENDING |
| | COLUMN_NAME | ASCENDING |
Total: 4 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.CC1151754705266
Properties
Columns
| | CONSTRAINT_CATALOG | ASCENDING |
| | CONSTRAINT_SCHEMA | ASCENDING |
| | CONSTRAINT_NAME | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.CC1151755626422
Properties
Columns
| | ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
ALTER TABLE "USER "."STAFF"
ADD CONSTRAINT "CC1151755626422" PRIMARY KEY
("ID");
List of indexes Index: USER.CC11517556264220
Properties
Columns
| | ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.CC11517556264221
Properties
Columns
| | ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.CC1151755924953
Properties
Columns
| | DEPTNUMB | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
ALTER TABLE "USER "."ORG"
ADD CONSTRAINT "CC1151755924953" PRIMARY KEY
("DEPTNUMB");
List of indexes Index: USER.CC1151778928062
Properties
Columns
| | EMPNO | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
ALTER TABLE "USER "."EMPLOYEE"
ADD CONSTRAINT "CC1151778928062" PRIMARY KEY
("EMPNO");
List of indexes Index: ASN.IBMSNAP_APPENQX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_APPENQX" ON "ASN "."IBMSNAP_APPENQ"
("APPLY_QUAL" ASC);
List of indexes Index: ASN.IBMSNAP_APPLYTRACX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | TRACE_TIME | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_APPLYTRACX" ON "ASN "."IBMSNAP_APPLYTRACE"
("APPLY_QUAL" ASC,
"TRACE_TIME" ASC);
List of indexes Index: ASN.IBMSNAP_APPLYTRLX
Properties
Columns
| | LASTRUN | DESCENDING |
| | APPLY_QUAL | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_APPLYTRLX" ON "ASN "."IBMSNAP_APPLYTRAIL"
("LASTRUN" DESC,
"APPLY_QUAL" ASC);
List of indexes Index: ASN.IBMSNAP_APPPARMSX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_APPPARMSX" ON "ASN "."IBMSNAP_APPPARMS"
("APPLY_QUAL" ASC);
List of indexes Index: ASN.IBMSNAP_CAPMONX
Properties
Columns
| | MONITOR_TIME | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_CAPMONX" ON "ASN "."IBMSNAP_CAPMON"
("MONITOR_TIME" ASC);
List of indexes Index: ASN.IBMSNAP_CAPSCHEMAX
Properties
Columns
| | CAP_SCHEMA_NAME | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_CAPSCHEMAX" ON "ASN "."IBMSNAP_CAPSCHEMAS"
("CAP_SCHEMA_NAME" ASC);
List of indexes Index: ASN.IBMSNAP_CAPTRACEX
Properties
Columns
| | TRACE_TIME | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_CAPTRACEX" ON "ASN "."IBMSNAP_CAPTRACE"
("TRACE_TIME" ASC);
List of indexes Index: ASN.IBMSNAP_COMPENSATX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | MEMBER | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_COMPENSATX" ON "ASN "."IBMSNAP_COMPENSATE"
("APPLY_QUAL" ASC,
"MEMBER" ASC);
List of indexes Index: ASN.IBMSNAP_PRUNCNTLX
Properties
Columns
| | SOURCE_OWNER | ASCENDING |
| | SOURCE_TABLE | ASCENDING |
| | SOURCE_VIEW_QUAL | ASCENDING |
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | TARGET_SERVER | ASCENDING |
| | TARGET_TABLE | ASCENDING |
| | TARGET_OWNER | ASCENDING |
Total: 8 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX" ON "ASN "."IBMSNAP_PRUNCNTL"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC,
"TARGET_TABLE" ASC,
"TARGET_OWNER" ASC);
List of indexes Index: ASN.IBMSNAP_PRUNCNTLX1
Properties
Columns
| | MAP_ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX1" ON "ASN "."IBMSNAP_PRUNCNTL"
("MAP_ID" ASC);
List of indexes Index: ASN.IBMSNAP_PRUNCNTLX2
Properties
Columns
| | PHYS_CHANGE_OWNER | ASCENDING |
| | PHYS_CHANGE_TABLE | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX2" ON "ASN "."IBMSNAP_PRUNCNTL"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
List of indexes Index: ASN.IBMSNAP_PRUNCNTLX3
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | TARGET_SERVER | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX3" ON "ASN "."IBMSNAP_PRUNCNTL"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC);
List of indexes Index: ASN.IBMSNAP_PRUNE_SETX
Properties
Columns
| | TARGET_SERVER | ASCENDING |
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNE_SETX" ON "ASN "."IBMSNAP_PRUNE_SET"
("TARGET_SERVER" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC);
List of indexes Index: ASN.IBMSNAP_REGISTERX
Properties
Columns
| | SOURCE_OWNER | ASCENDING |
| | SOURCE_TABLE | ASCENDING |
| | SOURCE_VIEW_QUAL | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_REGISTERX" ON "ASN "."IBMSNAP_REGISTER"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC);
List of indexes Index: ASN.IBMSNAP_REGISTERX1
Properties
Columns
| | PHYS_CHANGE_OWNER | ASCENDING |
| | PHYS_CHANGE_TABLE | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_REGISTERX1" ON "ASN "."IBMSNAP_REGISTER"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
List of indexes Index: ASN.IBMSNAP_REGISTERX2
Properties
Columns
| | GLOBAL_RECORD | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "ASN "."IBMSNAP_REGISTERX2" ON "ASN "."IBMSNAP_REGISTER"
("GLOBAL_RECORD" ASC);
List of indexes Index: ASN.IBMSNAP_SIGNALX
Properties
Columns
| | SIGNAL_TIME | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SIGNALX" ON "ASN "."IBMSNAP_SIGNAL"
("SIGNAL_TIME" ASC);
List of indexes Index: ASN.IBMSNAP_SUBS_COLSX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | WHOS_ON_FIRST | ASCENDING |
| | TARGET_OWNER | ASCENDING |
| | TARGET_TABLE | ASCENDING |
| | TARGET_NAME | ASCENDING |
Total: 6 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_COLSX" ON "ASN "."IBMSNAP_SUBS_COLS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC,
"TARGET_NAME" ASC);
List of indexes Index: ASN.IBMSNAP_SUBS_EVENX
Properties
Columns
| | EVENT_NAME | ASCENDING |
| | EVENT_TIME | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_EVENX" ON "ASN "."IBMSNAP_SUBS_EVENT"
("EVENT_NAME" ASC,
"EVENT_TIME" ASC);
List of indexes Index: ASN.IBMSNAP_SUBS_MEMBX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | WHOS_ON_FIRST | ASCENDING |
| | SOURCE_OWNER | ASCENDING |
| | SOURCE_TABLE | ASCENDING |
| | SOURCE_VIEW_QUAL | ASCENDING |
| | TARGET_OWNER | ASCENDING |
| | TARGET_TABLE | ASCENDING |
Total: 8 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_MEMBX" ON "ASN "."IBMSNAP_SUBS_MEMBR"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"TARGET_OWNER" ASC,
"TARGET_TABLE" ASC);
List of indexes Index: ASN.IBMSNAP_SUBS_SETX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | WHOS_ON_FIRST | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_SETX" ON "ASN "."IBMSNAP_SUBS_SET"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC);
List of indexes Index: ASN.IBMSNAP_SUBS_STMTX
Properties
Columns
| | APPLY_QUAL | ASCENDING |
| | SET_NAME | ASCENDING |
| | WHOS_ON_FIRST | ASCENDING |
| | BEFORE_OR_AFTER | ASCENDING |
| | STMT_NUMBER | ASCENDING |
Total: 5 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_STMTX" ON "ASN "."IBMSNAP_SUBS_STMTS"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC,
"BEFORE_OR_AFTER" ASC,
"STMT_NUMBER" ASC);
List of indexes Index: ASN.IBMSNAP_UOWX
Properties
Columns
| | IBMSNAP_COMMITSEQ | ASCENDING |
| | IBMSNAP_LOGMARKER | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "ASN "."IBMSNAP_UOWX" ON "ASN "."IBMSNAP_UOW"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_LOGMARKER" ASC);
List of indexes Index: USER.IXCDSTAFF
Properties
Columns
| | IBMSNAP_COMMITSEQ | ASCENDING |
| | IBMSNAP_INTENTSEQ | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "USER "."IXCDSTAFF" ON "USER "."CDSTAFF"
("IBMSNAP_COMMITSEQ" ASC,
"IBMSNAP_INTENTSEQ" ASC)
PCTFREE 0 ;
List of indexes Index: USER.IXNICK_STAFF_MQT
Properties
Columns
| | ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.IXQQQ_STAFF_MQT
Properties
Columns
| | ID | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
List of indexes Index: USER.PK_ACT
Properties
Columns
| | ACTNO | ASCENDING |
Total: 1 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
ALTER TABLE "USER "."ACT"
ADD CONSTRAINT "PK_ACT" PRIMARY KEY
("ACTNO");
List of indexes Index: SYSIBM.SQL060616220800090
Properties
Columns
| | EMPNO | ASCENDING |
| | PHOTO_FORMAT | ASCENDING |
Total: 2 column(s) SQL
List of indexes Index: SYSIBM.SQL060616220803090
Properties
Columns
| | EMPNO | ASCENDING |
| | RESUME_FORMAT | ASCENDING |
Total: 2 column(s) SQL
List of indexes Index: USER.XACT2
Properties
Columns
| | ACTNO | ASCENDING |
| | ACTKWD | ASCENDING |
Total: 2 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE UNIQUE INDEX "USER "."XACT2" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC) ALLOW REVERSE SCANS;
List of indexes Index: USER.XACT3
Properties
Columns
| | ACTNO | ASCENDING |
| | ACTKWD | ASCENDING |
| | ACTDESC | ASCENDING |
Total: 3 column(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD |
Total: 1 autherisation(s) SQL
CREATE INDEX "USER "."XACT3" ON "USER "."ACT"
("ACTNO" ASC,
"ACTKWD" ASC,
"ACTDESC" ASC) ALLOW REVERSE SCANS;
List of indexes Constraints
Constraint: CC1151413049172
Properties
| CC1151413049172 |
| USER |
| USER.ACT |
| 27.06.2006 |
| USER |
| |
| ACTNO >1000 |
Columns
| | ACTNO |
Total: 1 column(s) SQL
ACTNO >1000
List of constraints Constraint: CC1151754626766
Properties
Columns
| | TABLE_SCHEMA |
Total: 1 column(s) SQL
TABLE_SCHEMA is not null
List of constraints Constraint: CC1151754741688
Properties
Columns
| | CONSTRAINT_NAME |
Total: 1 column(s) SQL
CONSTRAINT_NAME is not null
List of constraints Views
View: USER.AAAAAAAAAAAA
Properties
| AAAAAAAAAAAA |
| USER |
| USER |
| |
| |
| USER |
| |
Columns
| | CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 | | |
| | CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | |
| | CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 | | |
| | CHECK_CLAUSE | CLOB | 2097152 | 0 | 1251 | | |
Total: 4 column(s) Depend on objects
Total: 1 object(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD, ALTER=NOT_HELD, DELETE=NOT_HELD, INDEX=NOT_HELD, INSERT=NOT_HELD, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=NOT_HELD |
Total: 1 autherisation(s) SQL
CREATE view "USER".AAAAAAAAAAAA as SELECT * FROM NICK_CHECK_CONSTRAINTS
List of views View: USER.VDEPT
Properties
| VDEPT |
| USER |
| USER |
| |
| |
| USER |
| |
Columns
| | DEPTNO | CHARACTER | 3 | 0 | 1251 | | |
| | DEPTNAME | VARCHAR | 29 | 0 | 1251 | | |
| | MGRNO | CHARACTER | 6 | 0 | 1251 | | |
| | ADMRDEPT | CHARACTER | 3 | 0 | 1251 | | |
Total: 4 column(s) Depend on objects
Total: 2 object(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD, ALTER=NOT_HELD, DELETE=HELD_GRANTABLE, INDEX=NOT_HELD, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE VIEW VDEPT AS SELECT ALL DEPTNO, DEPTNAME, MGRNO, ADMRDEPT FROM DEPT
List of views View: USER.VHDEPT
Properties
| VHDEPT |
| USER |
| USER |
| |
| |
| USER |
| |
Columns
| | DEPTNO | CHARACTER | 3 | 0 | 1251 | | |
| | DEPTNAME | VARCHAR | 29 | 0 | 1251 | | |
| | MGRNO | CHARACTER | 6 | 0 | 1251 | | |
| | ADMRDEPT | CHARACTER | 3 | 0 | 1251 | | |
| | LOCATION | CHARACTER | 16 | 0 | 1251 | | |
Total: 5 column(s) Depend on objects
Total: 2 object(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD, ALTER=NOT_HELD, DELETE=HELD_GRANTABLE, INDEX=NOT_HELD, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE VIEW VHDEPT AS SELECT ALL DEPTNO , DEPTNAME, MGRNO , ADMRDEPT, LOCATION FROM DEPT
List of views Aliases
Alias: USER.DEPT
Properties
Dependent objects
Total: 2 dependent object(s) SQL
CREATE ALIAS "USER "."DEPT" FOR "USER "."DEPARTMENT";
COMMENT ON ALIAS "USER "."DEPT" IS 'sddddddddd';
List of aliases Alias: USER.EMP
Properties
SQL
CREATE ALIAS "USER "."EMP" FOR "USER "."EMPLOYEE";
List of aliases Nicknames
Nickname: USER.NICK_CHECK_CONSTRAINTS
Properties
| NICK_CHECK_CONSTRAINTS |
| USER |
| CONNECT |
| TEST |
| SYSIBM |
| CHECK_CONSTRAINTS |
| |
| |
| |
| NORMAL |
| 01.07.2006 |
| |
Columns
| | CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHECK_CLAUSE | CLOB | 2097152 | 0 | 1251 | | | | |
Total: 4 column(s) Indexes
Total: 1 index(s) Constraints
Total: 1 constraint(s) Dependent objects
Total: 1 dependent object(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_COLUMNS
Properties
Columns
| | TABLE_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | TABLE_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | TABLE_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLUMN_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | ORDINAL_POSITION | INTEGER | 4 | 0 | 0 | | | | |
| | COLUMN_DEFAULT | VARCHAR | 2000 | 0 | 1251 | | | | |
| | IS_NULLABLE | VARCHAR | 3 | 0 | 1251 | | | | |
| | DATA_TYPE | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHARACTER_MAXIMUM_LENGTH | INTEGER | 4 | 0 | 0 | | | | |
| | CHARACTER_OCTET_LENGTH | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_PRECISION_RADIX | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_SCALE | INTEGER | 4 | 0 | 0 | | | | |
| | DATETIME_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | INTERVAL_TYPE | VARCHAR | 128 | 0 | 1251 | | | | |
| | INTERVAL_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | CHARACTER_SET_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHARACTER_SET_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHARACTER_SET_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | MAXIMUM_CARDINALITY | INTEGER | 4 | 0 | 0 | | | | |
| | DTD_IDENTIFIER | VARCHAR | 128 | 0 | 1251 | | | | |
| | IS_SELF_REFERENCING | VARCHAR | 3 | 0 | 1251 | | | | |
Total: 34 column(s) Indexes
Total: 1 index(s) Constraints
Total: 1 constraint(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_COLUMNS_S
Properties
Columns
| | TABLE_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | TABLE_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | TABLE_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLUMN_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | ORDINAL_POSITION | INTEGER | 4 | 0 | 0 | | | | |
| | COLUMN_DEFAULT | VARCHAR | 2000 | 0 | 1251 | | | | |
| | IS_NULLABLE | VARCHAR | 3 | 0 | 1251 | | | | |
| | DATA_TYPE | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHAR_MAX_LENGTH | INTEGER | 4 | 0 | 0 | | | | |
| | CHAR_OCTET_LENGTH | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_PREC_RADIX | INTEGER | 4 | 0 | 0 | | | | |
| | NUMERIC_SCALE | INTEGER | 4 | 0 | 0 | | | | |
| | DATETIME_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | INTERVAL_TYPE | VARCHAR | 128 | 0 | 1251 | | | | |
| | INTERVAL_PRECISION | INTEGER | 4 | 0 | 0 | | | | |
| | CHAR_SET_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHAR_SET_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | CHARACTER_SET_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | COLLATION_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | DOMAIN_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | UDT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | SCOPE_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | MAX_CARDINALITY | INTEGER | 4 | 0 | 0 | | | | |
| | DTD_IDENTIFIER | VARCHAR | 128 | 0 | 1251 | | | | |
| | IS_SELF_REF | VARCHAR | 3 | 0 | 1251 | | | | |
Total: 34 column(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_REF_CONSTRAINTS
Properties
| NICK_REF_CONSTRAINTS |
| USER |
| CONNECT |
| TEST |
| SYSIBM |
| REF_CONSTRAINTS |
| |
| |
| |
| NORMAL |
| 01.07.2006 |
| |
Columns
| | CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTR_CAT | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTR_SCH | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTR_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | MATCH_OPTION | VARCHAR | 4 | 0 | 1251 | | | | |
| | UPDATE_RULE | VARCHAR | 9 | 0 | 1251 | | | | |
| | DELETE_RULE | VARCHAR | 9 | 0 | 1251 | | | | |
Total: 9 column(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_REFERENTIAL_CONSTRAINTS
Properties
| NICK_REFERENTIAL_CONSTRAINTS |
| USER |
| CONNECT |
| TEST |
| SYSIBM |
| REFERENTIAL_CONSTRAINTS |
| |
| |
| |
| NORMAL |
| 01.07.2006 |
| |
Columns
| | CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTRAINT_CATALOG | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTRAINT_SCHEMA | VARCHAR | 128 | 0 | 1251 | | | | |
| | UNIQUE_CONSTRAINT_NAME | VARCHAR | 128 | 0 | 1251 | | | | |
| | MATCH_OPTION | VARCHAR | 4 | 0 | 1251 | | | | |
| | UPDATE_RULE | VARCHAR | 9 | 0 | 1251 | | | | |
| | DELETE_RULE | VARCHAR | 9 | 0 | 1251 | | | | |
Total: 9 column(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_SALES
Properties
Columns
| | SALES_DATE | DATE | 4 | 0 | 0 | | | | |
| | SALES_PERSON | VARCHAR | 15 | 0 | 1251 | | | | |
| | REGION | VARCHAR | 15 | 0 | 1251 | | | | |
| | SALES | INTEGER | 4 | 0 | 0 | | | | |
Total: 4 column(s) Autherisations
| | 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)List of nicknames Nickname: USER.NICK_STAFF
Properties
Columns
| | ID | SMALLINT | 2 | 0 | 0 | | | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | | | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | | | |
Total: 7 column(s) Indexes
Total: 1 index(s) Dependent objects
Total: 1 dependent object(s) Autherisations
| | 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)List of nicknames Nickname: USER.QQQ_STAFF
Properties
Columns
| | ID | SMALLINT | 2 | 0 | 0 | | | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | | | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | | | |
Total: 7 column(s) Indexes
Total: 1 index(s) Referenced tables
Total: 1 referenced table(s) Dependent objects
Total: 1 dependent object(s) Autherisations
| | 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)List of nicknames Foreign keys
Foreign key: CC1152703301094
Properties
SQL
List of foreign keys Materialised views
Materialised view: USER.NICK_STAFF_MQT
Properties
Columns
| | ID | SMALLINT | 2 | 0 | 0 | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | |
Total: 7 column(s) Depend on objects
Total: 1 object(s) Autherisations
| | 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.NICK_STAFF_MQT AS (SELECT * FROM "USER".NICK_STAFF) DATA INITIALLY DEFERRED REFRESH DEFERRED MAINTAINED BY FEDERATED_TOOL IN NICK_STAFF_MQT_TS
List of materialised views Materialised view: USER.QQQ_STAFF_MQT
Properties
Columns
| | ID | SMALLINT | 2 | 0 | 0 | | |
| | NAME | VARCHAR | 9 | 0 | 1251 | | |
| | DEPT | SMALLINT | 2 | 0 | 0 | | |
| | JOB | CHARACTER | 5 | 0 | 1251 | | |
| | YEARS | SMALLINT | 2 | 0 | 0 | | |
| | SALARY | DECIMAL | 7 | 2 | 0 | | |
| | COMM | DECIMAL | 7 | 2 | 0 | | |
Total: 7 column(s) Depend on objects
Total: 1 object(s) Autherisations
| | 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.QQQ_STAFF_MQT AS (SELECT * FROM "USER".QQQ_STAFF) DATA INITIALLY DEFERRED REFRESH DEFERRED MAINTAINED BY FEDERATED_TOOL IN QQQ_STAFF_MQT_TS
List of materialised views Triggers
Trigger: USER.TR_STAFF_BEFORE
Properties
| TR_STAFF_BEFORE |
| USER |
| USER |
| USER |
| STAFF |
| |
| BEFORE |
| DELETE |
| ROW |
| 24.06.2006 |
| USER |
| |
SQL
CREATE TRIGGER "USER".TR_STAFF_BEFORE NO CASCADE BEFORE DELETE ON "USER".STAFF REFERENCING OLD AS OLDSTAFF FOR EACH ROW MODE DB2SQL
WHEN(oldstaff.job = 'Sales') BEGIN
ATOMIC SIGNAL SQLSTATE '75000' ('Sales staff cannot be deleted... see the DO_NOT_DEL_SALES trigger.');
END
List of triggers Procedures
Procedure: USER.BONUS_INCREASE
Properties
| BONUS_INCREASE |
| USER |
| USER |
| BONUS_INCREASE |
| |
| 24.06.2006 |
| 24.06.2006 |
| |
| SQL |
| USER |
| |
Parameters
 | P_BONUSFACTOR | IN | DECIMAL | 3 | 2 | 0 | |
| | P_BONUSMAXSUMFORDEPT | IN | DECIMAL | 9 | 2 | 0 | |
 | P_DEPTSWITHOUTNEWBONUSES | OUT | VARCHAR | 255 | 0 | 1251 | |
| | P_COUNTDEPTSVIEWED | OUT | INTEGER | 4 | 0 | 0 | |
| | P_COUNTDEPTSBONUSCHANGED | OUT | INTEGER | 4 | 0 | 0 | |
| | P_ERRORMSG | OUT | VARCHAR | 255 | 0 | 1251 | |
Total: 6 parameter(s) Depend on objects
| | USER.P4434996 |
Total: 1 object(s) Autherisations
| | SYSIBM | USER | EXECUTE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE PROCEDURE bonus_increase (IN p_bonusFactor
DECIMAL (3,2), IN p_bonusMaxSumForDept DECIMAL
(9,2), OUT p_deptsWithoutNewBonuses VARCHAR(255),
OUT p_countDeptsViewed INTEGER,
OUT p_countDeptsBonusChanged INTEGER,
OUT p_errorMsg VARCHAR(255)) SPECIFIC BONUS_INCREASE
LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE v_dept, v_actdept CHAR(3);--
DECLARE v_bonus, v_deptbonus, v_newbonus DECIMAL(9,2);--
DECLARE v_empno CHAR(6);--
DECLARE v_atend SMALLINT DEFAULT 0;--
RETURN -1;--
END
List of procedures Functions
Function: USER.RESIGN_EMPLOYEE
Properties
| RESIGN_EMPLOYEE |
| USER |
| USER |
| SQL060624144124500 |
| |
| 24.06.2006 |
| 24.06.2006 |
| USER |
| |
| SQL |
| |
Parameters
| | EMPNO | BEFORE CASTING | CHARACTER | 6 | 0 | 1251 | |
| | NUMBER | IN | CHARACTER | 6 | 0 | 1251 | |
| | SALARY | BEFORE CASTING | DOUBLE | 8 | 0 | 0 | |
| | DEPT | BEFORE CASTING | CHARACTER | 3 | 0 | 1251 | |
Total: 4 parameter(s) SQL
CREATE FUNCTION resign_employee (number CHAR(6))
RETURNS TABLE (empno CHAR(6),
salary DOUBLE,
dept CHAR(3))
MODIFIES SQL DATA
LANGUAGE SQL
BEGIN ATOMIC
DECLARE l_salary DOUBLE;--
DECLARE l_job CHAR(3);--
RETURN VALUES (number,l_salary, l_job);--
END
List of functions Packages
Package: USER.P4434996
Properties
| P4434996 |
| USER |
| USER |
| USER |
| USER |
| |
| |
| 24.06.2006 |
| |
Dependent objects
Total: 1 dependent object(s) Autherisations
| | SYSIBM | USER | CONTROL=HELD, BIND=HELD_GRANTABLE, EXECUTE=HELD_GRANTABLE |
Total: 1 autherisation(s)List of packages Datatypes
Datatype: USER.NEW_TYPE2
Properties
| NEW_TYPE2 |
| USER |
| USER |
| SYSIBM |
| SMALLINT |
| 2 |
| 0 |
| 0 |
| |
| 0 |
| |
| 24.06.2006 |
| |
| |
SQL
CREATE DISTINCT TYPE "USER "."NEW_TYPE2" AS "SYSIBM ".SMALLINT
WITH COMPARISONS;
List of datatypes Datatype: USER.PERSON_T
Properties
| PERSON_T |
| USER |
| USER |
| SYSIBM |
| VARCHAR |
| 13 |
| 0 |
| 0 |
| |
| 74 |
| 74 |
| 24.06.2006 |
| |
| |
SQL
CREATE TYPE "USER "."PERSON_T" AS
("NAME" VARCHAR(20),
"AGE" INTEGER)
INSTANTIABLE
INLINE LENGTH 74
WITHOUT COMPARISONS
NOT FINAL
REF USING VARCHAR(13) FOR BIT DATA
MODE DB2SQL;
List of datatypes Sequences
Sequence: USER.SAMPSEQUENCE
Properties
| SAMPSEQUENCE |
| USER |
| USER |
| USER |
| 1 |
| 1 |
| 9223372036854775807 |
| 1 |
| |
| |
| 20 |
| 24.06.2006 |
| 24.06.2006 |
| |
Autherisations
| | SYSIBM | USER | USAGE=HELD_GRANTABLE, ALTER=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE SEQUENCE "USER "."SAMPSEQUENCE" AS BIGINT
MINVALUE 1 MAXVALUE 9223372036854775807
START WITH 1 INCREMENT BY 1
CACHE 20 NO CYCLE NO ORDER;
List of sequences Tablespaces
Tablespace: NICK_STAFF_MQT_TS
Properties
| NICK_STAFF_MQT_TS |
| USER |
| 01.07.2006 |
| 8 |
| 8 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE NICK_STAFF_MQT_TS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM
USING ('C:\DB2\NODE0000\SQL00001\NICK_STAFF_MQT_TS')
EXTENTSIZE 8
PREFETCHSIZE 8
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: QQQ_STAFF_MQT_TS
Properties
| QQQ_STAFF_MQT_TS |
| USER |
| 01.07.2006 |
| 8 |
| 8 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE QQQ_STAFF_MQT_TS IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM
USING ('C:\DB2\NODE0000\SQL00001\QQQ_STAFF_MQT_TS')
EXTENTSIZE 8
PREFETCHSIZE 8
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
ALTER TABLESPACE SYSCATSPACE
PREFETCHSIZE AUTOMATIC
OVERHEAD 12.670000
TRANSFERRATE 0.180000;
ALTER TABLESPACE TEMPSPACE1
PREFETCHSIZE AUTOMATIC
OVERHEAD 12.670000
TRANSFERRATE 0.180000;
ALTER TABLESPACE USERSPACE1
PREFETCHSIZE AUTOMATIC
OVERHEAD 12.670000
TRANSFERRATE 0.180000;
List of tablespaces Tablespace: SYSCATSPACE
Properties
| SYSCATSPACE |
| SYSIBM |
| 16.06.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMCATGROUP |
| IBMDEFAULTBP |
| |
| |
SQL
List of tablespaces Tablespace: SYSTOOLSPACE
Properties
| SYSTOOLSPACE |
| DB2ADMIN |
| 24.06.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMCATGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE SYSTOOLSPACE IN DATABASE PARTITION GROUP IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM
USING ('C:\DB2\NODE0000\SQL00001\SYSTOOLSPACE')
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: TEMPSPACE1
Properties
| TEMPSPACE1 |
| SYSIBM |
| 16.06.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMTEMPGROUP |
| IBMDEFAULTBP |
| |
| |
SQL
List of tablespaces Tablespace: TSASNAA
Properties
| TSASNAA |
| USER |
| 01.07.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE TSASNAA IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
USING (FILE 'C:\DB2\NODE0000\SQL00001\TSASNAA'2560)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: TSASNCA
Properties
| TSASNCA |
| USER |
| 01.07.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE TSASNCA IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
USING (FILE 'C:\DB2\NODE0000\SQL00001\TSASNCA'2560)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: TSASNUOW
Properties
| TSASNUOW |
| USER |
| 01.07.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE TSASNUOW IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
USING (FILE 'C:\DB2\NODE0000\SQL00001\TSASNUOW'2560)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: TSCDSTAFF
Properties
| TSCDSTAFF |
| USER |
| 01.07.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
| | SYSIBM | USER | USE=HELD_GRANTABLE |
Total: 1 autherisation(s) SQL
CREATE REGULAR TABLESPACE TSCDSTAFF IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
USING (FILE 'C:\DB2\NODE0000\SQL00001\CDSTAFF'512)
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 12.670000
TRANSFERRATE 0.180000
DROPPED TABLE RECOVERY ON;
List of tablespaces Tablespace: USERSPACE1
Properties
| USERSPACE1 |
| SYSIBM |
| 16.06.2006 |
| 32 |
| -1 |
| 12,67 |
| 0,18 |
| 4096 |
| IBMDEFAULTGROUP |
| IBMDEFAULTBP |
| |
| |
Autherisations
Total: 1 autherisation(s) SQL
List of tablespaces Schemas
Schema: ASN
Properties
| ASN |
| SYSIBM |
| USER |
| 01.07.2006 |
| |
Autherisations
| | SYSIBM | PUBLIC | ALTER=NOT_HELD, CREATE=HELD, DROP=NOT_HELD |
Total: 1 autherisation(s)List of schemas Schema: NULLID
Properties
| NULLID |
| SYSIBM |
| USER |
| 16.06.2006 |
| |
List of schemas Schema: SQLJ
Properties
| SQLJ |
| SYSIBM |
| USER |
| 16.06.2006 |
| |
List of schemas Schema: SYSCAT
Properties
| SYSCAT |
| SYSIBM |
| SYSIBM |
| 16.06.2006 |
| |
List of schemas Schema: SYSFUN
Properties
| SYSFUN |
| SYSIBM |
| SYSIBM |
| 16.06.2006 |
| |
List of schemas Schema: SYSIBM
Properties
| SYSIBM |
| SYSIBM |
| SYSIBM |
| 16.06.2006 |
| |
List of schemas Schema: SYSPROC
Properties
| SYSPROC |
| SYSIBM |
| SYSIBM |
| 16.06.2006 |
| |
List of schemas Schema: SYSSTAT
Properties
| SYSSTAT |
| SYSIBM |
| SYSIBM |
| 16.06.2006 |
| |
List of schemas Schema: SYSTOOLS
Properties
| SYSTOOLS |
| SYSIBM |
| DB2ADMIN |
| 24.06.2006 |
| |
List of schemas Schema: USER
Properties
| USER |
| SYSIBM |
| USER |
| 16.06.2006 |
| |
Autherisations
| | SYSIBM | PUBLIC | ALTER=NOT_HELD, CREATE=HELD, DROP=NOT_HELD |
Total: 1 autherisation(s)List of schemas Bufferpools
Bufferpool: IBMDEFAULTBP
Properties
| IBMDEFAULTBP |
| |
| 250 |
| 4096 |
| |
| 0 |
| 0 |
List of bufferpools Eventmonitors
Eventmonitor: DB2DETAILDEADLOCK
Properties
| DB2DETAILDEADLOCK |
| USER |
| FILE |
| db2detaildeadlock |
| 20 |
| 512 |
| 17 |
| BLOCKED |
| APPEND |
| |
| 0 |
| L |
| 0 |
| |
Events
 | DETAILDEADLOCKS | |
Total: 1 event(s)List of eventmonitors Eventmonitor: XXXXX
Properties
| XXXXX |
| USER |
| TABLE |
| |
| |
| |
| 4 |
| NOT BLOCKED |
| |
| |
| 0 |
| T |
| 1 |
| |
Events
| | DATABASE | |
| | DEADLOCKS | |
Total: 2 event(s)List of eventmonitors Wrappers
Wrapper: CONNECT
Properties
| CONNECT |
| RELATIONAL |
| 0 |
| db2drda.dll |
| |
Servers
Total: 3 server(s) Options
Total: 1 option(s)List of wrappers Servers
Wrapper server: TEST
Properties
Options
Total: 2 option(s) User mappings
| DB2ADMIN | REMOTE_AUTHID | db2admin |
| USER | REMOTE_AUTHID | db2admin |
Total: 2 user mapping(s) Nicknames
Total: 8 nickname(s)List of servers Wrapper server: TEST222
Properties
Options
Total: 2 option(s) User mappings
| DB2ADMIN | REMOTE_AUTHID | db2admin |
Total: 1 user mapping(s)List of servers Wrapper server: XXXXX
Properties
Options
Total: 2 option(s)List of servers Users
User: DB2ADMIN
Properties
Autherisations
Total: 1 autherisation(s)List of users User: USER
Properties
Autherisations
| | SYSIBM | SAMPLE | DBA=HELD, CREATETABLE=HELD, BIND=HELD, CONNECT=HELD, NOFENCE=HELD, IMPLICIT_SCHEMA=HELD, LOAD=HELD, CREATE_EXTERNAL_ROUTINE=HELD, QUIESCE_CONNECT=HELD, LIBRARY_ADMIN=NOT_HELD, SECURITY_ADMIN=NOT_HELD |
| | SYSIBM | USER.AAAAAAAAAAAA | CONTROL=HELD, ALTER=NOT_HELD, DELETE=NOT_HELD, INDEX=NOT_HELD, INSERT=NOT_HELD, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=NOT_HELD |
| | SYSIBM | USER.ACT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.BONUS_INCREASE | EXECUTE=HELD_GRANTABLE |
| | SYSIBM | USER.CC1151754616344 | CONTROL=HELD |
| | SYSIBM | USER.CC1151754705266 | CONTROL=HELD |
| | SYSIBM | USER.CC1151755626422 | CONTROL=HELD |
| | SYSIBM | USER.CC11517556264220 | CONTROL=HELD |
| | SYSIBM | USER.CC11517556264221 | CONTROL=HELD |
| | SYSIBM | USER.CC1151755924953 | CONTROL=HELD |
| | SYSIBM | USER.CC1151778928062 | CONTROL=HELD |
| | SYSIBM | USER.CDSTAFF | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.CL_SCHED | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.CONNHEADER_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.CONTROL_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.DB_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.DBMEMUSE_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.DEADLOCK_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.DEPARTMENT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.DLCONN_XXXXX | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.EMP_ACT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.EMP_PHOTO | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.EMP_RESUME | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.EMPLOYEE | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_APPENQ | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_APPENQX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_APPLYTRACE | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_APPLYTRACX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_APPLYTRAIL | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_APPLYTRLX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_APPPARMS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_APPPARMSX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_CAPENQ | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_CAPMON | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_CAPMONX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_CAPPARMS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_CAPSCHEMAS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_CAPSCHEMAX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_CAPTRACE | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_CAPTRACEX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_COMPENSATE | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_COMPENSATX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_PRUNCNTL | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_PRUNCNTLX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_PRUNCNTLX1 | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_PRUNCNTLX2 | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_PRUNCNTLX3 | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_PRUNE_LOCK | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_PRUNE_SET | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_PRUNE_SETX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_REGISTER | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_REGISTERX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_REGISTERX1 | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_REGISTERX2 | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_RESTART | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SIGNAL | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SIGNALX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_SUBS_COLS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SUBS_COLSX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_SUBS_EVENT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SUBS_EVENX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_SUBS_MEMBR | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SUBS_MEMBX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_SUBS_SET | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SUBS_SETX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_SUBS_STMTS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_SUBS_STMTX | CONTROL=HELD |
| | SYSIBM | ASN.IBMSNAP_UOW | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | ASN.IBMSNAP_UOWX | CONTROL=HELD |
| | SYSIBM | USER.IN_TRAY | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.IXCDSTAFF | CONTROL=HELD |
| | SYSIBM | USER.IXNICK_STAFF_MQT | CONTROL=HELD |
| | SYSIBM | USER.IXQQQ_STAFF_MQT | CONTROL=HELD |
| | SYSIBM | USER.NICK_CHECK_CONSTRAINTS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_COLUMNS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_COLUMNS_S | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_REF_CONSTRAINTS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_REFERENTIAL_CONSTRAINTS | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_SALES | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_STAFF | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.NICK_STAFF_MQT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | NICK_STAFF_MQT_TS | USE=HELD_GRANTABLE |
| | SYSIBM | USER.ORG | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.P4434996 | CONTROL=HELD, BIND=HELD_GRANTABLE, EXECUTE=HELD_GRANTABLE |
| | SYSIBM | USER.PK_ACT | CONTROL=HELD |
| | SYSIBM | USER.PROJECT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.QQQ_STAFF | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.QQQ_STAFF_MQT | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | QQQ_STAFF_MQT_TS | USE=HELD_GRANTABLE |
| | SYSIBM | USER.SALES | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.SAMPSEQUENCE | USAGE=HELD_GRANTABLE, ALTER=HELD_GRANTABLE |
| | SYSIBM | USER.SQL060624144124500 | EXECUTE=HELD_GRANTABLE |
| | SYSIBM | USER.STAFF | CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
| | SYSIBM | TSASNAA | USE=HELD_GRANTABLE |
| | SYSIBM | TSASNCA | USE=HELD_GRANTABLE |
| | SYSIBM | TSASNUOW | USE=HELD_GRANTABLE |
| | SYSIBM | TSCDSTAFF | USE=HELD_GRANTABLE |
| | SYSIBM | USER.VDEPT | CONTROL=HELD, ALTER=NOT_HELD, DELETE=HELD_GRANTABLE, INDEX=NOT_HELD, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.VHDEPT | CONTROL=HELD, ALTER=NOT_HELD, DELETE=HELD_GRANTABLE, INDEX=NOT_HELD, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=NOT_HELD, UPDATE=HELD_GRANTABLE |
| | SYSIBM | USER.XACT2 | CONTROL=HELD |
| | SYSIBM | USER.XACT3 | CONTROL=HELD |
Total: 101 autherisation(s)List of users Groups
Group: PUBLIC
Properties
Autherisations
| | USER | SAMPLE | DBA=NOT_HELD, CREATETABLE=HELD, BIND=HELD, CONNECT=HELD, NOFENCE=NOT_HELD, IMPLICIT_SCHEMA=NOT_HELD, LOAD=NOT_HELD, CREATE_EXTERNAL_ROUTINE=NOT_HELD, QUIESCE_CONNECT=NOT_HELD, LIBRARY_ADMIN=NOT_HELD, SECURITY_ADMIN=NOT_HELD |
| | SYSIBM | SAMPLE | DBA=NOT_HELD, CREATETABLE=HELD, BIND=HELD, CONNECT=HELD, NOFENCE=NOT_HELD, IMPLICIT_SCHEMA=HELD, LOAD=NOT_HELD, CREATE_EXTERNAL_ROUTINE=NOT_HELD, QUIESCE_CONNECT=NOT_HELD, LIBRARY_ADMIN=NOT_HELD, SECURITY_ADMIN=NOT_HELD |
| | SYSIBM | ASN | ALTER=NOT_HELD, CREATE=HELD, DROP=NOT_HELD |
| | SYSIBM | USER | ALTER=NOT_HELD, CREATE=HELD, DROP=NOT_HELD |
| | SYSIBM | USERSPACE1 | USE=HELD |
Total: 5 autherisation(s)List of groups
Instance Info
Instance information
System information
Configuration
| AGENT_STACK_SZ | 16 | 16 |
| AGENTPRI | -1 | -1 |
| ASLHEAPSZ | 15 | 15 |
| AUDIT_BUF_SZ | 0 | 0 |
| AUTHENTICATION | 0 | 0 |
| BACKBUFSZ | 1024 | 1024 |
| CATALOG_NOAUTH | 0 | 0 |
| CLNT_KRB_PLUGIN | IBMkrb5 | IBMkrb5 |
| CLNT_PW_PLUGIN | | |
| COMM_BANDWIDTH | 0 | 0 |
| CONN_ELAPSE | 0 | 0 |
| CPUSPEED | 3,936202E-07 | 3,936202E-07 |
| DATALINKS | 0 | 0 |
| DBMCONFIG_TYPE | 0 | 1 |
| DFT_ACCOUNT_STR | | |
| DFT_CLIENT_ADPT | 0 | 0 |
| DFT_CLIENT_COMM | | |
| DFT_MON_BUFPOOL | 0 | 0 |
| DFT_MON_LOCK | 0 | 0 |
| DFT_MON_SORT | 0 | 0 |
| DFT_MON_STMT | 0 | 0 |
| DFT_MON_TABLE | 0 | 0 |
| DFT_MON_UOW | 0 | 0 |
| DFT_MONSWITCHES | 64 | 64 |
| DFTDBPATH | C: | C: |
| DIAGLEVEL | 3 | 3 |
| DIAGPATH | | |
| DIR_CACHE | 1 | 1 |
| DIR_OBJ_NAME | | |
| DIR_PATH_NAME | /.:/subsys/database/ | /.:/subsys/database/ |
| DIR_TYPEC | 0 | 0 |
| DISCOVER_COMM | | |
| DISCOVER_INST | 1 | 1 |
| DISCOVERD | 2 | 2 |
| DOS_RQRIOBLK | 4096 | 4096 |
| DRDA_HEAP_SZ | 128 | 128 |
| FCM_NUM_ANCHORS | -1 | -1 |
| FCM_NUM_BUFFERS | 1024 | 0 |
| FCM_NUM_CONNECT | -1 | -1 |
| FCM_NUM_RQB | 512 | 0 |
| FEDERATED | 0 | 0 |
| FILESERVER | | |
| GROUP_PLUGIN | | |
| INDEXRECE | 2 | 2 |
| INITDARI_JVM | 0 | 0 |
| INTRA_PARALLEL | 0 | 0 |
| IPX_SOCKET | 879E | 879E |
| JAVA_HEAP_SZ | 512 | 512 |
| JDK11_PATH | C:\Program Files\IBM\SQLLIB\java\jdk | C:\Program Files\IBM\SQLLIB\java\jdk |
| KEEPDARI | 1 | 1 |
| LOCAL_GSSPLUGIN | | |
| MAX_CONNRETRIES | 0 | 0 |
| MAX_COORDAGENTS | -1 | 200 |
| MAX_LOGICAGENTS | 1 | 0 |
| MAX_QUERYDEGREE | -1 | -1 |
| MAX_TIME_DIFF | 0 | 0 |
| MAXAGENTS | 200 | 200 |
| MAXCAGENTS | -1 | 200 |
| MAXDARI | -1 | -1 |
| MAXTOTFILOP | 16000 | 16000 |
| MIN_PRIV_MEM | 32 | 32 |
| MON_HEAP_SZ | 66 | 66 |
| NNAME | | |
| NODETYPE | 1 | 1 |
| NOTIFYLEVEL | 3 | 3 |
| NUM_INITAGENTS | 0 | 0 |
| NUM_INITDARIS | 0 | 0 |
| NUM_POOLAGENTS | -1 | 100 |
| NUMDB | 8 | 8 |
| OBJECTNAME | | |
| PLUGIN_MODE | 1 | 1 |
| PRIV_MEM_THRESH | 20000 | 20000 |
| QUERY_HEAP_SZ | 1000 | 1000 |
| RELEASE | 2560 | 2560 |
| RESTBUFSZ | 1024 | 1024 |
| RESYNC_INTERVAL | 180 | 180 |
| ROUTE_OBJ_NAME | | |
| RQRIOBLK | 32767 | 32767 |
| SHEAPTHRES | 10000 | 10000 |
| SPM_LOG_FILE_SZ | 256 | 256 |
| SPM_MAX_RESYNC | 20 | 20 |
| SPM_NAME | TEZORRO | TEZORRO |
| SPM_PATH_NAME | | |
| SRVCON_AUTH | 255 | 255 |
| SRVCON_GSSPLUGIN_LIST | | |
| SRVCON_PW_PLUGIN | | |
| SS_LOGON | 1 | 1 |
| START_STOP_TIME | 0 | 0 |
| SVCENAME | db2c_DB2 | db2c_DB2 |
| SYSADM_GROUP | | |
| SYSCTRL_GROUP | | |
| SYSMAINT_GROUP | | |
| TM_DATABASE | 1ST_CONN | 1ST_CONN |
| TP_MON_NAME | | |
| TPNAME | | |
| TRUST_ALLCLNTSF | 1 | 1 |
| TRUST_CLNTAUTH | 0 | 0 |
| UDF_MEM_SZ | 256 | 256 |
About
Documentation details