Properties

Name: DLCONN_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
  AGENT_ID  BIGINT         
  APPL_ID  CHARACTER  32  1251         
  APPL_ID_HOLDING_LK  CHARACTER  32  1251         
  DEADLOCK_ID  BIGINT         
  EVMON_ACTIVATES  BIGINT         
  LOCK_ATTRIBUTES  BIGINT         
  LOCK_COUNT  BIGINT         
  LOCK_CURRENT_MODE  BIGINT         
  LOCK_ESCALATION  SMALLINT         
  LOCK_HOLD_COUNT  BIGINT         
  LOCK_MODE  BIGINT         
  LOCK_MODE_REQUESTED  BIGINT         
  LOCK_NAME  CHARACTER  13  1251         
  LOCK_NODE  BIGINT         
  LOCK_OBJECT_NAME  BIGINT         
  LOCK_OBJECT_TYPE  BIGINT         
  LOCK_RELEASE_FLAGS  BIGINT         
  LOCK_WAIT_START_TIME  TIMESTAMP  10         
  PARTICIPANT_NO  SMALLINT         
  PARTICIPANT_NO_HOLDING_LK  SMALLINT         
  SEQUENCE_NO  CHARACTER  1251         
  SEQUENCE_NO_HOLDING_LK  CHARACTER  1251         
  START_TIME  TIMESTAMP  10         
  TABLE_NAME  VARCHAR  128  1251         
  TABLE_SCHEMA  VARCHAR  30  1251         
  TABLESPACE_NAME  VARCHAR  18  1251         
Total: 26 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    "."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" ;

See Also

List of tables