zOs/SQL/GRIMM

SET CURRENT SQLID = 'S100447';
DROP   INDEX LDAP001A.DIR_SEARCHX2;
COMMIT;
CREATE INDEX LDAP001A.DIR_SEARCHX2
       ON LDAP001A.DIR_SEARCH
     ( EID                  ASC  ,
       ATTR_ID              ASC  ,
       VALUE                ASC  )
       USING STOGROUP GSMS
             PRIQTY  288000
             SECQTY   14400
       ERASE NO
       FREEPAGE   0
       PCTFREE 10
       GBPCACHE CHANGED
       CLUSTER
       BUFFERPOOL BP1
       CLOSE YES
       PIECESIZE 2       G
       COPY NO
       DEFER YES
                                                                      ;
CREATE INDEX LDAP001A.DIR_SEARCHX3
       ON LDAP001A.DIR_SEARCH
     ( VALUE                ASC  ,
       ATTR_ID              ASC  ,
       EID                  ASC  )
       USING STOGROUP GSMS
             PRIQTY  288000
             SECQTY   14400
       ERASE NO
       FREEPAGE   0
       PCTFREE 10
       GBPCACHE CHANGED
       BUFFERPOOL BP1
       CLOSE YES
       PIECESIZE 2       G
       COPY NO
       DEFER YES
                                                                      ;