CREATE TABLE REVI.DB2LOAD 00010003
(SUBSYS CHAR(4) NOT NULL, 00020005
TIMESTAMP TIMESTAMP NOT NULL, 00030003
DBNAME CHAR(8) NOT NULL, 00040003
TSNAME CHAR(8) NOT NULL, 00050003
DSNUM INTEGER NOT NULL, 00060003
ICTYPE CHAR(1) NOT NULL, 00070003
JOBNAME CHAR(8) , 00080003
AUTHID CHAR(8) 00090003
) 00100003
IN DA540769.A002A 00110008
AUDIT NONE 00120003
; 00130003
00140003
LABEL ON TABLE REVI.DB2LOAD 00150000
IS 'LOAD JOBS' 00160000
; 00170002
CREATE INDEX REVI.I002A1 00180000
ON REVI.DB2LOAD 00190000
( SUBSYS ASC, 00200007
TIMESTAMP ASC 00210000
) 00220000
USING STOGROUP GSMS 00230000
PRIQTY 72 00240000
SECQTY 720 00250000
ERASE NO 00260000
FREEPAGE 0 00270000
PCTFREE 10 00280000
GBPCACHE CHANGED 00290000
BUFFERPOOL BP1 00300000
CLOSE YES 00310000
PIECESIZE 1 G 00320000
COPY NO 00330000
; 00340006
COMMIT; 00350005
CREATE TABLESPACE A002A IN DA540769 00360008
USING STOGROUP GSMS 00370005
PRIQTY 72 00380005
SECQTY 720 00390005
ERASE NO 00400005
FREEPAGE 0 00410005
PCTFREE 5 00420005
GBPCACHE CHANGED 00430005
TRACKMOD YES 00440005
BUFFERPOOL BP2 00450005
LOCKSIZE ANY 00460005
LOCKMAX SYSTEM 00470005
CLOSE YES 00480005
CCSID EBCDIC 00490005
MAXROWS 255; 00500005