Mainframe Modernization

• 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

• • • • 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