Properties

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

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  DEADLOCK_ID  BIGINT         
  DL_CONNS  BIGINT         
  EVMON_ACTIVATES  BIGINT         
  ROLLED_BACK_AGENT_ID  BIGINT         
  ROLLED_BACK_APPL_ID  CHARACTER  32  1251         
  ROLLED_BACK_PARTICIPANT_NO  SMALLINT         
  ROLLED_BACK_SEQUENCE_NO  CHARACTER  1251         
  START_TIME  TIMESTAMP  10         
Total: 8 column(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE 
Total: 1 autherisation(s)

SQL

CREATE TABLE "USER    "."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" ;

See Also

List of tables