Mainframe Tutorial
JCL Tutorial
Introduction JCL and JES JCL Statements Fields of JCL Statement JOB statement EXEC Statement and its Parameters JOBLIB and STPELIB DD Statement DD DSN parameter DD DISP(Disposition) Paramter DD DCB Parameter DD UNIT Parameter DD VOLUME Parameter DD SPACE Parameter DD SYSOUT Parameter SYSIN (*) – Input Stream Data DUMMY Parameter SYSUDUMP DD statement SYSABEND DD statement CONCATENATION OF DATASET TEMPORARY DATASET REFERBACK JCL Procedure JCL In-Stream Procedure JCL Cataloged Procedure JCL Symbolic Parameters JCL Overriding Parameters in Proc Utilities, an Overview IEBGENER IEBCOPY IEHPROGM IEBCOMPR IEFBR14 GDG GDG Characteristics GDG Advantages and Coding Rules Creating GDG base Creating,Deleting GDG Dataset(GDS) Altering GDG base Deleting GDG base Concatenating Generations of GDG SORT/MERGE Intro SORT FIELDS MERGE FIELDS INCLUDE Statement OMIT Statement SUM FIELDS OUTFIL Statement OUTREC Statement OUTREC FILEDS or OUTREC BUILD OUTREC OVERLAY OUTREC FINDREP OUTREC IF THEN clauses INREC statement Role of JCL in COBOL Program Lifecycle Example of Running COBOL Program using JCL COBOL Tutorial
COBOL Introduction Overview, History & Importance COBOL Features COBOL Simple Example Program
COBOL Coding Sheet COBOL Program Structure COBOL Character Set COBOL Word Data Names and Identifiers COBOL Literals COBOL Figurative Constants Introduction IDENTIFICATION DIVISION ENVIRONMENT DIVISION CONFIGURATION SECTION INPUT-OUTPUT SECTION DATA DIVISION Data-item (variable) Declaration COBOL LEVEL Number COBOL Data-name and FILLER COBOL PICTURE clause and Data types COBOL EDITING Code characters COBOL VALUE clause Internal Data Represenataion in Mainframe. BCD and Binary Packed Decimal and Zoned Decimal Floating point binary number COBOL USAGE Clause SYNCHRONIZED/SYNC clause and slack bytes JUSTIFIED/JUST clause REDEFINES clause RENAMES clause (Level 66 Item) LEVEL 77 Data Item CONDITION NAME (LEVEL 88 Item) SIGN Clause Nameless data description entry FILE SECTION WORKING-STORAGE SECTION LOCAL-STORAGE SECTION LINKAGE SECTION PROCEDURE DIVISION Structure COBOL Verbs MOVE Verb Group Move using MOVE Quilification of Data Name in MOVE MOVE CORRESPONDING Option MOVE Reference Modification or Substring Move De-Editing using MOVE Aithmatic Verbs - Overview ADD Verb SUBTRACT Verb MULTIPLY Verb DIVIDE Verb ROUNDED Option ON SIZE ERROR Option ADD CORRESPONDING & SUBTRACT CORRESPONDING COMPUTE Verb DISPLAY verb ACCEPT Verb CONDITIONAL Verb : IF Categories of COBOL statements INITIALIZE Verb STOP RUN EXIT PROGRAM GO BACK "EXIT" and "END PROGRAM" Control Statements Intro Selection Statements IF ELSE and Nested IF EVALUATE Statement Iteration Statements Simple PERFORM In-line PERFORM PERFORM THRU/THROUGH PERFORM TIMES PERFORM UNTIL PERFORM VARYING PERFORM WITH TEST BEFORE/AFTER PERFORM for Multi-dimensional arrays Jump Statements CONTINUE Statement NEXT SENTENCE GO TO ALTER Statement String Handling in COBOL INSPECT EXAMINE STRING UNSTRING ARRAY (or TABLE) Single Dimensional ARRAY OCCURS Clause Two Dimensional ARRAY SUBSCRIPT ARRAY INDEX and INDEXING SUBSCRIPT vs INDEX SET Verb Sequential search:"SEARCH" Binary search:"SEARCH ALL" SEARCH vs SEARCH ALL FIles processing Terminologies File Handling Steps Step 1: File Allocation Step 2: File Definition Step 3: OPENing file Step 4: Processing of File READ Statement WRITE Statement REWRITE Statement START Statement DELETE Statement Step 5: CLOSEing file File Error Handling FILE Status Codes COPY Verb for Copybook Sub-programming and Calls Static Call and Dynamic Call Nested Programs END PROGRAM Statement IS GLOBAL clause IS EXTERNAL Clause IS {COMMON / INITIAL} PROGRAM SORT MERGE COBOL Program Lifecycle Compiling & Running COBOL Program COBOL – Database Interface concepts Embedded SQL DB2 Application Programming Host variables DCLGEN SQLCA SQL Queries DB2 Cursors INTRINSIC functions LE and LE callable services COBOL Performance Tuning tips VSAM Tutorial
Introduction VSAM Overview VSAM Cluster Data Componenet, CI, CA Index Componenet VSAM Splits and Spanned records Data set organization techniques KSDS ESDS RRDS LDS Comparison of VSAM types AMS Overview IDCAMS Utility IDCAMS DEFINE CLUSTER Command Defining KSDS Defining ESDS Defining RRDS Defining LDS IDCAMS REPRO Command Loading KSDS Loading ESDS Loading RRDS IDCAMS PRINT Command IDCAMS ALTER Command IDCAMS DELETE Command IDCAMS LISTCAT Command IDCAMS EXPORT Command IDCAMS IMPORT Command IDCAMS MODAL Command Alternate Index Overview Defining Alternate Index Building Index Defining Path VSAM Status codes DB2 Tutorial
DB2 Introduction What is DB2? DB2 Features DB2 Versions and History DB2 vs VSAM DB2 Terminology DB2 and Mainframe DB2 Architecture DB2 Subsystem DB2 Address Spaces DB2 Components DB2 Buffer Pools DB2 Logging DB2 Catalog Database Tablespace Table Index View Alias Synonym Sequence DB2 Object Relationships DB2 Data Types NULL Values What is SQL? DDL DML DCL SELECT INSERT UPDATE DELETE COMMIT and ROLLBACK WHERE Clause Comparison Operators AND OR NOT IN BETWEEN LIKE IS NULL DISTINCT ORDER BY CASE Aggregate Functions Scalar Functions GROUP BY HAVING INNER JOIN OUTER JOIN SELF JOIN Subqueries EXISTS UNION and UNION ALL Creating Tables CREATE TABLE ALTER TABLE DROP TABLE Tablespace Introduction Tablespace Types Partitioned Tablespaces Universal Tablespaces Tablespace States What is an Index? Index Types Unique and Non-Unique Index Clustering Index Composite Index Primary Key Foreign Key UNIQUE CHECK Referential Integrity COBOL and DB2 Embedded SQL EXEC SQL Host Variables SQLCA DB2 Precompiler DBRM DB2 COBOL Compile Process DB2 Program Structure What is a Cursor? DECLARE CURSOR OPEN FETCH CLOSE Cursor with COBOL Cursor with UPDATE Cursor with DELETE Cursor Error Handling SQLCODE SQLSTATE SQLCA SQLCODE +100 SQLCODE -803 SQLCODE -805 SQLCODE -811 SQLCODE -818 SQLCODE -911 SQLCODE -913 DB2 Error Handling in COBOL DBRM Package Collection Plan BIND PACKAGE BIND PLAN REBIND DSN Command IKJEFT01 DB2 Batch JCL DB2 Compile and Bind Process LOAD UNLOAD REORG RUNSTATS COPY RECOVER CHECK DATA CHECK INDEX DB2 Utility JCL Common Production Issues DB2 Job Failures DB2 Locking Lock Types Deadlocks Timeouts Isolation Levels DB2 Recovery DB2 Logs Image Copies EXPLAIN Access Paths Performance Tuning Stored Procedures Triggers CTE MERGE Temporary Tables Partitioning DB2 Security GRANT and REVOKE Real-World DB2 Scenarios DB2 Interview Questions SQL Coding Questions Production Support Scenarios CICS Tutorial
CICS Introduction What is CICS? Why CICS is Used CICS Features CICS vs Batch Processing CICS Terminology CICS Regions CICS Transactions CICS Tasks CICS Versions and History CICS Architecture CICS Region CICS Address Spaces CICS Components CICS Transaction Manager CICS Program Manager CICS Storage Manager CICS File Control CICS Temporary Storage CICS Transient Data CICS Communication What is a Transaction? Transaction ID Transaction Lifecycle Task vs Transaction CICS Command Structure EXEC CICS CICS Command Categories CICS Resource Definitions Common CICS Commands COMMAREA COBOL and CICS CICS-Enabled COBOL Program EXEC CICS Statements CICS Translator CICS Precompile Process CICS Compile and Link DFHEIBLK DFHCOMMAREA CICS Program Structure CICS COBOL Example What is BMS? BMS Maps Physical Map Symbolic Map Mapset DFHMDF DFHMDI DFHMSD Screen Attributes MDT SEND MAP RECEIVE MAP BMS COBOL Program CICS File Control VSAM and CICS READ WRITE REWRITE DELETE STARTBR READNEXT READPREV ENDBR File Definitions File Status Codes Temporary Storage (TS) TS Queues WRITEQ TS READQ TS DELETEQ TS Intra-Partition TS Extra-Partition TS Transient Data (TD) WRITEQ TD READQ TD TD vs TS COMMAREA CHANNEL CONTAINER LINK XCTL RETURN Program Control Static vs Dynamic Calls LINK vs XCTL Passing Data Between Programs Pseudo-Conversational Programming CICS and DB2 Embedded SQL in CICS CICS DB2 Program Structure SQLCA DB2 Connection DB2 Plan DB2 Thread COMMIT in CICS CICS and DB2 COBOL Example CICS DB2 Error Handling Conversational Processing Pseudo-Conversational Processing START RETURN TRANSID RETRIEVE STARTBR Task Control Transaction Flow Synchronization ENQ and DEQ CICS Error Handling RESP RESP2 HANDLE CONDITION HANDLE ABEND HANDLE AID IGNORE CONDITION EIBRESP EIBRESP2 EIBTRNID EIBTASKN Common CICS Errors CEDF Debugging CICS Resources Transaction Definitions Program Definitions File Definitions TD Queue Definitions TS Queue BMS Map Definitions DB2 Definitions CEDA CEDB CEDC Resource Installation CICS Recovery CICS Restart Warm Restart Emergency Restart Dynamic Backout Unit of Work Syncpoint Abend Handling Common Production Issues CICS Job Failures File Problems Transaction Problems Production Troubleshooting CICS Performance CICS Monitoring CICS Statistics CICS Trace Storage Management Threadsafe Programming CICS Security RACF and CICS Multiregion Operation (MRO) Inter-System Communication (ISC) CICS Web Services CICS TCP/IP CICS Modernization CICS COBOL Banking Application CICS and DB2 Application Customer Inquiry Transaction Account Update Transaction CICS Menu-Driven Application End-to-End CICS Project CICS Scenario-Based Questions CICS COBOL Interview Questions BMS Interview Questions CICS DB2 Interview Questions Production Support Questions CICS Coding Questions TSO Tutorial
ISPF Tutorial
MVS Tutorial
Endevor Tutorial
ChangeMan Tutorial
IMS Tutorial
REXX Tutorial
CLIST Tutorial
QMF Tutorial
Common Abends/Errors
Abend Codes Overview S0C7 - Data Exception S0C4 - Protection Exception S0C1 - Operation Exception S322 - CPU Time Exceeded S806 - Load Module Not Found S80A - Out of Storage S222 - Job Cancelled S213 - Open Error SB37 - Out of Space S722 - Sysout Limit Exceeded U4038 - Language Environment Abend ASRA - CICS Program Check AICA - CICS Runaway Task
Mainframe Interview Q&A
Mainframe Quiz
Mainframe Online Tests
Mainframe Memes
Mainframe Tools
Contact us
About us
Backward
