Properties

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

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  APPLY_QUAL  CHARACTER  18  1251         
  SET_NAME  CHARACTER  18  1251         
  SET_TYPE  CHARACTER  1251         
  WHOS_ON_FIRST  CHARACTER  1251         
  ACTIVATE  SMALLINT         
  SOURCE_SERVER  CHARACTER  18  1251         
  SOURCE_ALIAS  CHARACTER  1251         
  TARGET_SERVER  CHARACTER  18  1251         
  TARGET_ALIAS  CHARACTER  1251         
  STATUS  SMALLINT         
  LASTRUN  TIMESTAMP  10         
  REFRESH_TYPE  CHARACTER  1251         
  SLEEP_MINUTES  INTEGER         
  EVENT_NAME  CHARACTER  18  1251         
  LASTSUCCESS  TIMESTAMP  10         
  SYNCHPOINT  CHARACTER  10         
  SYNCHTIME  TIMESTAMP  10         
  CAPTURE_SCHEMA  VARCHAR  30  1251         
  TGT_CAPTURE_SCHEMA  VARCHAR  30  1251         
  FEDERATED_SRC_SRVR  VARCHAR  18  1251         
  FEDERATED_TGT_SRVR  VARCHAR  18  1251         
  JRN_LIB  CHARACTER  10  1251         
  JRN_NAME  CHARACTER  10  1251         
  OPTION_FLAGS  CHARACTER  1251         
  COMMIT_COUNT  SMALLINT         
  MAX_SYNCH_MINUTES  SMALLINT         
  AUX_STMTS  SMALLINT         
  ARCH_LEVEL  CHARACTER  1251         
Total: 28 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_SUBS_SETX  UNIQUE  REGULAR  APPLY_QUAL, SET_NAME, WHOS_ON_FIRST   
Total: 1 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_SUBS_SET"  (
          "APPLY_QUAL" CHAR(18) NOT NULL ,
          "SET_NAME" CHAR(18) NOT NULL ,
          "SET_TYPE" CHAR(1) NOT NULL ,
          "WHOS_ON_FIRST" CHAR(1) NOT NULL ,
          "ACTIVATE" SMALLINT NOT NULL ,
          "SOURCE_SERVER" CHAR(18) NOT NULL ,
          "SOURCE_ALIAS" CHAR(8) ,
          "TARGET_SERVER" CHAR(18) NOT NULL ,
          "TARGET_ALIAS" CHAR(8) ,
          "STATUS" SMALLINT NOT NULL ,
          "LASTRUN" TIMESTAMP NOT NULL ,
          "REFRESH_TYPE" CHAR(1) NOT NULL ,
          "SLEEP_MINUTES" INTEGER ,
          "EVENT_NAME" CHAR(18) ,
          "LASTSUCCESS" TIMESTAMP ,
          "SYNCHPOINT" CHAR(10) FOR BIT DATA ,
          "SYNCHTIME" TIMESTAMP ,
          "CAPTURE_SCHEMA" VARCHAR(30) NOT NULL ,
          "TGT_CAPTURE_SCHEMA" VARCHAR(30) ,
          "FEDERATED_SRC_SRVR" VARCHAR(18) ,
          "FEDERATED_TGT_SRVR" VARCHAR(18) ,
          "JRN_LIB" CHAR(10) ,
          "JRN_NAME" CHAR(10) ,
          "OPTION_FLAGS" CHAR(4) NOT NULL ,
          "COMMIT_COUNT" SMALLINT ,
          "MAX_SYNCH_MINUTES" SMALLINT ,
          "AUX_STMTS" SMALLINT NOT NULL ,
          "ARCH_LEVEL" CHAR(4) NOT NULL )  
         IN "TSASNAA" ;

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_SUBS_SETX" ON "ASN     "."IBMSNAP_SUBS_SET"
        ("APPLY_QUAL" ASC,
         "SET_NAME" ASC,
         "WHOS_ON_FIRST" ASC);

See Also

List of tables