Mainframe Application and Admin training in Mumbai

We will be covering below training in Mumbai.

Mainframe Developer Training Outline
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


Mainframe Admin Course Syllabus
Mainframe system administration
z OS Overview
TSO / ISPF,JCL,VSAM
INITIALIZATION & IPL PROCEDURE
JES Administration
Catalog
Storage Management
SMF,TCP/IP,VTAM
RACF Administration
SMP/E Introduction
DB2 Administration
CICS Administration
Mainframe application program
An Introduction to the z/OS and OS/390 Environment
ISPF
JCL Job Control Language
VSAM Fundamentals
MVS Administration
Operating System Customization and Initialization Concepts
SYSTEM DATA SETS
JES Administration
Catalogs
Storage Management
SMF
RACF Administration
SMP/E Introduction
REXX, CLIST, ASSEMBLER programming
Introduction to REXX keywords- SAY, DO, IF and EXIT
Conditional Instructions
Looping
Built-in Functions & TSO/E External Functions
Tracing & Debugging
Stack and I/O Processing
Creating a CLIST
Executing a CLIST
Using TSO Commands in CLISTs
Programmable CLISTs
Submitting Background Jobs from CLISTs
PROC Statements
Debugging Techniques
CLIST Programming
File I/O Processing
Trapping Output
Monitoring Datasets
Multi-Module (Nested) CLIST Programs
Compile, Link and Go CLISTs
Advanced Topics
AIX / UNIX Administration
Introduction to AIX
System
Files and Directories
File Permissions
The vi Editor
Shell Basics
Shell Variables
Processes
Customising the User Environment
AIX Utilities
Software Installation and Maintenance