-- ******************************************************************** -- -- SQL File to install only the Quest DB2 z/OS Dataset Template supporting objects. -- -- You will need the Quest DB2 z/OS Dataset Template supporting objects -- if you want to execute DB2 on z/OS Utilities within Toad for DB2 3.1 or greater. -- -- You do not need to run this separate install process if you have already installed -- the Quest z/OS components for DB2. -- -- The complete install of the Quest z/OS DB2 components contain -- the Quest z/OS Dataset Template supporting objects. -- -- If you have already installed the DB2 z/OS components for Quest Central for DB2 -- V4.0 or greater -- or -- if you have already installed the DB2 z/OS components for Toad for DB2 V3.0 -- or greater (using the Quest IBM DB2 z/OS Component Installation Wizard) -- the Quest z/OS Dataset Template supporting objects have already been created. -- (Then you do not need to run this DDL.) -- -- Before running this file through a SQL Processor (for example, the Toad DB2 SQL Editor) -- make the following changes: -- -- Change ALL '%SGNAME%' to 'STOGRP' where STOGRP is the name of the -- storage group for the Quest objects. -- Change ALL '%TSBUFFPOOL%' to 'TBSBUFF' where TBSBUFF is the bufferpool to -- to hold the tablespaces -- Change ALL '%IXBUFFPOOL%' to 'IXBUFF' where IXBUFF is the buffer to hold -- the indexes -- -- This SQL will also populate the default dataset template definitions by inserting into the -- Quest Dataset Template Table. -- -- ********************************************************************* CREATE DATABASE QCDB STOGROUP %SGNAME% BUFFERPOOL %TSBUFFPOOL% INDEXBP %IXBUFFPOOL% CCSID EBCDIC; COMMIT; CREATE TABLESPACE QCTEMPLT IN QCDB USING STOGROUP %SGNAME% PRIQTY 300 SECQTY 500 ERASE NO FREEPAGE 0 PCTFREE 5 GBPCACHE CHANGED TRACKMOD YES DEFINE YES SEGSIZE 16 BUFFERPOOL %TSBUFFPOOL% LOCKSIZE ANY LOCKMAX 0 CLOSE YES COMPRESS NO CCSID EBCDIC MAXROWS 255; COMMIT; CREATE TABLE QUEST.QCTEMPLATE_REPO200 (NAME VARCHAR(18) FOR SBCS DATA NOT NULL, CREATEDBY VARCHAR(8) FOR SBCS DATA NOT NULL, MODIFIEDBY VARCHAR(8) FOR SBCS DATA NOT NULL, DSNMASK VARCHAR(254) FOR SBCS DATA NOT NULL, DISPSTATUS VARCHAR(3) FOR SBCS DATA NOT NULL, DISPNORMAL VARCHAR(7) FOR SBCS DATA NOT NULL, DISPABNORMAL VARCHAR(7) FOR SBCS DATA NOT NULL, DEVICETYPE VARCHAR(8) FOR SBCS DATA NOT NULL, MODELDCB VARCHAR(54) FOR SBCS DATA NOT NULL, BUFNO SMALLINT NOT NULL, VOLCOUNT SMALLINT NOT NULL, DATACLAS VARCHAR(8) FOR SBCS DATA NOT NULL, MGMTCLAS VARCHAR(8) FOR SBCS DATA NOT NULL, STORCLAS VARCHAR(8) FOR SBCS DATA NOT NULL, DSVOLSER VARCHAR(1784) FOR SBCS DATA NOT NULL, GDGLIMIT SMALLINT NOT NULL, EXPDL VARCHAR(7) FOR SBCS DATA NOT NULL, RETPD SMALLINT NOT NULL, UNITTYPE CHARACTER(1) FOR SBCS DATA NOT NULL, PQTY INTEGER NOT NULL, SQTY INTEGER NOT NULL, SPACEUNIT CHARACTER(5) FOR SBCS DATA NOT NULL, PCTPRIMARY SMALLINT NOT NULL, PCTSECONDARY SMALLINT NOT NULL, MAXPRIMARY INTEGER NOT NULL, NBRSECONDARY SMALLINT NOT NULL, UNITCOUNT SMALLINT NOT NULL, STACK CHARACTER(1) FOR SBCS DATA NOT NULL, JES3DD VARCHAR(8) FOR SBCS DATA NOT NULL, TRTCH VARCHAR(6) FOR SBCS DATA NOT NULL, REMARKS VARCHAR(254) FOR SBCS DATA NOT NULL, A1 VARCHAR(1000) FOR BIT DATA NOT NULL ) IN QCDB.QCTEMPLT DATA CAPTURE NONE AUDIT NONE CCSID EBCDIC; COMMIT; CREATE UNIQUE INDEX QUEST.QCTEMPLATE_REPO200 ON QUEST.QCTEMPLATE_REPO200 (NAME ASC ) USING STOGROUP %SGNAME% PRIQTY 300 SECQTY 300 ERASE NO FREEPAGE 0 PCTFREE 10 GBPCACHE CHANGED DEFINE YES BUFFERPOOL %IXBUFFPOOL% CLOSE YES DEFER YES COPY NO PIECESIZE 2097152 K; COMMIT; -- ********************************************************************* -- Default Dataset Template definitions -- -- If you need additional definitions, please clone the below insert statements. -- -- Note that the value for NAME (the first column) must be unique. -- -- ********************************************************************* -- Reorg Unload Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCUNLDDN', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..U', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for Reorg unload dataset', '' ); COMMIT; -- Sortin Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCSORTIN', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..I', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for sortin work dataset', '' ); COMMIT; -- Sortout Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCSORTO', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..O', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for sortout work dataset', '' ); COMMIT; -- Image Copy Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCCPY1', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..LP', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for primary local image copies', '' ); COMMIT; -- Image Copy Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCCPY2', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..LS', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for secondary local image copies', '' ); COMMIT; -- Image Copy Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCRCPY1', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..RP', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for primary remote image copies', '' ); COMMIT; -- Image Copy Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCRCPY2', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..RS', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for secondary remote image copies', '' ); COMMIT; -- Error Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCERROR', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..ER', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for error processing dataset', '' ); COMMIT; -- Mapping Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCMAP', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..MAP', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for mapping dataset', '' ); COMMIT; -- Discard Template INSERT INTO QUEST.QCTEMPLATE_REPO200 VALUES ('QCDISC', 'QUEST', 'QUEST', '&USERID..&SSID..&DB..&TS..S&SEQ..DISC', '', '', '', '', '', 0, 0, '', '', '', '', 0, '', 0, 'D', 100, 500, 'TRK', 0, 0, 0, 0, 0, 'N', '', '', 'Used for discard dataset', '' ); COMMIT;