|
MONITOR_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
RESTART_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
CURRENT_MEMORY |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CD_ROWS_INSERTED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
RECAP_ROWS_SKIPPED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
TRIGR_ROWS_SKIPPED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CHG_ROWS_SKIPPED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
TRANS_PROCESSED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
TRANS_SPILLED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
MAX_TRANS_SIZE |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
LOCKING_RETRIES |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
JRN_LIB |
CHARACTER |
10 |
0 |
1251 |
|
|
|
|
|
JRN_NAME |
CHARACTER |
10 |
0 |
1251 |
|
|
|
|
|
LOGREADLIMIT |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
CAPTURE_IDLE |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SYNCHTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
Total: 16 column(s)
Total: 1 index(s)
|
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)
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);
List of tables