| 1 | //CREADB2 JOB (DB2CR),'SNJARAO',CLASS=A,MSGCLASS=A, 00010016 |
| 2 | // TIME=1440,NOTIFY=&SYSUID,TYPRUN=SCAN 00020021 |
| 3 | //****************************************************************** 00021025 |
| 4 | //* Copyright Amazon.com, Inc. or its affiliates. 00022025 |
| 5 | //* All Rights Reserved. 00023025 |
| 6 | //* 00024025 |
| 7 | //* Licensed under the Apache License, Version 2.0 (the "License"). 00025025 |
| 8 | //* You may not use this file except in compliance with the License. 00026025 |
| 9 | //* You may obtain a copy of the License at 00027025 |
| 10 | //* 00028025 |
| 11 | //* http://www.apache.org/licenses/LICENSE-2.0 00029025 |
| 12 | //* 00029125 |
| 13 | //* Unless required by applicable law or agreed to in writing, 00029225 |
| 14 | //* software distributed under the License is distributed on an 00029325 |
| 15 | //* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, 00029425 |
| 16 | //* either express or implied. See the License for the specific 00029525 |
| 17 | //* language governing permissions and limitations under the License 00029625 |
| 18 | //********************************************************************* 00031002 |
| 19 | //**** Create CARDDEMO Database in DAZ1 subsystem (SSID=DAZ1) ****** 00040021 |
| 20 | //********************************************************************* 00040119 |
| 21 | //**** You can run the SQLs linked here through SPUFI ****** 00041019 |
| 22 | //**** If you prefer JCL, you can run them from this job ****** 00041220 |
| 23 | //**** You may need to bind the utilities used first though ****** 00041320 |
| 24 | //**** See AWS.M2.CARDDEMO.JCL.UTIL(BINDTIAD) to see how ****** 00042017 |
| 25 | //********************************************************************* 00050002 |
| 26 | //* SET PARMS FOR THIS JOB: 00070021 |
| 27 | //********************************************************************* 00071021 |
| 28 | // SET CODER=AWS 00072022 |
| 29 | // SET LBNM=&CODER..M2.CARDDEMO 00072122 |
| 30 | // SET DB2S=DAZ1 00073021 |
| 31 | //********************************************************************* 00075021 |
| 32 | //JOBLIB DD DSN=OEM.DB2.&DB2S..SDSNLOAD,DISP=SHR 00080021 |
| 33 | // DD DSN=OEM.DB2.&DB2S..SDSNLOAD,DISP=SHR 00090021 |
| 34 | // DD DSN=CEE.SCEERUN,DISP=SHR 00100004 |
| 35 | //********************************************************************* 00100123 |
| 36 | //**** STEP 00 : Free existing plans and packages ****** 00100223 |
| 37 | //**** : It ends with RC 8 if not existing. ****** 00100324 |
| 38 | //**** : So dont run it if creating new database ****** 00100424 |
| 39 | //********************************************************************* 00100524 |
| 40 | //FREEPLN EXEC PGM=IKJEFT01,DYNAMNBR=20 00102023 |
| 41 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.DAZ1.SDSNEXIT 00103023 |
| 42 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD 00104023 |
| 43 | //SYSPRINT DD SYSOUT=* 00105023 |
| 44 | //SYSTSPRT DD SYSOUT=* 00106023 |
| 45 | //SYSUDUMP DD SYSOUT=* 00107023 |
| 46 | //SYSTSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2FREE) 00108023 |
| 47 | //********************************************************************* 00110004 |
| 48 | //**** STEP 10 : Use Utility DSNTIAD to create the database ****** 00120019 |
| 49 | //**** This uses an existing STOGROUP AWST1STG ****** 00121018 |
| 50 | //**** You would have to create it if not available ****** 00122023 |
| 51 | //********************************************************************* 00130004 |
| 52 | //CRCRDDB EXEC PGM=IKJEFT01,DYNAMNBR=20 00140004 |
| 53 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.&DB2S..RUNLIB.LOAD 00150021 |
| 54 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD 00160019 |
| 55 | //SYSTSPRT DD SYSOUT=* 00170004 |
| 56 | //SYSUDUMP DD SYSOUT=* 00180004 |
| 57 | //SYSPRINT DD SYSOUT=* 00190004 |
| 58 | //SYSTSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2TIAD1) 00200021 |
| 59 | //SYSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2CREAT) 00250021 |
| 60 | //********************************************************************* 00470011 |
| 61 | //**** STEP 20 : Load the transaction Type table ****** 00480019 |
| 62 | //**** using DSNTEP4 utility ****** 00481019 |
| 63 | //********************************************************************* 00490011 |
| 64 | //LDTTYPE EXEC PGM=IEFBR14,COND=(0,NE) 00500019 |
| 65 | //RUNTEP2 EXEC PGM=IKJEFT01,DYNAMNBR=20 00510011 |
| 66 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.&DB2S..RUNLIB.LOAD 00520021 |
| 67 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD 00530019 |
| 68 | //SYSTSPRT DD SYSOUT=* 00540011 |
| 69 | //SYSUDUMP DD SYSOUT=* 00550011 |
| 70 | //SYSPRINT DD SYSOUT=* 00560011 |
| 71 | //SYSTSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2TEP41) 00570021 |
| 72 | //SYSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2LTTYP) 00630021 |
| 73 | //********************************************************************* 00750015 |
| 74 | //**** STEP 30 : Load Transaction Type Category table ****** 00760019 |
| 75 | //**** using DSNTEP4 utility ****** 00761019 |
| 76 | //********************************************************************* 00770015 |
| 77 | //LDTCCAT EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(0,NE) 00790019 |
| 78 | //STEPLIB DD DISP=SHR,DSN=OEM.DB2.&DB2S..RUNLIB.LOAD 00800021 |
| 79 | // DD DISP=SHR,DSN=OEMA.DB2.VERSIONA.SDSNLOAD 00810015 |
| 80 | //SYSTSPRT DD SYSOUT=* 00820015 |
| 81 | //SYSUDUMP DD SYSOUT=* 00830015 |
| 82 | //SYSPRINT DD SYSOUT=* 00840015 |
| 83 | //SYSTSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2TEP41) 00850021 |
| 84 | //SYSIN DD DISP=SHR,DSN=&LBNM..CNTL(DB2LTCAT) 00910021 |