Skip to content

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