Job CREADB2
Description (from JCL comments)
Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved. Licensed under the Apache License, Version 2.0 (the "License"). You may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License Create CARDDEMO Database in DAZ1 subsystem (SSID=DAZ1) You can run the SQLs linked here through SPUFI If you prefer JCL, you can run them from this job You may need to bind the utilities used first though See AWS.M2.CARDDEMO.JCL.UTIL(BINDTIAD) to see how SET PARMS FOR THIS JOB: STEP 00 : Free existing plans and packages : It ends with RC 8 if not existing. : So dont run it if creating new database
Flow
flowchart TD
FREEPLN_8["FREEPLN<br/>IKJEFT01"]
OEM_DB2_DAZ1_SDSNEXIT[("OEM.DB2.DAZ1.SDSNEXIT")]
OEM_DB2_DAZ1_SDSNEXIT --> FREEPLN_8
OEMA_DB2_VERSIONA_SDSNLOAD[("OEMA.DB2.VERSIONA.SDSNLOAD")]
OEMA_DB2_VERSIONA_SDSNLOAD --> FREEPLN_8
_LBNM__CNTL_DB2FREE_[("&LBNM..CNTL(DB2FREE)")]
_LBNM__CNTL_DB2FREE_ --> FREEPLN_8
CRCRDDB_9["CRCRDDB<br/>IKJEFT01"]
FREEPLN_8 --> CRCRDDB_9
OEM_DB2__DB2S__RUNLIB_LOAD[("OEM.DB2.&DB2S..RUNLIB.LOAD")]
OEM_DB2__DB2S__RUNLIB_LOAD --> CRCRDDB_9
OEMA_DB2_VERSIONA_SDSNLOAD[("OEMA.DB2.VERSIONA.SDSNLOAD")]
OEMA_DB2_VERSIONA_SDSNLOAD --> CRCRDDB_9
_LBNM__CNTL_DB2TIAD1_[("&LBNM..CNTL(DB2TIAD1)")]
_LBNM__CNTL_DB2TIAD1_ --> CRCRDDB_9
_LBNM__CNTL_DB2CREAT_[("&LBNM..CNTL(DB2CREAT)")]
_LBNM__CNTL_DB2CREAT_ --> CRCRDDB_9
LDTTYPE_10["LDTTYPE<br/>IEFBR14<br/>COND=(0,NE)"]
CRCRDDB_9 --> LDTTYPE_10
RUNTEP2_11["RUNTEP2<br/>IKJEFT01"]
LDTTYPE_10 --> RUNTEP2_11
OEM_DB2__DB2S__RUNLIB_LOAD[("OEM.DB2.&DB2S..RUNLIB.LOAD")]
OEM_DB2__DB2S__RUNLIB_LOAD --> RUNTEP2_11
OEMA_DB2_VERSIONA_SDSNLOAD[("OEMA.DB2.VERSIONA.SDSNLOAD")]
OEMA_DB2_VERSIONA_SDSNLOAD --> RUNTEP2_11
_LBNM__CNTL_DB2TEP41_[("&LBNM..CNTL(DB2TEP41)")]
_LBNM__CNTL_DB2TEP41_ --> RUNTEP2_11
_LBNM__CNTL_DB2LTTYP_[("&LBNM..CNTL(DB2LTTYP)")]
_LBNM__CNTL_DB2LTTYP_ --> RUNTEP2_11
LDTCCAT_12["LDTCCAT<br/>IKJEFT01<br/>COND=(0,NE)"]
RUNTEP2_11 --> LDTCCAT_12
OEM_DB2__DB2S__RUNLIB_LOAD[("OEM.DB2.&DB2S..RUNLIB.LOAD")]
OEM_DB2__DB2S__RUNLIB_LOAD --> LDTCCAT_12
OEMA_DB2_VERSIONA_SDSNLOAD[("OEMA.DB2.VERSIONA.SDSNLOAD")]
OEMA_DB2_VERSIONA_SDSNLOAD --> LDTCCAT_12
_LBNM__CNTL_DB2TEP41_[("&LBNM..CNTL(DB2TEP41)")]
_LBNM__CNTL_DB2TEP41_ --> LDTCCAT_12
_LBNM__CNTL_DB2LTCAT_[("&LBNM..CNTL(DB2LTCAT)")]
_LBNM__CNTL_DB2LTCAT_ --> LDTCCAT_12