|
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)
|
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 "."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