|
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 |
|
|
|
|
|
ACTIVATE |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
SOURCE_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
SOURCE_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
TARGET_SERVER |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
TARGET_ALIAS |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
STATUS |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
LASTRUN |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
REFRESH_TYPE |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
SLEEP_MINUTES |
INTEGER |
4 |
0 |
0 |
|
|
|
|
|
EVENT_NAME |
CHARACTER |
18 |
0 |
1251 |
|
|
|
|
|
LASTSUCCESS |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
SYNCHPOINT |
CHARACTER |
10 |
0 |
0 |
|
|
|
|
|
SYNCHTIME |
TIMESTAMP |
10 |
0 |
0 |
|
|
|
|
|
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 |
|
|
|
|
|
OPTION_FLAGS |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
COMMIT_COUNT |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
MAX_SYNCH_MINUTES |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
AUX_STMTS |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
ARCH_LEVEL |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
Total: 28 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_SUBS_SET" (
"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 ,
"ACTIVATE" SMALLINT NOT NULL ,
"SOURCE_SERVER" CHAR(18) NOT NULL ,
"SOURCE_ALIAS" CHAR(8) ,
"TARGET_SERVER" CHAR(18) NOT NULL ,
"TARGET_ALIAS" CHAR(8) ,
"STATUS" SMALLINT NOT NULL ,
"LASTRUN" TIMESTAMP NOT NULL ,
"REFRESH_TYPE" CHAR(1) NOT NULL ,
"SLEEP_MINUTES" INTEGER ,
"EVENT_NAME" CHAR(18) ,
"LASTSUCCESS" TIMESTAMP ,
"SYNCHPOINT" CHAR(10) FOR BIT DATA ,
"SYNCHTIME" TIMESTAMP ,
"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) ,
"OPTION_FLAGS" CHAR(4) NOT NULL ,
"COMMIT_COUNT" SMALLINT ,
"MAX_SYNCH_MINUTES" SMALLINT ,
"AUX_STMTS" SMALLINT NOT NULL ,
"ARCH_LEVEL" CHAR(4) NOT NULL )
IN "TSASNAA" ;
CREATE UNIQUE INDEX "ASN "."IBMSNAP_SUBS_SETX" ON "ASN "."IBMSNAP_SUBS_SET"
("APPLY_QUAL" ASC,
"SET_NAME" ASC,
"WHOS_ON_FIRST" ASC);
List of tables