zOs/SQL/WM005IX
------------------------------------------------------------------------
-- recreate indexes for twm005A1 In WM01A1A.A005A
------------------------------------------------------------------------
set current sqlid = 'S100447';
--
--drop INDEX OA1A.IWM005A8 ;
--drop INDEX OA1A.IWM005A2 ;
drop INDEX OA1A.IWM005A7 ;
--drop INDEX OA1A.IWM005AA ;
--drop INDEX OA1A.IWM005AC ;
drop INDEX OA1A.IWM005AQ ;
--drop INDEX OA1A.IWM005AF ;
--drop INDEX OA1A.IWM005AE ;
--drop INDEX OA1A.IWM005A1 ;
--drop INDEX OA1A.IWM005A5 ;
commit;
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005A7 On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005A7
ON OA1A.TWM005A1
(CKAT ASC,
NKTO ASC,
CSTAT ASC,
CDEFAULT ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005AQ On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005AQ
ON OA1A.TWM005A1
(CTYP ASC,
NKTO ASC,
CSTAT ASC,
CDEFAULT ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
CREATE INDEX OA1A.IWM005AG
ON OA1A.TWM005A1
(CSTAT ASC,
TWMD2 ASC,
TWMD3 ASC,
TWMD4 ASC,
TWMD5 ASC,
CDEFAULT ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
************ UNVERÄNDERT ;;;;
create INDEX OA1A.IWM005A8
ON OA1A.TWM005A1
(NVALOR ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY 180 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005A2 On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005A2
ON OA1A.TWM005A1
(NCIF ASC,
NDEP ASC,
CTYP ASC,
CKAT ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY 40500 SECQTY 10800
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005AA On OA1A.TWM005A1
------------------------------------------------------------------------
--
SET CURRENT SCHEMA='OA1A';
--
CREATE INDEX OA1A.IWM005AA
ON OA1A.TWM005A1
(NBU ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005AC On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005AC
ON OA1A.TWM005A1
(CGA ASC,
CGAPH ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005AF On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005AF
ON OA1A.TWM005A1
(TWMD1 ASC,
TWMD2 ASC,
TWMD3 ASC,
TWMD4 ASC,
TWMD5 ASC,
TWMD6 ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005AE On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005AE
ON OA1A.TWM005A1
(CTYP ASC,
TWMD1 ASC,
TWMD2 ASC,
TWMD3 ASC,
TWMD4 ASC,
TWMD5 ASC,
TWMD6 ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005A1 On OA1A.TWM005A1
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=WM01A1A
-- Index=OA1A.IWM005A5 On OA1A.TWM005A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.IWM005A5
ON OA1A.TWM005A1
(NDEP ASC,
CTYP ASC,
D$GUEB DESC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER YES
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
-- REBIND PACKAGE(WM.WMINSTR.(TEST000046))
--
-- REBIND PACKAGE(WM.WMREPL.(NSCH))
--
-- REBIND PACKAGE(WM.WMREPL2.(NSCH))
--
-- REBIND PACKAGE(WM.WMSQLTS.(WSIN000036))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000097))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000098))
--
-- REBIND PACKAGE(WM.WM0010.(WSIN000100))
--
-- REBIND PACKAGE(WM.WM0150.(TEST001033))
--
-- REBIND PACKAGE(WM.WM0150.(TEST001856))
--
-- REBIND PACKAGE(WM.WM0150.(TEST001813))
--
-- REBIND PACKAGE(WM.WM8300.(TEST001813))
--
-- REBIND PACKAGE(WM.WM8300.(WSIN000095))
--
-- REBIND PACKAGE(WM.WM8300.(WSIN000097))
--
-- REBIND PACKAGE(WM.YWMNSUP.(NSCH))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-04-06.31.15.535181))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-11-07.04.25.123491))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-11-07.16.16.137880))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-11-07.38.38.159163))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-11-09.30.41.364201))
--
-- REBIND PACKAGE(WM.YWM001.(2002-09-11-09.33.41.131545))
--
-- REBIND PACKAGE(WM.YWM005.(2002-11-26-13.08.59.330008))
--
-- REBIND PACKAGE(WM.YWM006.(NSCH))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-04.40.22.953104))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-04.52.17.179272))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.03.07.265289))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.10.18.604178))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.21.47.462701))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.23.30.492502))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.29.34.960300))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.43.44.303532))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.46.47.998983))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.48.58.787400))
--
-- REBIND PACKAGE(WM.YWM011.(2002-09-04-05.50.56.107769))
--
-- REBIND PACKAGE(YY.YYWMSQ.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000034))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000049))
--
-- REBIND PACKAGE(YY.YYWM001.(WSIN000052))
--
-- REBIND PACKAGE(YY.YYWM002.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM002.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000034))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000039))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM005.(A18Q002827))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000056))
--
-- REBIND PACKAGE(YY.YYWM005.(TEST001079))
--
-- REBIND PACKAGE(YY.YYWM005.(WSIN000058))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000019))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000004568BEEB7))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000020))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000034))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM006.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000052))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000084))
--
-- REBIND PACKAGE(YY.YYWM01E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM05E.(PLIH000120))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM05E.(A18Q002827))
--
-- REBIND PACKAGE(YY.YYWM05E.(TEST001079))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000058))
--
-- REBIND PACKAGE(YY.YYWM05E.(TEST001033))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000063))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000067))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000074))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000064))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000077))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM05E.(TEST001415))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000084))
--
-- REBIND PACKAGE(YY.YYWM05E.(TEST001813))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000095))
--
-- REBIND PACKAGE(YY.YYWM05E.(WSIN000097))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000023))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000039))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000040))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000041))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM051.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM061.(WSIN000020))
--
-- REBIND PACKAGE(YY.YYWM061.(WSIN000032))
--
-- REBIND PACKAGE(YY.YYWM061.(WSIN000036))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000042))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000043))
--
-- REBIND PACKAGE(YY.YYWM51E.(TEST001033))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000063))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000064))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000066))
--
-- REBIND PACKAGE(YY.YYWM51E.(TEST001415))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000081))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000086))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000076))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000092))
--
-- REBIND PACKAGE(YY.YYWM51E.(WSIN000097))
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--