IBM Mainframes Online Training
IBM MAINFRAME BASICS and MVS
Introduction to MVS
Key concepts and Terminlogy
Characteristics features of MVS
- Multi programming
- Multi processing
- Real and Auxiliary Storage
- Spooling
- Paging
- Address Spaces
- Swapping
Data Management overview(MVS Functions)
- 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
- Structure 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
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
- SYSUDUMP
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
- TKSDS,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
MODES OF LOCKS
- SHARED
- EXCLUSIVE
- RELEASE OPTION
- ISOLATION LEVELS
DB2 TOOLS
- SPUFI
- QMF
- DCLGEN
- DB2 UTILITIES