DEMO database installation job stream
The JALDEMOJ job stream defines and restores the DEMO Database files from the DEMODB dump file.
See the comments in the code below for instructions on editing JALDEMOJ.
//name JOB jobCardParameters //JALDEMOP PROC HLQ=, High level qualifier(s) of install DSNs // VER=, M204 Version // UNIT=, Unit // VOL= Volume //* //********************************************************************** //* Job: M204ALOC created on: 19 JUL 2012 AT: 13:04:11 //* allocates and catalogs MODEL 204 libraries & product files //********************************************************************** //ALOC EXEC PGM=IEFBR14 //CLIENTS DD DSN=&HLQ..&VER..CLIENTS, // DISP=(NEW,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=F,LRECL=6184,BLKSIZE=6184), // SPACE=(6184,224), // UNIT=&UNIT,VOL=SER=&VOL //CLAIMS02 DD DSN=&HLQ..&VER..CLAIMS02, // DISP=(NEW,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=F,LRECL=6184,BLKSIZE=6184), // SPACE=(6184,42), // UNIT=&UNIT,VOL=SER=&VOL //CLAIMS03 DD DSN=&HLQ..&VER..CLAIMS03, // DISP=(NEW,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=F,LRECL=6184,BLKSIZE=6184), // SPACE=(6184,42), // UNIT=&UNIT,VOL=SER=&VOL //VEHICLES DD DSN=&HLQ..&VER..VEHICLES, // DISP=(NEW,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=F,LRECL=6184,BLKSIZE=6184), // SPACE=(6184,126), // UNIT=&UNIT,VOL=SER=&VOL //DAILY DD DSN=&HLQ..&VER..DAILY, // DISP=(NEW,CATLG,DELETE), // DCB=(DSORG=PS,RECFM=F,LRECL=6184,BLKSIZE=6184), // SPACE=(6184,200), // UNIT=&UNIT,VOL=SER=&VOL //* End of M204ALOC ******* //********************************************************************** //* Job: RESTDEMO created on: 19 JUL 2012 AT: 13:04:13 //* restores the demo database files //********************************************************************** //INSTALL EXEC PGM=BATCH204,REGION=8M, // PARM='SYSOPT=128' //STEPLIB DD DSN=&HLQ..&VER..LOADLIB, // DISP=SHR //CCASTAT DD DSN=&HLQ..&VER..CCASTAT, // DISP=(SHR) //CCAPRINT DD SYSOUT=* //CCAAUDIT DD SYSOUT=* //CCASNAP DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //CCATEMP DD DSN=&&TEMP0,DISP=(NEW,DELETE,DELETE), // UNIT=SYSDA,SPACE=(6184,100) //DUMPCLNT DD DSN=&HLQ..&VER..DEMODB.DUMP(CLIENTS), // DISP=SHR //DUMPCL02 DD DSN=&HLQ..&VER..DEMODB.DUMP(CLAIMS02), // DISP=SHR //DUMPCL03 DD DSN=&HLQ..&VER..DEMODB.DUMP(CLAIMS03), // DISP=SHR //DUMPVEH DD DSN=&HLQ..&VER..DEMODB.DUMP(VEHICLES), // DISP=SHR //DUMPDLY DD DSN=&HLQ..&VER..DEMODB.DUMP(DAILY), // DISP=SHR //* //CLIENTS DD DSN=&HLQ..&VER..CLIENTS, // DISP=(SHR) //CLAIMS02 DD DSN=&HLQ..&VER..CLAIMS02, // DISP=(SHR) //CLAIMS03 DD DSN=&HLQ..&VER..CLAIMS03, // DISP=(SHR) //VEHICLES DD DSN=&HLQ..&VER..VEHICLES, // DISP=(SHR) //DAILY DD DSN=&HLQ..&VER..DAILY, // DISP=(SHR) //CCAIN DD * SPCORE=20000,NFILES=20,NDIR=20,NDCBS=20 LOGON SUPERKLUGE PIGFLOUR CREATE FILE CLIENTS END OPEN CLIENTS RESTORE 128 FROM DUMPCLNT CREATE FILE CLAIMS02 END OPEN CLAIMS02 RESTORE 128 FROM DUMPCL02 CREATE FILE CLAIMS03 END OPEN CLAIMS03 RESTORE 128 FROM DUMPCL03 CREATE FILE VEHICLES END OPEN VEHICLES RESTORE 128 FROM DUMPVEH CREATE FILE DAILY END CLOSE ALL LOGOUT EOJ /* //* End of RESTDEMO ******* // PEND ************** End of JALDEMOP PROC ************* **** DEMO database Installation JCL, JALDEMOJ *** //* DEMO DB Installation JCL //* 1: Provide the high level qualifier, HLQ, of all Model 204 //* installation DSNs //* //* 2: Provide the Release Version qualifier, VER, for Model 204 //* //* 3: Provide the DASD Unit, UNIT //* //* 4: Provide the Volume, VOL //* //SQLINST EXEC JALDEMOP, // HLQ=, required 1 << // VER=, required 2 << // UNIT=, required 3 << // VOL= required 4 << //