|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_TYPE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
WHOS_ON_FIRST |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
ASNLOAD |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
FULL_REFRESH |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
EFFECTIVE_MEMBERS |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SET_INSERTED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SET_DELETED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SET_UPDATED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SET_REWORKED |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SET_REJECTED_TRXS |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
STATUS |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
LASTRUN |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
LASTSUCCESS |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
SYNCHTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
SOURCE_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SOURCE_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
SOURCE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SOURCE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
SOURCE_VIEW_QUAL |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
TARGET_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
TARGET_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
TARGET_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
TARGET_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
CAPTURE_SCHEMA |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
TGT_CAPTURE_SCHEMA |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
FEDERATED_SRC_SRVR |
VARCHAR |
18 |
0 |
1251 |
|
|
|
|
|
FEDERATED_TGT_SRVR |
VARCHAR |
18 |
0 |
1251 |
|
|
|
|
|
JRN_LIB |
CHARACTER |
10 |
0 |
1251 |
|
|
|
|
|
JRN_NAME |
CHARACTER |
10 |
0 |
1251 |
|
|
|
|
|
COMMIT_COUNT |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
OPTION_FLAGS |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
EVENT_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
ENDTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
CURRENT TIMESTAMP |
|
|
SOURCE_CONN_TIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
SQLSTATE |
CHARACTER |
5 |
0 |
1251 |
|
|
|
|
|
SQLCODE |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
SQLERRP |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
SQLERRM |
VARCHAR |
70 |
0 |
1251 |
|
|
|
|
|
APPERRM |
VARCHAR |
760 |
0 |
1251 |
|
|
|
|
Total: 42 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_APPLYTRAIL" (
"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 ,
"ASNLOAD" CHAR(1) ,
"FULL_REFRESH" CHAR(1) ,
"EFFECTIVE_MEMBERS" INTEGER ,
"SET_INSERTED" INTEGER NOT NULL ,
"SET_DELETED" INTEGER NOT NULL ,
"SET_UPDATED" INTEGER NOT NULL ,
"SET_REWORKED" INTEGER NOT NULL ,
"SET_REJECTED_TRXS" INTEGER NOT NULL ,
"STATUS" SMALLINT NOT NULL ,
"LASTRUN" TIMESTAMP NOT NULL ,
"LASTSUCCESS" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"SOURCE_SERVER" CHAR(18) NOT NULL ,
"SOURCE_ALIAS" CHAR(8) ,
"SOURCE_OWNER" VARCHAR(30) ,
"SOURCE_TABLE" VARCHAR(128) ,
"SOURCE_VIEW_QUAL" SMALLINT ,
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_ALIAS" CHAR(8) ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"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) ,
"COMMIT_COUNT" SMALLINT ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"EVENT_NAME" CHAR(18) ,
"ENDTIME" TIMESTAMP NOT NULL WITH DEFAULT ,
"SOURCE_CONN_TIME" TIMESTAMP ,
"SQLSTATE" CHAR(5) ,
"SQLCODE" INTEGER ,
"SQLERRP" CHAR(8) ,
"SQLERRM" VARCHAR(70) ,
"APPERRM" VARCHAR(760) )
IN "TSASNAA" ;
CREATE INDEX "ASN "."IBMSNAP_APPLYTRLX" ON "ASN "."IBMSNAP_APPLYTRAIL"
("LASTRUN" DESC,
"APPLY_QUAL" ASC);
List of tables