zOs/SQL/TTT

SET CURRENT SQLID = 'S100447';
ALTER TABLE OA1A.TFI610A1
  ADD PARTITION
   ENDING ( 114000000 ) ;
ALTER TABLE OA1A.TFI610A1
  ADD PARTITION
   ENDING ( 115000000 ) ;
COMMIT
;
X; ECT * FROM GDB9998.TWK403P1             ;
SELECT ID FROM GDB9998.TWK403P1 ORDER BY ID;
SELECT NAME FROM GDB9998.TWK403P1 ORDER BY ID, NAME;
;X:
SELECT STRIP(TBCREATOR) || '.' || STRIP(TBNAME)
    FROM SYSIBM.SYSCOLUMNS
    WHERE NAME =  'ASSETCLASS01DERIVED'
;X;
  SELECT COLLID, COUNT(*)
   FROM SYSIBM.SYSPACKAGE
   GROUP BY COLLID
   ;X;
  DROP TABLESPACE DGDB9998.VDPS425;
  COMMIT;
--****************************************
--DROP TABLE GDB9998.XTREQSCANKEY;
--COMMIT;
--****************************************
  SET CURRENT SQLID='GDB9998';

  CREATE TABLESPACE VDPS425
      IN DGDB9998
      USING STOGROUP GSMS
      PRIQTY 12 SECQTY 7200
      FREEPAGE 50 PCTFREE 5
      GBPCACHE CHANGED
      TRACKMOD YES
      DSSIZE 16 G
      NUMPARTS 2
      BUFFERPOOL BP2
      LOCKSIZE PAGE
      LOCKMAX SYSTEM
      CLOSE YES
      COMPRESS YES
      CCSID        EBCDIC
      DEFINE NO
      MAXROWS 255
      ;
  COMMIT;

  CREATE TABLE GDB9998.XTREQSCANKEY
    (
     PARTITION_NUMBER      INTEGER  NOT NULL,
     TEMP_DBKEY            INTEGER  NOT NULL,
     OUT_IDSYMBOL_2        CHAR(30) WITH DEFAULT NULL,
     OUT_IDSYMBOL_3        CHAR(30) WITH DEFAULT NULL,
     STATUS_FLAG           SMALLINT WITH DEFAULT NULL,
     IS_ACTIVE             SMALLINT WITH DEFAULT NULL,
     CREATETIMESTAMP       VARCHAR(30) FOR SBCS DATA WITH DEFAULT NULL,
     UPDATETIMESTAMP       VARCHAR(30) FOR SBCS DATA WITH DEFAULT NULL
    )
    IN    DGDB9998.VDPS425
    PARTITION BY (PARTITION_NUMBER ASC)
                    (  PART  1 VALUES (1),
                       PART  2 VALUES (2)
                     )

    AUDIT NONE
    DATA  CAPTURE NONE
    CCSID EBCDIC
    NOT   VOLATILE;

    COMMIT;

--CREATE INDEX GDB9998.XTXREQSCANKEY0
--  ON GDB9998.XTREQSCANKEY
--   (PARTITION_NUMBER      ASC)
--  PARTITIONED
--  USING STOGROUP GSMS
--  PRIQTY -1 SECQTY -1
--  FREEPAGE 0 PCTFREE 10
--  GBPCACHE CHANGED
--  CLUSTER
--  BUFFERPOOL BP1
--  CLOSE YES
--  COPY NO
--  DEFINE YES;
--
--COMMIT;
--
--CREATE INDEX GDB9998.XTXREQSCANKEY1
--  ON GDB9998.XTREQSCANKEY
--   (TEMP_DBKEY            ASC)
--  USING STOGROUP GSMS
--  PRIQTY -1 SECQTY -1
--  ERASE  NO
--  FREEPAGE 10 PCTFREE 10
--  GBPCACHE CHANGED
--  NOT CLUSTER
--  BUFFERPOOL BP1
--  CLOSE YES
--  COPY NO
--  DEFINE YES
--  PIECESIZE 2 G;
--
--COMMIT;