|
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)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."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