Properties

Name: IBMSNAP_CAPMON 
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
  MONITOR_TIME  TIMESTAMP  10         
  RESTART_TIME  TIMESTAMP  10         
  CURRENT_MEMORY  INTEGER         
  CD_ROWS_INSERTED  INTEGER         
  RECAP_ROWS_SKIPPED  INTEGER         
  TRIGR_ROWS_SKIPPED  INTEGER         
  CHG_ROWS_SKIPPED  INTEGER         
  TRANS_PROCESSED  INTEGER         
  TRANS_SPILLED  INTEGER         
  MAX_TRANS_SIZE  INTEGER         
  LOCKING_RETRIES  INTEGER         
  JRN_LIB  CHARACTER  10  1251         
  JRN_NAME  CHARACTER  10  1251         
  LOGREADLIMIT  INTEGER         
  CAPTURE_IDLE  INTEGER         
  SYNCHTIME  TIMESTAMP  10         
Total: 16 column(s)

Indexes

Name Unique rule Type Colnames Description
  ASN.IBMSNAP_CAPMONX  UNIQUE  REGULAR  MONITOR_TIME   
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_CAPMON"  (
          "MONITOR_TIME" TIMESTAMP NOT NULL ,
          "RESTART_TIME" TIMESTAMP NOT NULL ,
          "CURRENT_MEMORY" INTEGER NOT NULL ,
          "CD_ROWS_INSERTED" INTEGER NOT NULL ,
          "RECAP_ROWS_SKIPPED" INTEGER NOT NULL ,
          "TRIGR_ROWS_SKIPPED" INTEGER NOT NULL ,
          "CHG_ROWS_SKIPPED" INTEGER NOT NULL ,
          "TRANS_PROCESSED" INTEGER NOT NULL ,
          "TRANS_SPILLED" INTEGER NOT NULL ,
          "MAX_TRANS_SIZE" INTEGER NOT NULL ,
          "LOCKING_RETRIES" INTEGER NOT NULL ,
          "JRN_LIB" CHAR(10) ,
          "JRN_NAME" CHAR(10) ,
          "LOGREADLIMIT" INTEGER NOT NULL ,
          "CAPTURE_IDLE" INTEGER NOT NULL ,
          "SYNCHTIME" TIMESTAMP NOT NULL )  
         IN "TSASNCA" ;

CREATE UNIQUE INDEX "ASN     "."IBMSNAP_CAPMONX" ON "ASN     "."IBMSNAP_CAPMON"
        ("MONITOR_TIME" ASC);

See Also

List of tables