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