zOs/SQL/VTINSTR

SELECT TYPEX,  COUNT(*)
    FROM VDPS2.VTINSTISTRUCT
    GROUP BY TYPEX
;
SELECT C, COUNT(*)
    FROM (
SELECT CHILDINSTIID ID,  COUNT(*) C
    FROM VDPS2.VTINSTISTRUCT
    GROUP BY CHILDINSTIID
    ) X
 GROUP BY C
 ORDER BY C DESC
;

  SET CURRENT SQLID='S100447';
  CREATE        INDEX VDPS2.VTXINSTISTRUCT2
    ON VDPS2.VTINSTISTRUCT
     (CHILDINSTIID          ASC,
      TYPEX                 ASC)
    USING STOGROUP GSMS
    PRIQTY -1 SECQTY -1
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
  COMMIT;