IBM Mainframe Concepts

• Architecture
• Input/output Devices

JCL Course Syllabus

INTRODUCTION TO JCL

JOB STATEMENT

• CLASS
• PRTY
• MSGCLASS
• MSGLEVEL
• TYPRUN

JOBLIB/STEPLIB

• JOBLIB
• STEPLIB

EXEC STATEMENT

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

COMMON PARAMETER IN BOTH JOB AND EXEC STATEMENTS

• REGION
• COND
• TIME

DD STATEMENT

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

SPECIAL DD STATEMENTS

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

INSTREAM and CATALOGED PROCEDURES

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

Generation Data Groups (GDG)

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

Control Job Processing (IF THEN ELSE) in JCL

• Introduction
• Example JCL

Restarting and checkpoint in JCL

• Introduction
• Example JCL

VSAM Course Syllabus

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

VSAM TYPES

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

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

ALTERNATE INDEXES

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

VSAM IN COBOL PROGRAM

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

COBOL Course Syllabus

Introduction to COBOL

• Introduction to COBOL

A First COBOL Program

• Writing Structured COBOL
• 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

File I/O

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

COBOL Techniques

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

VSAM IN COBOL PROGRAM

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

DB2 Course Syllabus

Introduction to DB2

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

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

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

DSNTIAR

• WHENEVER
• COMMIT
• Rollback

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

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

Stored Procedure

• Stored Procedure – Development
• Creating Stored Procedures

Managing Stored Procedures

• Executing a Stored Procedures

CICS Course Syllabus

INTRODUCTION TO CICS

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

CICS CONCEPTS

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

CICS RESOURCE DEFINITION

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

MAPSETS, MAPS, MAP FIELDS

• Physical & Symbolic Maps

FILE HANDLING IN CICS AND VSAM

• File control
• Types of VSAM Files

QUEUES

• TSQ
• TDQ

CICS REGION COMMANDS

• XCTL and LINK
• GETMAIN and FREEMAIN

RECOVERY AND RESTART

• Recovery and Restart
• Facilities for CICS Recovery and Restart

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