Master Mainframe with VRG Technologies - Your Gateway to Advanced Tech Skills

• Initial Program Load (IPL)
• PARMLIB changes
• Job Entry Subsystem (JES)
• CATALOG Management
• Security Definitions (RACF)
• Hardware Management Console (HCD) for defining Hardware
• System Management Facility (SMF)
• Resource Management Facility (RMF)
• Workload Management with Work Load Manager (WLM)
• Health Checker for z/OS, LOGREC for any error logs
• zOSMF (z/OS Management Facility
• Dump and Traces for Trouble shooting

• Functions of OLTP & System Components
• CICS Start up types –
• CICSTS Datasets – used in Startup Procedure
• CICS System Initialization Parameter
• CICS Resource Definition with CEDA – Group and Transaction,
• Resource Definition using DFHCSDUP Utilities
• Resource Copy and Move, Rename
• CEDA Lock and UNLOCK
• CICS Supplied Transactions – CECI, CEBR, CETR, CEDF and CMAC
• CEMT to Inquire and Discard
• CEMT SET options
• CEMT to Monitor Region
• Cemt PERFORM options
• CICS SIP DSAs – Significance
• CICS Region Monitoring
• Inter system Communication – MRO and ISC classification
• CICS with DB2 Interface – DB2 Connection Object
• CICS with DB2 – DSNC Transaction and Options
• DSNC to use DB2 commands
• CICS with MQ Subsystem
• CKQC transaction and Options
• CICS Journals – DFHLOG and DFHSHUNT
• CICS Journals – for Applications Resource Definition
• CICS Operational Utilities
• DFHDU650 Utility
• DFHTU650 Utility
• CICS Monitoring Utility
• CICS Problem Analysis – System Hung, Wait Status

• RDBMS CONCEPTS, DB2 SYSTEM OBJECTS
• DB2 Data Objects
• Database, Data, System Admin tasks and DBA tasks
• Types of DBAs and Multi-platform DBA issues
• Conceptual, Logical and Physical Data model,
• Normalization and Normal forms
• Normalization in Practice and Data Modelling Issues
• Denormalization and DDL.
• Database application development and SQL- DDL, DML, DCL
• Granting and Revoking authority, Authorization roles and Groups
• External Security
• Database Backup and Recovery-Preparing for problems,
• IMAGE Copy backups, Recovery
• Alternatives to backup and Recovery, Point in time Recovery
• Data Movement-DB2 Online utilities
• Data Maintenance –DB2 Online utilities
• Data Statistics – Db2 Online Utilities
• DB2 Address spaces
• DSNZPARM parameters and DB2 Operational activities.
• Basics in REXX with DB2 Environment.
• DB2 Basic operational activities
• Program Preparation
• Using PLAN and PACKAGES.

• Architecture of WebSphere MQ – Messaging & Queuing
• MQ Objects and its functions
• MQSC Commands
• MQ Object Status – Queue Status from Panel and Commands
• Getting display of MQ Resource with Commands
• MQ Channel Initiator – Commands to Start up and Shutdown

• Describe the function of Database
• Database manager
• Database handling
• Hierarchic Announcement Material (A/M)
• Other Data Language/Integrated (DL/I) functions
• Transaction manager
• Transaction message procedure IMS Direct Access Storage Device (DASD) logging
• IMS online change
• DBRC overview
• DBRC log control
• DBCTL concepts
• IMS DB/TM system definition (IMS Sysgen)
• IMS DB/TM system execution and operation
•  

• • • AN OVERVIEW OF DB2
    • DB2 CONCEPTS
    • DESIGNING OBJECTS AND RELATIONSHIPS
    • WORKING WITH SQL: THE LANGUAGE OF DB2
    • WRITING AN APPLICATION PROGRAM

               – Choosing Programming Languages and Methods to Use

               – Preparing an Application Program to Run

               – Writing Static SQL Applications

               – Overview of Static SQL

               – Static SQL Programming Concepts

    • WRITING AN APPLICATION PROGRAM

               – Static SQL Programming Concepts

               – Dynamic SQL Applications

    • Types of Dynamic SQL
    • Dynamic SQL Programming Concepts
    • Triggers

               – Triggers for Active Data

               – Coding Triggers

               – Parts of a Trigger

               – Trigger Cascading

    • ADVANCED CURSORS

               – Scrollable Cursors

               – Sensitive Scrollable Cursors

               – In sensitive Scrollable Cursors

Stored Procedure Concepts – Introduction

• CICS APPLICATION PROGRAMMING ENVIRONMENT
• CICS Structure and components

           – System Programs

           – System Tables

           – Application Programs

           – Mapsets

• CICS Control programs and Control Tables
• DESIGNING CICS APPLICATIONS

           – Simple Application program to get input, process it and send output to the terminal

           – EXEC INTERFACE BLOCK Concept and Usage

           – Using a COMMAREA

           – Pseudo conversational design

• CICS COMMANDS OVERVIEW

           – SEND and RECEIVE

           – Exception handling

           – HANDLE CONDITION

           – IGNORE CONDITION

           – NOHANDLE and RESP commands

• DEBUGGING CICS APPLICATIONS –

           – Scroll CEDF displays

           – Overtype argument values and response codes on CEDF displays

           – Display the EXEC Interface Block

           – Display previously traced commands

           – Continue CEDF with pseudo conversational transactions

           – Request a task ABEND from CEDF

• CICS BASIC MAPPING SUPPORT

           – Map preparation and usage

           – How to create a BMS Mapset

           – Physical and Symbolic Map

           – How to design user-friendly screens

           – How attributes control the look and operation of a field

           – How to code BMS macros

           – The BMS mapset and symbolic map for the customer maintenance program

           –  How to assemble a BMS mapset

           – Extended attributes

           – Cursor positioning

           – Dynamic Attribute Character Assignments

• CICS DATA ACCESS

           – Data declarations to reference records and rows

           – Accessing VSAM Files ESDS, KSDS etc.

           – Reading single records and rows

           – Reading sets of records and rows

           – Adding, deleting, and modifying records and rows

           – Integrity considerations

• CICS QUEUES

           – CICS transient data queues

           – Intra and Extra Partition Data Sets

           – Features of TDQ

           – Automatic Task Initiation

           – CICS temporary storage queues

• CICS PROGRAM-TO-PROGRAM CONTROL

           – LINK with COMMAREA

           – XCTL with COMMAREA

           – The COBOL CALL

           – STARTing a new transaction

           – Pseudo Conversational Techniques

• CICS With Database DB2

           – CICS with DB2

           – How to access DB2 from CICS region

• SDF to design Map

• • Introduction to mainframe – History – Evaluation of Hardware –
  • Evaluation of Software
  • Introduction to Mainframe – z /15 architecture
  • Virtual Storage – Address map structure – 64 bit Addressing Map
  • z/OS Elements – Base & Optional Elements
  • Brief introduction on Major Subsystems
  • TSO/ISPF and Navigation through a mainframe
  • ISPF – Other ISPF Menu Options – Utility Selection Panel
  • JCL Introduction

             – JCL Statements,

             – Sample JCL with utility

             – JCL Introduction,

             – JOB, EXEC & DD Statement syntax & explanation

             – Submitting the JCL with IBM supplied utilities

             – SDSF

  • JCL Utilities & Procedure

            – IBM Utilities – Utilities like IEFBR14, IEBGENER – IEBGENER to copy and Concatenate datasets;

  • IEBCOPY, IEBCOMPR, IEHPROGM, IEHLIST
  • Special DD Statements – SORT and MERGE
  • Procedures – Cataloged and Instream
  • Usage Procedure concepts
  • Advanced JCL –
  • Internal reader – Overriding DD Statements,
  • COND Parameters – IF … ELSE
  • SYSABEND, SYSMDUMP, SYSUDUMP

   

  • JCL with multiple steps coding – Usage of IEBEDIT to restart job with specific steps
  • ICETOOL Utility to get Sort and Customized Report
  • JES2 and JES3 Command handling"
  • VSAM Introduction

             – VSAM data Organization-Types of Data sets – Data set

• • • Control Area and Different types of data sets
    • VSAM AMS, IDCAMs –

               – DEFINE, ALTER – Creating VSAM Data set;

    • IDCAMS

               – Altering the attributes of data sets –

               – Printing the data set information – Deleting data set -Listing the information 

    • IDCAMS – Alternate Index and PATH
    • Generation Data Group Dataset -Creation – Print options
    • Generation Data Group Dataset -Delete options
    • EXPORT & IMPORT for Backup and Recovery
    • VSAM Data set handling through ISPF Options
    • TSO DITTO