Properties

Name: IBMSNAP_PRUNCNTL 
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
  TARGET_SERVER  CHARACTER  18  1251         
  TARGET_OWNER  VARCHAR  30  1251         
  TARGET_TABLE  VARCHAR  128  1251         
  SYNCHTIME  TIMESTAMP  10         
  SYNCHPOINT  CHARACTER  10         
  SOURCE_OWNER  VARCHAR  30  1251         
  SOURCE_TABLE  VARCHAR  128  1251         
  SOURCE_VIEW_QUAL  SMALLINT         
  APPLY_QUAL  CHARACTER  18  1251         
  SET_NAME  CHARACTER  18  1251         
  CNTL_SERVER  CHARACTER  18  1251         
  TARGET_STRUCTURE  SMALLINT         
  CNTL_ALIAS  CHARACTER  1251         
  PHYS_CHANGE_OWNER  VARCHAR  30  1251         
  PHYS_CHANGE_TABLE  VARCHAR  128  1251         
  MAP_ID  VARCHAR  10  1251         
Total: 16 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_PRUNCNTLX  UNIQUE  REGULAR  SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, APPLY_QUAL, SET_NAME, TARGET_SERVER, TARGET_TABLE, TARGET_OWNER   
  ASN.IBMSNAP_PRUNCNTLX1  UNIQUE  REGULAR  MAP_ID   
  ASN.IBMSNAP_PRUNCNTLX2  DUBLICATE  REGULAR  PHYS_CHANGE_OWNER, PHYS_CHANGE_TABLE   
  ASN.IBMSNAP_PRUNCNTLX3  DUBLICATE  REGULAR  APPLY_QUAL, SET_NAME, TARGET_SERVER   
Total: 4 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_PRUNCNTL"  (
          "TARGET_SERVER" CHAR(18) NOT NULL ,
          "TARGET_OWNER" VARCHAR(30) NOT NULL ,
          "TARGET_TABLE" VARCHAR(128) NOT NULL ,
          "SYNCHTIME" TIMESTAMP ,
          "SYNCHPOINT" CHAR(10) FOR BIT DATA ,
          "SOURCE_OWNER" VARCHAR(30) NOT NULL ,
          "SOURCE_TABLE" VARCHAR(128) NOT NULL ,
          "SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
          "APPLY_QUAL" CHAR(18) NOT NULL ,
          "SET_NAME" CHAR(18) NOT NULL ,
          "CNTL_SERVER" CHAR(18) NOT NULL ,
          "TARGET_STRUCTURE" SMALLINT NOT NULL ,
          "CNTL_ALIAS" CHAR(8) ,
          "PHYS_CHANGE_OWNER" VARCHAR(30) ,
          "PHYS_CHANGE_TABLE" VARCHAR(128) ,
          "MAP_ID" VARCHAR(10) NOT NULL )  
         IN "TSASNCA" ;

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_PRUNCNTLX" ON "ASN     "."IBMSNAP_PRUNCNTL"
        ("SOURCE_OWNER" ASC,
         "SOURCE_TABLE" ASC,
         "SOURCE_VIEW_QUAL" ASC,
         "APPLY_QUAL" ASC,
         "SET_NAME" ASC,
         "TARGET_SERVER" ASC,
         "TARGET_TABLE" ASC,
         "TARGET_OWNER" ASC);


CREATE UNIQUE INDEX "ASN     "."IBMSNAP_PRUNCNTLX1" ON "ASN     "."IBMSNAP_PRUNCNTL"
        ("MAP_ID" ASC);


CREATE INDEX "ASN     "."IBMSNAP_PRUNCNTLX2" ON "ASN     "."IBMSNAP_PRUNCNTL"
        ("PHYS_CHANGE_OWNER" ASC,
         "PHYS_CHANGE_TABLE" ASC);


CREATE INDEX "ASN     "."IBMSNAP_PRUNCNTLX3" ON "ASN     "."IBMSNAP_PRUNCNTL"
        ("APPLY_QUAL" ASC,
         "SET_NAME" ASC,
         "TARGET_SERVER" ASC);

See Also

List of tables