zOs/JCL/ELARJX0
??? pm
??? Indizes für Tabelle XBDKP001PM001002:
CREATE INDEX BUA.I000B1P8_MIG ON BUA.XBDKP001PM001002
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001003;
CREATE INDEX BUA.I000B1P9_MIG ON BUA.XBDKP001PM001003
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001004;
CREATE INDEX BUA.I000B1PA_MIG ON BUA.XBDKP001PM001004
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001005;
CREATE INDEX BUA.I000B1PB_MIG ON BUA.XBDKP001PM001005
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001006;
CREATE INDEX BUA.I000B1PC_MIG ON BUA.XBDKP001PM001006
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001007;
CREATE INDEX BUA.I000B1PD_MIG ON BUA.XBDKP001PM001007
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B1PF_MIG ON BUA.XBDKP001PM001008
( EN1SLWRFNEU ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001009:
CREATE INDEX BUA.I000B1PG_MIG ON BUA.XBDKP001PM001009
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001010:
CREATE INDEX BUA.I000B1PH_MIG ON BUA.XBDKP001PM001010
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001011:
CREATE INDEX BUA.I000B1PI_MIG ON BUA.XBDKP001PM001011
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001012:
CREATE INDEX BUA.I000B1PJ_MIG ON BUA.XBDKP001PM001012
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001013:
CREATE INDEX BUA.I000B1PK_MIG ON BUA.XBDKP001PM001013
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B1PL_MIG ON BUA.XBDKP001PM001013
( EN1KONTO ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001014:
CREATE INDEX BUA.I000B1PM_MIG ON BUA.XBDKP001PM001014
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B1PN_MIG ON BUA.XBDKP001PM001014
( EN1VALORNEU ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B1PO_MIG ON BUA.XBDKP001PM001014
( EN1ISIN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? Indizes für Tabelle XBDKP001PM001015:
CREATE INDEX BUA.I000B1PP_MIG ON BUA.XBDKP001PM001015
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? bdy
??? Indizes für Tabelle XBDKP001IT002001:
CREATE INDEX BUA.I000AMH7_MIG ON BUA.XBDKP001IT002001
( EA1STRN ASC
, EN1STK1 ASC
, EN1STK2 ASC
, EN1ENTERTAG ASC
-- , EN1PART ASC -- Unique Index nicht möglich (Duplikate)
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS3
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? aop
??? Indizes für Tabelle XBDKP001PS001001:
CREATE UNIQUE INDEX BUA.I000B2RG_MIG ON BUA.XBDKP001PS001001
( EA1ATRN ASC
, EN1ENTERTAG ASC
, ET1LOGPROD ASC
, EN1PART ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 3
PCTFREE 40
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE UNIQUE INDEX BUA.I000B2RH_MIG ON BUA.XBDKP001PS001001
(
EN1PART ASC
, EN1ABRWSN ASC
, EC1ABRWSHIST ASC
, EN1ABRWS ASC
, ES1ABRWS ASC
, EC1BA ASC
, EC1GA ASC
, EC1PHASE ASC
, ET1LOGPROD ASC
,
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 3
PCTFREE 30
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RI_MIG ON BUA.XBDKP001PS001001
( EN1ABRWS ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RJ_MIG ON BUA.XBDKP001PS001001
( EN1CIFINH ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RK_MIG ON BUA.XBDKP001PS001001
( EN1DEPOT ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RL_MIG ON BUA.XBDKP001PS001001
( EN1SWIFTREF ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RM_MIG ON BUA.XBDKP001PS001001
( EN1SICABS ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RN_MIG ON BUA.XBDKP001PS001001
( EN1VALORNEU ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RO_MIG ON BUA.XBDKP001PS001001
( EN1ISIN ASC
, ET1LOGPROD ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
??? sep
??? Indizes für Tabelle XBDKP001PS002001 Unique Index:
CREATE UNIQUE INDEX BUA.I000B2RQ_MIG ON BUA.XBDKP001PS002001
( EA1STRN ASC
, EN1ENTERTAG ASC
, EN1PART ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 2
PCTFREE 50
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO
CREATE INDEX BUA.I000B2RR_MIG ON BUA.XBDKP001PS002001
( EA1ATRN ASC
, EN1ENTERTAG ASC
)
NOT CLUSTER
PARTITIONED
DEFINE YES
FREEPAGE 5
PCTFREE 20
GBPCACHE CHANGED
USING STOGROUP GSMS1
ERASE NO
PRIQTY -1
SECQTY -1
BUFFERPOOL BP20
CLOSE NO