Properties

Name: IBMSNAP_REGISTER 
Schema: ASN 
Status: NORMAL 
Create time: 01.07.2006 
Tablespace: TSASNCA 
Index tablespace:  
Long tablespace:  
Base table schema:  
Base table:  
Rowtype schema:  
Rowtype name:  
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  SOURCE_OWNER  VARCHAR  30  1251         
  SOURCE_TABLE  VARCHAR  128  1251         
  SOURCE_VIEW_QUAL  SMALLINT         
  GLOBAL_RECORD  CHARACTER  1251         
  SOURCE_STRUCTURE  SMALLINT         
  SOURCE_CONDENSED  CHARACTER  1251         
  SOURCE_COMPLETE  CHARACTER  1251         
  CD_OWNER  VARCHAR  30  1251         
  CD_TABLE  VARCHAR  128  1251         
  PHYS_CHANGE_OWNER  VARCHAR  30  1251         
  PHYS_CHANGE_TABLE  VARCHAR  128  1251         
  CD_OLD_SYNCHPOINT  CHARACTER  10         
  CD_NEW_SYNCHPOINT  CHARACTER  10         
  DISABLE_REFRESH  SMALLINT         
  CCD_OWNER  VARCHAR  30  1251         
  CCD_TABLE  VARCHAR  128  1251         
  CCD_OLD_SYNCHPOINT  CHARACTER  10         
  SYNCHPOINT  CHARACTER  10         
  SYNCHTIME  TIMESTAMP  10         
  CCD_CONDENSED  CHARACTER  1251         
  CCD_COMPLETE  CHARACTER  1251         
  ARCH_LEVEL  CHARACTER  1251         
  DESCRIPTION  CHARACTER  254  1251         
  BEFORE_IMG_PREFIX  VARCHAR  1251         
  CONFLICT_LEVEL  CHARACTER  1251         
  CHG_UPD_TO_DEL_INS  CHARACTER  1251         
  CHGONLY  CHARACTER  1251         
  RECAPTURE  CHARACTER  1251         
  OPTION_FLAGS  CHARACTER  1251         
  STOP_ON_ERROR  CHARACTER  1251      'Y'   
  STATE  CHARACTER  1251      'I'   
  STATE_INFO  CHARACTER  1251         
Total: 32 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_REGISTERX  UNIQUE  REGULAR  SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL   
  ASN.IBMSNAP_REGISTERX1  DUBLICATE  REGULAR  PHYS_CHANGE_OWNER, PHYS_CHANGE_TABLE   
  ASN.IBMSNAP_REGISTERX2  DUBLICATE  REGULAR  GLOBAL_RECORD   
Total: 3 index(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 "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);

See Also

List of tables