zOs/SQL/SYSCOPTB

 set current sqlid = 'S100447';
  drop   INDEX A540769.DSNUCX03;
  commit;
  xREATE INDEX A540769.DSNUCX03
    ON A540769.SYSCOPY
     (dbName                ASC,
      tsName                ASC,
      dsNum                 ASC,
      timestamp             desc,
      icType                asc)
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP0
    CLOSE NO
    COPY NO
    DEFINE YES;
  commit;
--
  COMMIT;
    CREATE TABLESPACE SYSCOPY
      IN DA540769
      USING STOGROUP GSMS
      PRIQTY -1 SECQTY -1
      GBPCACHE CHANGED
      TRACKMOD YES
      seGsize 64
      BUFFERPOOL BP2
      LOCKSIZE ANY
      LOCKMAX SYSTEM
      CLOSE YES
      COMPRESS YES
      CCSID      EBCDIC
      DEFINE YES
      MAXROWS 255;
  CREATE TABLE A540769.SYSCOPY
     (DBNAME               CHAR(8) FOR SBCS DATA NOT NULL,
      TSNAME               CHAR(8) FOR SBCS DATA NOT NULL,
      DSNUM                INTEGER NOT NULL,
      ICTYPE               CHAR(1) FOR SBCS DATA NOT NULL,
      ICDATE               CHAR(6) FOR SBCS DATA NOT NULL,
      START_RBA            CHAR(6) FOR BIT DATA NOT NULL,
      FILESEQNO            INTEGER NOT NULL,
      DEVTYPE              CHAR(8) FOR SBCS DATA NOT NULL,
      IBMREQD              CHAR(1) FOR SBCS DATA NOT NULL,
      DSNAME               CHAR(44) FOR SBCS DATA NOT NULL,
      ICTIME               CHAR(6) FOR SBCS DATA NOT NULL,
      SHRLEVEL             CHAR(1) FOR SBCS DATA NOT NULL,
      DSVOLSER             VARCHAR(1784) FOR SBCS DATA NOT NULL,
      TIMESTAMP            TIMESTAMP NOT NULL WITH DEFAULT,
      ICBACKUP             CHAR(2) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      ICUNIT               CHAR(1) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      STYPE                CHAR(1) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      PIT_RBA              CHAR(6) FOR BIT DATA NOT NULL WITH DEFAULT,
      GROUP_MEMBER         CHAR(8) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      OTYPE                CHAR(1) FOR SBCS DATA NOT NULL
        WITH DEFAULT 'T',
      LOWDSNUM             INTEGER NOT NULL WITH DEFAULT,
      HIGHDSNUM            INTEGER NOT NULL WITH DEFAULT,
      COPYPAGESF           FLOAT NOT NULL WITH DEFAULT -1,
      NPAGESF              FLOAT NOT NULL WITH DEFAULT -1,
      CPAGESF              FLOAT NOT NULL WITH DEFAULT -1,
      JOBNAME              CHAR(8) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      AUTHID               CHAR(8) FOR SBCS DATA NOT NULL
        WITH DEFAULT,
      OLDEST_VERSION       SMALLINT NOT NULL WITH DEFAULT,
      LOGICAL_PART         INTEGER NOT NULL WITH DEFAULT)
    IN DA540769.SYSCOPY
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  COMMIT;
--
------------------------------------------------------------------------
-- Database=DA540769
--    Index=SYSIBM.DSNUCX01 On SYSIBM.SYSCOPY
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Database=DA540769
--    Index=SYSIBM.DSNUCH01 On SYSIBM.SYSCOPY
------------------------------------------------------------------------
--
  CREATE INDEX A540769.DSNUCH01
    ON A540769.SYSCOPY
     (DBNAME                ASC,
      TSNAME                ASC,
      START_RBA             DESC,
      TIMESTAMP             DESC)
--  VCAT "00000001" -- DB2 catalog index
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    CLUSTER
    BUFFERPOOL BP0
    CLOSE NO
    COPY NO
    DEFINE YES;
--
  COMMIT;
--