set current sqlid = 'S100447';
select current timestamp from sysibm.sysDummy1;
CREATE INDEX GDBB290.IBE010A3
ON GDBB290.TBE010A1
(BE010001 ASC,
BE010002 ASC,
BE010034 ASC,
BE010054 ASC)
PARTITIONED
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
FREEPAGE 0 PCTFREE 15
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
select current timestamp from sysibm.sysDummy1;
commit;