IBM Mainframe Developer

Reading Time: 4 minutes

IBM Mainframe Developer

    IBM Mainframe Concepts
    • Architecture
    • Input/output Devices

    JCL

      INTRODUCTION TO JCL

        Module 1: JOB STATEMENT

        • CLASS
        • PRTY
        • MSGCLASS
        • MSGLEVEL
        • TYPRUN

        Module 2: JOBLIB/STEPLIB

        • JOBLIB
        • STEPLIB

        Module 3: EXEC STATEMENT

        • PARM
        • ACCT
        • ADDRSPC
        • DPRTY
        • PERFORM
        • RD

        Module 4: COMMON PARAMETER IN BOTH JOB AND EXEC STATEMENTS

        • REGION
        • COND
        • TIME

        Module 5: DD STATEMENT

        • DSN
        • Temporary Datasets
        • DISP
        • UNIT
        • VOL
        • SPACE
        • DCB

        Module 6: SPECIAL DD STATEMENTS

        • DUMMY
        • Concatenating Data sets
        • Passing data to COBOL program using – SYSIN DD *
        • SYSOUT
        • SYSUDUMP
        • SYSADUMP

        Module 7: INSTREAM and CATALOGED PROCEDURES

        • Introduction
        • Instream Procedure
        • Cataloged procedure
        • Modify statements in a procedure
        • Symbolic parameters

        Module 8: Generation Data Groups (GDG)

        • INTRODUCTION
        • CREATION OF GDG
        • USING GDG
        • ALTERING GDG DEFINITION
        • DELETING GDG

        Module 9: Control Job Processing (IF THEN ELSE) in JCL

        • Introduction
        • Example JCL

        Module 10: Restarting and checkpoint in JCL

        • Introduction
        • Example JCL

        VSAM

          Module 1: INTRODUCTION TO VSAM

          • Virtual Storage
          • Virtual Storage Access Method
          • Advantages and Disadvantages of VSAM
          • Logical Record
          • Physical Record
          • Control Interval
          • Control Interval Splits
          • Spanned Records

          Module 2: VSAM TYPES

          • Key Sequential Data Set
          • Entry Sequential Data Set
          • Relative Record Data Set
          • Linear Data set

          Module 3: ACCESS METHOD SERVICES

          • IDCAMS
          • Using IDCAMS
          • JCL for IDCAMS
          • Basic IDCAMS commands
          • Define command
          • REPRO
          • REUSE
          • REPLACE
          • IMPORT AND EXPORT
          • VERIFY
          • PRINT
          • LISTCAT
          • SPANNED
          • ALTER
          • DELETE
          • MODAL COMMANDS

          Module 4: ALTERNATE INDEXES

          • Alternate Indexes
          • Alternate index PATHS
          • AIX Organization
          • RELATE
          • UPGRADE
          • KEYS
          • RECORDSIZE
          • DEFINE PATH
          • PATH ENTRY
          • UPDATE

          Module 5: VSAM IN COBOL PROGRAM

          • Using VSAM with COBOL
          • START Statement
          • WRITE
          • REWRITE
          • CLOSE
          • FILE STATUS

          COBOL

            Module 1:Introduction to COBOL

            • Introduction to COBOL

            Module 2: A First COBOL Program

            • Writing Structured COBOL

            Module 3: Conditional Statements

            • The GO TO Statement
            • Data Structures and Storage
            • Declaring Variables
            • Using Data Structures
            • Formatting Output
            • 77 and 88 Levels
            • Declaring and Using Arrays
            • Loan Schedule Report

            Module 4: File I/O

            • File/Record Descriptions
            • Physical/Logical File Descriptions
            • Reading Records from a File
            • Sequentially Writing Records
            • Indexed File I/O
            • Printing Reports

            Module 5: COBOL Techniques

            • Converting to Uppercase
            • Copy Files
            • Selecting Records
            • Sorting & Reporting Data
            • Control Breaks/Summary Totals
            • Handling Dates

            Module 6: VSAM IN COBOL PROGRAM

            • Using VSAM with COBOL
            • START Statement
            • WRITE
            • REWRITE
            • CLOSE
            • FILE STATUS

            DB2

              Module 1: Introduction to DB2

              • What is database and its basic types
              • Database models
              • Hierarchical
              • Network

              Module 2: RDBMS

              • Object Oriented
              • Discuss about storage group and volumes table spaces
              • Index spaces
              • Basic Information About
              • Table
              • Row
              • Column
              • Queries
              • View
              • Trigger
              • Synonyms
              • Alias
              • Discuss Physical Storage of DB2
              • DB2 objects
              • Buffer pools
              • Features of Database design and its types
              • Discuss the advantages of DB2 over VSAM
              • Discuss the features of data integrity and referential integrity

              Module 3: Interaction with DB2

              • Interaction with DB2 using TSO with SPUFI tool and QMF tool
              • Introduction to SQL for interacting with DB2
              • Introduction to COBOL-DB2 application program
              • Using run JCL we can pass the queries
              • With execute immediate
              • Using prepare and execute technique
              • Using dynamic SQL for running the queries
              • Discussing the compilation of COBOL-DB2 program
              • Facility of Error handling in DB2
              • Using DSNTIAR procedure approach
              • Using SQL codes
              • Discussing commit and rollback features
              • Introduction to CURSOR concept
              • Handling Null values in DB2
              • HANDLING VARCHARS
              • Locks facility
              • Error Handling
              • Error Handling – Introduction
              • SQLCA

              Module 4: DSNTIAR

              • WHENEVER
              • COMMIT
              • Rollback

              Module 5: DB2 Utilities

              • Data Consistency Utilities
              • CHECK Utility
              • REPAIR Utility
              • REPORT Utility
              • DIAGNOSE Utility
              • Backup and Recovery Utilities
              • COPY Utility
              • MERGECOPY Utility
              • QUIESCE Utility
              • RECOVER Utility
              • REBUILD Utility
              • REPORT RECOVERY
              • Data Organization Utilities
              • LOAD Utility
              • REORG Utility
              • Catalog Manipulation Utilities
              • CATMAINT Utility
              • MODIFY Utility
              • RUNSTATS Utility
              • STOSPACE Utility

              Module 6: Miscellaneous

              • DB2 Commands
              • Dynamic SQL – Introduction
              • Dynamic SQL – Types
              • When to use Dynamic SQL
              • Execute Immediate SQL
              • Non-select dynamic SQL
              • Parameter marker
              • Fixed-list select
              • Varying-list select SQL

              Module 7: Stored Procedure

              • Stored Procedure – Development
              • Creating Stored Procedures

              Module 8: Managing Stored Procedures

              • Executing a Stored Procedures

              CICS

                Module 1: INTRODUCTION TO CICS

                • CICS
                • Batch Vs. Online
                • CICS Program Format
                • Task and Transaction
                • How to Initiate Transactions

                Module 2: CICS CONCEPTS

                • Multitasking
                • Multi-Threading
                • Quasi-Re-entrancy
                • Conversational, Non-Conversational and pseudo conversational programming

                Module 3: CICS RESOURCE DEFINITION

                • PPT
                • PCT
                • FCT
                • TST
                • DCT
                • RCT

                Module 4: MAPSETS, MAPS, MAP FIELDS

                • Physical & Symbolic Maps

                Module 5: FILE HANDLING IN CICS AND VSAM

                • File control
                • Types of VSAM Files

                Module 6: QUEUES

                • TSQ
                • TDQ

                Module 7: CICS REGION COMMANDS

                • XCTL and LINK
                • GETMAIN and FREEMAIN

                Module 8: RECOVERY AND RESTART

                • Recovery and Restart
                • Facilities for CICS Recovery and Restart

                Module 9: CICS EXCEPTION HANDLING

                • Test and Debugging Commands

                Functions of EDF

                  COBOL-CICS-DB2

                  • General structure of CICS program
                  • CICS provided facilities for Programming
                  • How to work with DB2 databases
                  • How to design, code and test a modular CICS program
                  • How to compile a CICS program
                  • Pre-requisites for the execution of a CICS program
                  • Execution