Mainframes Contents

MAINFRAME BASICS and MVS

Introduction to MVS

Key concepts and Terminlogy

Characteristics features of MVS

* Multi programming
* Multi processing
* Real and Auxillary Storage
* Spooling
* Paging
* Address Spaces
* Swapping

Data Management overview(MVS Functios)

* Types of Data and Dataset Organization
* VSAM and Non-VSAM datasets organization
* Label and Catalog

I/O Devices

* Unit Record Devices
* Magnetic Tape
* DASD-Direct Access Storage Device

MVS Tools Overview

Interactive System Productivity Facility(ISPF)

* Primary Options Menu
* Command Overview

MVS System Concepts

Job Management Overview

VS COBOL-11

Introduction to COBOL

* History of COBOL and introduction to VSCOBOL 11
* Details of COBOL Coding sheet
* Struvture of COBOL program
* Divisions of COBOL program
* Explanation with Sample program

Working with Data

* Hierarchical representation of data
* COBOL data types
* Elementary and Group data items
* JUSTIFY
* SIGN Clause
* Display vs Computational Numeric Data
* USAGE Clause
* SYNC Clause
* Figurative Constants
* RENAMES
* REDEFINES
* CONDITION NAMES

Program Structure

* Programming style
* Sections and Procedures
* EXIT

Program Control

* Types of statements
* Arthimetic Verbs

Decision Making

Iterations

Trapping Run Time Errors

* Exception handling

Table Handling

File Sorting

* Sorting(Internal,external,bubble,shuttle sorts)
* Input and output procedures
* Merge

File Handling

* File processing Overview
* Types of files
* Open and Close
* The Write VERB
* A Direct READ
* The START Verb
* The Delete Verb
* Writing New Records

Sub Programming

* The use of embedded and external subprograms
* COPY statement
* CALL
* The Linkage Section
* STATIC and DYNAMIC CALL
* CALL BY CONTENT and CALL BY REFERENCE
* EXIT Program and Go back

String Functions

* STRING
* UNSTRING
* INSPECT
* REFERENCE MODIFICATION

Job Control Language(JCL)

Introduction

* Key parameters in JCL

Job statement

* POSITIONAL PARAMETERS
* KEYWORD PARAMETERS

Exec statement

* POSITIONAL PARAMETERS
* KEYWORD PARAMETERS

DD statement

* POSITIONAL PARAMETERS
* KEYWORD PARAMETERS

Special DD statements

* TEMPORARY DATASETS
* BACKWARD REFERENCES
* SYSOUT
* SYSUDUMP
* SYSADUMP

Other JCL statements

* COMMENTS STATEMENTS
* DELIMETER STATEMENTS
* NULL STATEMENT

Procedurs

* PROC and PEND statement
* SYMBOLIC parameters
* PROC statement
* PEND statement
* Invoking Procedure

Generation Data Groups(GDG)

* Introduction
* Creation of GDG
* Altering GDG definition
* Deleting GDG

IBM JCL Utilities

Control Job Processing

* IF the ELSE
* MAXCC,LASTCC
* DO..END
* CANCEL

Sort

* Internal Sort
* External Sort
* Explanation with Real time scenarios
* OMIT,INCLUDE
* INREC,OURREC
* SKIPREC,STOPAFT

VIRTUAL STORAGE ACCESS METHOD(VSAM)

Introduction

* Basic concepts of VSAM
* Advantages of VSAM
* CI,CA and splits

VSAM DATASETS

* KSDS,RBS
* ESDS
* RRDS,RRN
* LDS

Internal organisation of VSAM

VSAM Dataset Allocation

* Dataset components

Parameters used for defining culsters

Alternate Index Allocation

Access Methods Services

* Define VSAM/Generation Dataset Groups
* Define ALTERNATEINDEX
* BLDINDEX
* Define PATH

Other IDCAMS COMMANDS

* LISTCAT
* ALTER
* VERIFY
* REPRO
* MODAL

FILE-STATUS CODES

DATABASE 2(DB2)

Introduction to RDBMS

Overview of DB2

DB2 Objects

SQL

DB2 Application Development Overview

* EMBEDDED SQL
* DATA TYPED of DB2

JOINS

* INNER and OUTER JOIN
* LEFT and RIGHT JOIN

DB2 PRECOMPILATION PROCESS

* DBRM
* BIND
* PACKAGE
* PLAN
* HOST VARIBALES
* NULL INDICATORS
* SQLCA

CURSOR

* USE of CURSOR
* WITH HOLD OPTION

DEADLOCK

* LOCKS and LATCH

MODES OF LOCKS

* SHARED
* EXCLUSIVE

RELEASE OPTION

ISOLATION LEVELS

DB2 TOOLS

* SPUFI
* QMF
* DCLGEN

DB2 UTILITIES