|
TARGET_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
TARGET_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
TARGET_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
SYNCHTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
SOURCE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
SOURCE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
SOURCE_VIEW_QUAL |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
APPLY_QUAL |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SET_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
CNTL_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
TARGET_STRUCTURE |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
CNTL_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
PHYS_CHANGE_OWNER |
VARCHAR |
30 |
0 |
1251 |
|
|
|
|
|
PHYS_CHANGE_TABLE |
VARCHAR |
128 |
0 |
1251 |
|
|
|
|
|
MAP_ID |
VARCHAR |
10 |
0 |
1251 |
|
|
|
|
Total: 16 column(s)
|
ASN.IBMSNAP_PRUNCNTLX |
UNIQUE |
REGULAR |
SOURCE_OWNER, SOURCE_TABLE, SOURCE_VIEW_QUAL, APPLY_QUAL, SET_NAME, TARGET_SERVER, TARGET_TABLE, TARGET_OWNER |
|
|
ASN.IBMSNAP_PRUNCNTLX1 |
UNIQUE |
REGULAR |
MAP_ID |
|
|
ASN.IBMSNAP_PRUNCNTLX2 |
DUBLICATE |
REGULAR |
PHYS_CHANGE_OWNER, PHYS_CHANGE_TABLE |
|
|
ASN.IBMSNAP_PRUNCNTLX3 |
DUBLICATE |
REGULAR |
APPLY_QUAL, SET_NAME, TARGET_SERVER |
|
Total: 4 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_PRUNCNTL" (
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_OWNER" VARCHAR(30) NOT NULL ,
"TARGET_TABLE" VARCHAR(128) NOT NULL ,
"SYNCHTIME" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SOURCE_OWNER" VARCHAR(30) NOT NULL ,
"SOURCE_TABLE" VARCHAR(128) NOT NULL ,
"SOURCE_VIEW_QUAL" SMALLINT NOT NULL ,
"APPLY_QUAL" CHAR(18) NOT NULL ,
"SET_NAME" CHAR(18) NOT NULL ,
"CNTL_SERVER" CHAR(18) NOT NULL ,
"TARGET_STRUCTURE" SMALLINT NOT NULL ,
"CNTL_ALIAS" CHAR(8) ,
"PHYS_CHANGE_OWNER" VARCHAR(30) ,
"PHYS_CHANGE_TABLE" VARCHAR(128) ,
"MAP_ID" VARCHAR(10) NOT NULL )
IN "TSASNCA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX" ON "ASN "."IBMSNAP_PRUNCNTL"
("SOURCE_OWNER" ASC,
"SOURCE_TABLE" ASC,
"SOURCE_VIEW_QUAL" ASC,
"APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC,
"TARGET_TABLE" ASC,
"TARGET_OWNER" ASC);
CREATE UNIQUE INDEX "ASN "."IBMSNAP_PRUNCNTLX1" ON "ASN "."IBMSNAP_PRUNCNTL"
("MAP_ID" ASC);
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX2" ON "ASN "."IBMSNAP_PRUNCNTL"
("PHYS_CHANGE_OWNER" ASC,
"PHYS_CHANGE_TABLE" ASC);
CREATE INDEX "ASN "."IBMSNAP_PRUNCNTLX3" ON "ASN "."IBMSNAP_PRUNCNTL"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"TARGET_SERVER" ASC);
List of tables