Properties

Name: IBMSNAP_PRUNE_SET 
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         
  APPLY_QUAL  CHARACTER  18  1251         
  SET_NAME  CHARACTER  18  1251         
  SYNCHTIME  TIMESTAMP  10         
  SYNCHPOINT  CHARACTER  10         
Total: 5 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_PRUNE_SETX  UNIQUE  REGULAR  TARGET_SERVER, APPLY_QUAL, SET_NAME   
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_PRUNE_SET"  (
          "TARGET_SERVER" CHAR(18) NOT NULL ,
          "APPLY_QUAL" CHAR(18) NOT NULL ,
          "SET_NAME" CHAR(18) NOT NULL ,
          "SYNCHTIME" TIMESTAMP ,
          "SYNCHPOINT" CHAR(10) FOR BIT DATA NOT NULL )  
         IN "TSASNCA" ;

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_PRUNE_SETX" ON "ASN     "."IBMSNAP_PRUNE_SET"
        ("TARGET_SERVER" ASC,
         "APPLY_QUAL" ASC,
         "SET_NAME" ASC);

See Also

List of tables