title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
LearnQuest z-Systems Developer - Intermediate Badge
Course Description
Overview
This curriculum consists of lectures, hands-on computer lab exercises, classroom discussion, a team case study with assignments, quizzes (simply called checkups), knowledge assessments (similar to tests), skill assessments (hands on practicum), and recommended textbook reading selections. Each day assumes seven hours of classroom work, with one hour for reading, administrative tasks, and breaks between lectures.Each student receives the following:
- Mainframe Essentials syllabus
- COBOL Programming syllabus
- CICS Programming syllabus
- DB2/SQL Programming syllabus
- Syncsort syllabus
- It is recommended (though not required) that a copy of Murach’s Mainframe COBOL textbook (authored by Mike Murach, Anne Prince, Raul Menendez) be provided to the students. If this is done, coordinated page numbers of recommended reading are included in this outline.
Objectives
- Explain and understand the agenda for the Mainframe bootcamp
- Describe basics of Mainframe Operating System, Hardware, Software and Networks
- Explain how data is stored both physically and logically, and explain fields, records and files, as well as datasets and data bases
- Describe how the mainframe computer gets work done via JCL and JES
- Explain the purpose of and differences between Sequential & Partitioned Data Sets
- Know how to run basic TSO commands
- Describe TSO and ISPF purpose, functions and modes
- Be able to log on and off and run basic TSO commands, as well as enter and exit ISPF
- Browse existing files
- Perform basic Edit functions, including line commands
- Perform advanced Edit functions, including primary commands
- Be able to allocate, delete, rename, copy, move, list, compare and view sequential, partitioned, and VSAM datasets using ISPF Utilities
- Create VSAM data sets using ISPF Option 3
- Understand how to calculate SPACE requirements correctly
- Know purpose of JCL
- Understand what a job stream is
- Code JOB and EXEC statements correctly
- Allocate new and old datasets
- Understand how to point files to printers and dummy devices
- Understand the Data Control Block and associated JCL keywords (e.g. LRECL)
- Building a single step JOB on TSO and using the output viewing facility (SDSF).
- Describe how and when files are allocated and deallocated within a job
- Find messages within JCL output showing the allocation and deallocation of files
- Describe how QSAM allocates, accesses, and uses sequential files and partitioned datasets
- Understand the function of system libraries (e.g. SYS1.PROCLIB, SYS1.PARMLIB, SYS1.CMDLIB, SYS1.LINKLIB)
- Explain SDSF, its queues (Input, Output, Held), and how to navigate it
- Assess Basic Mainframe Skills (TSO/ISPF, JCL)
- Use Generation Data Groups and Generation Data Sets
- Use Referbacks, Concatenated Datasets, and SMS JCL Parameters
- Run necessary IDCAMS to create GDG file
- Understand Storage Management and how DFSMS and DFHSM manage datasets and the JCL parameters available to facilitate DFSMS
- Be able to exploit six common IBM Utilities
- IEBCOPY
- IEBGENER
- IEHPROGM
- IEFBR14
- IBM SORT (aka ICEMAN)
- IDCAMS
- Convert a multi-step JCL to a Catalogued Procedure
- Use Instream and Cataloged Procedures
- Provide symbolic variables for JCL procs
- Understand how JCL from the catalogued procedure is merged with the run JCL
- Successfully override EXEC and DD statements
- Demonstrate a strong understanding of TSO, ISPF, and JCL and the ability to use features of each
- Describe Sequence, Selection, Iteration
- Use basic flowcharting symbols
- Be able to code a simple flowchart
- Be able to create a task analysis (pseudocode)
- Be able to create a Test Plan
- Create and present logical flowchart solution with a team
- Understand control break processing
- Be able to code a flowchart that includes control break processing
- Explain general COBOL Syntax
- Describe the compile and link process
- Code the Identification, Environment, Data Division
- Understand three different ways numbers are stored on mainframe files (binary, packed decimal, and display) and how arithmetic is done with each
- Utilize picture clause, usage clause, and data categories within a COBOL program, including differences between display, COMP-3 and binary (COMP) numbers
- Identify statements, sentences, scope terminators, paragraphs, sections
- Compile, Link, and Test a simple COBOL program
- Explain end-of-file and loop processing
- Utilize coding standards and good structure and
- Use switches properly within a program
- Explain how IF/THEN/ELSE and EVALUATE work
- Show how PERFORM statement works and why it is important
- Understand standard report structure (header, body, footer)
- Know how to use numeric editing masks and code carriage control in report layouts
- Complete COBOL program assignments using discipline of good design (flowcharts and/or pseudocode) and test plans prepared in advance
- Understand testing strategies
- Know available debugging tools for solving abends
- Understand how to fix common programming errors
- Understand basic arithmetic statements
- Utilize counters in a program
- ROUND arithmetic results
- Know how to use control breaks and page breaks
- Know how to use grand totals
- Utilize module modularization with CALL, USING and LINKAGE
- Understand differences between static and dynamic modules
- Use CALL BY REFERENCE, CALL BY CONTENT, CALL BY VALUE, ON EXCEPTION, ON OVERFLOW
- Describe basic table terminology
- Load a table from an external file
- Assess COBOL Skills
- Use subscripts and indexes within a table
- Code the SEARCH and PERFORM varying statements to search tables
- Describe the sort / merge process
- Add the necessary code to the Environment Division, Data Division and Procedure Division to run the SORT/MERGE utility
- Modify JCL to successfully run a COBOL
- Understand purpose of Intrinsic Functions
- Identify the six types of Intrinsic Functions (calendar/date, character, mathematical, statistical, financial, trigonometric)
- Invoke intrinsic functions within a COBOL program
- Ability to use FileAid or other screen utility to create VSAM and GDG datasets
- Provide IDCAMS commands for deleting and defining a VSAM dataset
- Run necessary IDCAMS to load VSAM KSDS file
- Code COBOL to search a VSAM file
- Understand how COBOL programs handle VSAM files
- Describe differences between QSAM and VSAM
- Code COBOL to update a VSAM file
- Ensure Case Study is producing correct results
- Prepare presentations
- To communicate what students have learned, both individually and with their Case Study team
- Successfully present technical system development in a way that connects with a mixed audience
- Create and use VSAM Alternate Indexes
- Understand purposes of Syncsort, how to invoke it, how Syncsort executes SORT, MERGE, and COPY, and the control statements (e.g. INCLUDE, MERGE, OMIT, SORT, SUM)
- Know the three phases of Syncsort and JCL requirements
- Understand how INCLUDE/OMIT works in phase one
- Understand how SORT, MERGE, COPY, and SUM work in phase two
- Know how to select fields & reformatting output with OUTREC
- Know how to perform arithmetic calculations and edits
- Know how to search and replace using CHANGE
- Know how to produce multiple files using OUTFIL
- Know how to call a subroutine from Syncsort or Syncsort from a program
- Understand CICS environment and services
- Know basic system definition tables (e.g. PCT, PPT, FCT, TCT, SNT)
- Understand Pseudo-Conversational program design
- Know how to pass data between CICS programs
- Understand Command Level Interface (CICS commands, EIB, CECI, Exceptional Condition Handling)
- Know how to transfer control between CICS programs (LINK, XCTL, RETURN, LOAD, RELEASE, ABEND) and use the Execution Diagnostic Facility (CEDF)
- Know how to send messages between the terminal and program
- Be able to code and interpret BMS maps (Mapset, Maps, Fields)
- Understand how to assemble the Mapset and the difference between the CSECT and the DSECT
- Understand the flow of transaction processing
- Compare Conversational and Pseudo-conversation coding techniques
- Know how control flows from one program to another (RETURN, LINK, XCTL)
- Be able to communicate between CICS programs
- Understand how information is passed between programs in the COMMAREA
- Code CICS requests to Retrieve, Update, Delete, Insert, and Browse Files
- Understand possible performance problems and file integrity problems during file processing
- Define Logical Unit of Work (LUW) and know how to protect CICS resources
- Understand how to create, retrieve, and delete Temporary Storage queues
- Create, retrieve, and delete Transient Data services
- Explain serialization (ENQ/DEQ) and initiating transactions in the future (STARTRETRIEVE)
- Understand why data modeling is used and the benefits of this practice
- Define the three types of data models: Conceptual, Logical and Physical
- Describe the normalization process (1NF, 2NF, 3NF)
- Explain primary keys,foreign keys, and referential integrity
- Create a complex data model and validate against a key set of business requirements.
- Describe the overall purpose of a database management system and its components
- Describe the Relational Model of data using common relational terminology
- List the manipulative operations and give examples of each
- List the data types supported by DB2 and describe their associated defaults
- Define DB2’s support for missing information (nulls)
- Code restricts and projects in SQL using basic predicates and expressions
- Become familiar with SPUFI for coding and running queries
- Define the functionality of special registers in DB2
- Code SQL statements using compound conditions with boolean operators.
- Code where-clause predicates utilizing special SQL keywords for restriction
- State the difference between scalar functions and column functions.
- Define the basic families of string, numeric, and date/time functions
- Code SQL operations that implement summarization via the GROUP BY clause and restrict groups as necessary with the HAVING clause
- Code single-row and multiple-row INSERT statements.
- Define the concept of the join operation in terms of the rows and columns of the tables involved utilizing the two syntactical approaches
- State the methods available for qualifying ambiguous column names
- Describe the approach for developing join operations involving more than two tables
- Describe the execution of SQL statements with subqueries in the WHERE clause
- Describe the operation of correlated subqueries and contrast them to the non-correlated form
- Use the EXISTS quantifier with correlated subqueries and compare its operation to non-correlated subqueries using IN
- Describe the similarities and differences between join and subselect
- Define basic UNION operations and differentiate between UNION and UNION ALL
- State the requirement for self-joins and the procedure to accomplish them in SQL
- Describe the operation of the outer join and define their relationship to inner joins
- Code searched update and deletes that affect one row, many rows, or all rows of a table
- List the steps in program development.
- Relate DB2 datatypes to COBOL elementary items.
- Use SELECT...INTO for retrieving single rows into working storage variables.
- State the approach and methods associated with the DECLARE TABLE statement.
- Define and use the fields of the SQL communications area in programming situations.
- State the steps in program preparation and describe the inputs & outputs of each step.
- Describe the approaches available for binding packages and plans.
- Use INSERT, searched UPDATE, and DELETE within an embedded program to modify rows in a DB2 table
- Use indicator variable(s) to handle nulls
- Understand unit of work and use of COMMIT and ROLLBACK
- Describe the need for a cursor
- Relate the DECLARE CURSOR statement to the result table of the associated SELECT
- Process the rows of the cursor one at a time using OPEN, FETCH, and CLOSE
- Describe the positioned update (WHERE CURRENT OF) and contrast it with the searched update presented earlier
- Relate cursor processing to the scope of a unit of work
- Describe the purpose of CURSOR WITH HOLD
- Explain how Indicator Variables are used within a program
- Code Dynamic SQL statements, prepare them and execute them
- Describe Cursor Types (Non-Scrollable, Insensitive Scroll, Sensitive Static Scroll, Sensitive Dynamic Scroll, and Asensitive)
- Explain the difference between WITH HOLD and WITH RETURN options
- List what the contents of SQLWARN1, SQLWARN4, and SQLWARN5 will be with cursors
- Know how to FETCH FIRST, LAST, CURRENT, PRIOR, NEXT, ABSOLUTE, and RELATIVE rows
- Be able to deal with UPDATE and DELETE “holes” and interpret SQLCODES of +222, +223, +224, +535, -222, -223, and -224
- Code Cursor Declare statement using Rowset Positioning
- Code Fetch Syntax for row sets
- Implement Multi-row FETCH and INSERT
- Code SQL MERGE Statement
- Know how Stored Procedures are used
- Explain the use of Views, Nested Table Expressions, and Common Table Expressions
- Show how UNION can be used anywhere
- Utilize Intersect and Except queries
- Code GROUPs with multiple sets
- ROLLUP and CUBE
- Describe the basics of SQL Performance
- List Guidelines for Good Performance
- Recognize the difference between Stage 1 and Stage 2 Predicates
- Use the EXPLAIN facility for tuning
- Explain function of the DSN_STATEMNT table
- Interpret and determine likely performance for various SQL queries
- Explain the 3 Different JOIN Methods
- Analyze Explain information for Subqueries and UNION Queries
- Analyze Application Program Performance
Audience
- Individuals responsible for developing and maintaining applications on the mainframe using COBOL as the primary language.
Prerequisites
- None, though strong business skills and logical skills are recommended.
Topics
- Introduction to the Mainframe
- Hardware (terminals, tape drives, disk drives, CPU, controllers, printers)
- Software (system and application)
- Networks (controllers, modems, SNA)
- Storage management (DASD, SMS)
- Overview of JCL and JES
- Multiprogramming, multitasking, address spaces, paging
- Online vs. batch
- TSO Overview
- Introduction to Native TSO, including special keys (e.g. ATTN, PA1, PF1)
- Accessing Sequential and Partitioned Datasets on TSO
- Using TSO Commands
- ISPF Overview
- ISPF Options
- ISPF Browse
- Labs
- Log on, browse the catalog and some files
- Navigate TSO, Execute TSO commands (e.g. LISTALC, LISTCAT, LISTDS)
- Recommended Textbook Reading: Chapter 17, pages 486-508
- Knowledge Assessment Quiz – 30 minutes
- 01 Mainframe Overview
- ISPF Browse
- Edit – Primary Commands
- Edit – Line Commands
- Labs (approximately 120 minutes) - Browse files, create members of an existing partitioned dataset, practice edit line commands, and edit primary commands
- Recommended Textbook Reading: Portion of chapter 18, pages 512-523
- ISPF Library Utility
- ISPF Dataset Utility
- Calculating SPACE requirements (blocks, track, cylinders)
- ISPF Copy/Move Utility
- ISPF Dataset List Utility
- ISPF SUPERC Utility
- Introduction to Spool Display and Search Facility (SDSF)
- Labs (approximately 120 minutes)- search for files, compare files, create .COBOL and .JCL partitioned data sets, create, rename and delete members, create VSAM datasets
- Recommended Textbook Reading: Portion of chapter 18, pages 512-523
- Knowledge Assessment Quiz – 20 minutes:
- 02 TSO/ISPF
- Introduction to JCL (approximately 220 minutes)
- JOB Statement
- EXEC Statement
- Labs (approximately 180 minutes)- Coding JOB statements at end of chapter and building valid JOB statement on TSO, coding EXEC statements at end of chapter, submitting jobs to system and viewing in SDSF
- Recommended Textbook Reading: portion of Chapter 18, pages 524-525
- Knowledge Assessment Quiz – 20 minutes:
- 03 JCL Part 1
- DD Statements (many possibilities, several dispositions, space requirements)
- Lab – (approximately 120 minutes)-Coding DD statements at end of chapter, build and run 1 step job and view output
- Recommended Textbook Reading: portion of chapter 18, pages 530-541 and portion of chapter 12, pages 332-337
- Knowledge Assessment Quiz – 20 minutes:
- 04 JCL Part 2
- Skill Assessment #1 – 90 minutes:
- Students will demonstrate their ability to perform basic mainframe skills with TSO, ISPF, and JCL, will document their experience in a Word document and store the document in a location accessible to the instructor and manager.
- Explain role of Job Entry Subsystem (JES) in tracking job submission, selection (initiators), execution, output routing, and purge
- Reviewing Job Output in Detail
- Review and expand Spool Display and Search Facility (SDSF)
- Labs, JCL Basics (approximately 120 minutes)- identifying allocation and deallocation of resources, QSAM messages, system libraries with several submitted jobs
- Skill Assessment #1 – 90 minutes:
- Basic Mainframe Skills (TSO/ISPF/JCL)
- Advanced Data Usage (GDG, DFSMS, DFHSM, IDCAMS) (approximately 120 minutes)
- Labs (approximately 280 minutes) - Code and successfully run four jobs using GDGs, one job using referback(s), and one job using concatenated datasets
- JCL Utilities (approximately 180 minutes)
- Lab – Debugging Derby (approximately 280 minutes)- Code and successfully execute a 5-step job using 5 of the 6 utilities (IDCAMS, IEFBR14, IEHPROGM, IEBGENER, SORT), code and successfully execute a job using IEBCOPY
- JCL Procedures (PROCs)
- Labs (approximately 300 minutes)- Convert a 5-step job (IDCAMS, IEFBR14, IEHPROGM, IEBGENER, SORT) to a catalogued procedure, examine the details of JCL merged from the procedure with the run JCL, create JCL procedure to run COB10x and COB60x programs, run JCL procedure with symbolic variables
- JCL Procedures (PROCs) (approximately 390 minutes)
- Labs (approximately 180 minutes)- Run JCL procedure with symbolic variables and overrides
- Skill Assessment #2 – 90 minutes:
- Students will demonstrate their ability to perform mainframe skills with TSO, ISPF, and JCL, will document their experience in a Word document and store the document in a location accessible to the instructor and manager. This will include editing, using ISPF utilities, running JCL, solving JCL errors, and using catalogued procedures.
- Program Development (approximately 210 minutes)
- Structured and Top-Down Programming
- Flowcharts, Structure Charts, Pseudo Code, and Test Plans
- Lab- Logic Basics (approximately 120 minutes)- “Logic 1” assignment from COBOL chapter 17
- Case Study (approximately 90 minutes): Team meeting #1, Simple logic assignment, and preparation for presentation
- Recommended Textbook Reading: Portion of chapter 3, pages 100-103, chapter 4, pages 106-144
- Presentation by Case Study Groups (simple logic exercise) (approximately 300 minutes)
- Control Break Processing
- COBOL Essentials
- COBOL Overview
- Lab – Logic Basics (approximately 120 minutes): “Logic 2” assignment (control break)
- Recommended Textbook Reading: Chapter 4, pages 108-109
- COBOL Definition (approximately 260 minutes)
- Lab (approximately 60 minutes)- Identify numeric data in display, COMP-3 and binary format
- Case Study (approximately 90 minutes): Second team meeting, research and construct tax logic case study, document results, and store in a location accessible to students, instructor, and manager.
- Textbook Recommended Reading: Chapter 1, pages 1-23, ch. 3, pages 82-85, ch. 6, pages 190-199 & 206-211
- Knowledge Assessment – 20 minutes:
- COBOL Chapter 3 Review
- Simple Procedures
- Explain COB01 Lab
- Textbook Recommended Reading: Portion of chapter 3, pages 86-99, chapter 3, pages 82-85, chapter 6, page 200-205
- Knowledge Assessment – 30 minutes:
- COBOL Chapter 4 Review
- Lab (approximately 110 minutes)- COB01: Create a simple COBOL program and fix compile errors
- Finish lab (COB01) from previous day; it is due today
- Review COB01 Lab using Lab Solution (approximately 120 minutes)
- Editing and Branching, and Explain COB10 Lab
- Skill Assessment #3 – 90 minutes: Students will demonstrate their ability to add to a COBOL program the necessary verbs to process files, and their ability to compile a program (fixing diagnostics as necessary), link it, and execute it with successful output.
- Knowledge Assessment – 20 minutes:
- COBOL Chapter 5 Review
- Labs (approximately 210 minutes): Create a flowchart / pseudocode for a COBOL edit program (COB10), create a test plan with 10 additional records, code it, and run it successfully
- Textbook Recommended Reading: Chapter 5, pages 152-179, chapter 3, pages 82-85, chapter 6, page 200-205
- Structured COBOL (approximately 180 minutes)
- COBOL Reports
- Explain COB20 Lab
- Textbook Recommended Reading: Chapter 3, pages 70-99
- Knowledge Assessment – 20 minutes:
- COBOL Chapters 7 & 8 Review
- Lab (approximately 220 minutes)- Receive approval from instructor for your flowchart / pseudocode before starting Procedure Division coding!
- Finish lab (COB10x) from previous day; it is due today.
- Begin working on the flowchart / pseudocode for a COBOL program (COB20x), create a test plan, begin coding.
- Review COB10 program solution and review requirements of logic and test plans (approximately 60 minutes)
- Case Study (approximately 90 minutes): Third team meeting, begin coding case study logic with flowcharts and/or pseudocode and test plan
- Lab (approximately 270 minutes)-
- Finish lab (COB10x) from previous day; it is due today
- Continue coding and testing a COBOL program (COB20x)
- Interpreting the Compiler Listing (approximately 160 minutes)
- Testing and Debugging
- Common System Abend Codes
- Textbook Recommended Reading: Chapter 18, pages 542-545
- Lab – Debugging Derby (approximately 150 minutes)- The “Debugging Derby” with teams, Teams execute 7 programs that don’t work, debug, fix, and re-test them
- Lab – (approximately 90 minutes)- Finish work on COB20
- Knowledge Assessment – 20 minutes:
- COBOL Chapter 6 Review
- COBOL Arithmetic (approximately 160 minutes)
- Review COB20x program solution
- Explain COB30 Lab
- Textbook Recommended Reading: Chapter 7, pages 220-239
- Knowledge Assessment – 15 minutes:
- COBOL Chapter 9 Review
- Case Study (approximately 75 minutes): Fourth TEAM meeting, finish coding case study logic (approximately 75 minutes)
- Labs (approximately 170 minutes)-
- Finish lab (COB20x); it is due today.
- Modify program (creating COB30x) to include arithmetic calculations, flowchart / pseudocode not required on this assignment, test plan is required.
- Control breaks, Page breaks (approximately 90 minutes)
- Review COBOL Reports chapter, Review COB30x program solution, Explain COB50 Lab (part 1)
- Textbook Recommended Reading: Chapter 4, pages 108-109
- Labs (approximately 240 minutes)- Finish lab (COB30x); it is due today; modify COB30x (creating COB50x) to put control break logic in place (when STATE changes) and page break logic in place (every 40 lines)
- Skill Assessment #4 (approximately 90 minutes)
- Given a set of programs that do not work, compile and run them, debug them, fix them, place results in a Word document and store it.
- Grand Totals (approximately 180 minutes)
- Discuss grand totals, Explain COB50 Lab (part 2)
- Textbook Recommended Reading: Chapter 4, pages 108-109
- Labs (approximately 240 minutes)-modify COB50x to put grand totals in place
- Calling other programs (approximately 70 minutes)
- Explain CALL Lab
- Textbook Recommended Reading: Chapter 11, pages 320-328
- Knowledge Assessment – 15 minutes:
- COBOL Chapter 10 Review
- Case Study (approximately 75 minutes): Fifth team meeting, finish coding called module (COB65x) for case study logic, pass at least GROSS-AMOUNT/SALARY and FED-TAX as variables, determine how you will test this (but do not fully implement yet)
- Lab (Approximately 260 minutes)-
- Modify COB30x to call COB40x for date and time (comment out your data/time logic in case you want to reuse this later on).
- Study COB40 to see how the time and date processing is done.
- Make this change to COB50 as well.
- If you are ahead of pace, contact instructor about COB15 specifications.
- Loading a Table (approximately 90 minutes)
- Table Structure
- Table Handling – Loading a table
- Case Study (approximately 120 minutes): Sixth team meeting, final testing for called module for case study logic
- Lab (approximately 210 minutes)- Write the first part of COB60x – loading the table using DISPLAYs to verify that every record has been loaded properly.
- Finish lab (revised COB30x); it is due today.
- Table Handling – Searching the Table (Serial and Binary) (approximately 200 minutes)
- Knowledge Assessment – 15 minutes:
- COBOL Chapter 11 Review
- Lab (approximately 220 minutes)-
- Continue coding COB60x to successfully search the table.
- Finish lab (COB50x); it is due today
- Sorting and Merging(approximately 90 minutes)
- Knowledge Assessment – 15 minutes:
- COBOL Chapter 15 Review
- Skill Assessment #5 (approximately 90 minutes)
- Add necessary code to COBOL program to perform arithmetic calculations
- Debug a different COBOL program where the report totals are not correct
- Lab (approximately 225 minutes)-
- Finish lab (COB70x); it is due today
- Begin coding CO70x to sort the data. Describe how you will create test data and a test plan to ensure this works correctly.
- Intrinsic Functions (approximately 90 minutes)
- Textbook Recommended Reading: Chapter 7, pages 220-239
- Labs (approximately 330 minutes)-
- Finish lab (COB70x); it is due today
- Modify COB60x to include one or more intrinsic functions
- Basic VSAM, IDCAMS (approximately 140 minutes)
- VSAM for COBOL Programmers – part one
- Explain COB80 program – VSAM Search
- Textbook Recommended Reading: Chapter 19, pages 556-579
- Labs (approximately 280 minutes)-Load data into VSAM KSDS file using IDCAMS and/or FileAid, code COB80x, VSAM search program, create JCL to run program COB80x
- VSAM for COBOL Programmers – part two (approximately 135 minutes)
- Explain COB90 program – VSAM Update
- Textbook Recommended Reading: Chapter 14, pages 404-411, Chapter 19, pages 547-555
- Case Study (approximately 75 minutes): Seventh TEAM meeting, prepare presentation for case study logic
- Labs (approximately 210 minutes)-
- Finish lab (COB80x); it is due today
- Code COB90x, VSAM update program
- Create JCL to run program COB90x
- Testing Test Plans for Case Study (approximately 60 minutes)
- Explain Presentations
- Case Study (approximately 180 minutes): Eighth TEAM meeting, prepare presentation for case study logic
- Labs (approximately 180 minutes)-
- Finish lab (COB90x); it is due today
- Testing for accuracy
- Final Preparation for Presentations
- Last minute preparation for teams presentations (approximately 60 minutes)
- Lectures (approximately 200 minutes): PVSAM Alternate Indexes, Presentations by teams (each approximately 30 minutes long, followed by 15 minutes of Questions and Answers)
- Note: Managers and other individuals from the company are usually invited to attend presentations, which begin approximately 9:30 a.m. Two teams present in the morning and two teams in the afternoon (assuming there are four teams). Attendees have opportunity to ask questions.
- Labs (approximately 160 minutes)- VSAM Alternate Index COBOL Program
- Syncsort Overview (Purpose, SORT, MERGE, COPY, Examples) (approximately 280 minutes)
- Syncsort Background (12 control statements (ALTSEQ, END, INCLUDE, INREC, MERGE, MODS, OMIT, OUTFIL, OUTREC, RECORD, SORT, SUM); 3 phases - Record Selection, Main process, Duplicate record elimination); JCL requirements (SYSIN, SORTIN, SYSOUT, SORTOUT, SORTWKn)
- INCLUDE/OMIT and SORT/MERGE
- Labs (approximately 140 minutes)- Code a basic sort using Syncsort, code a sort including INCLUDE,/MERGE/ SUM, include compound condition and multiple comparison
- OUTREC (approximately 280 minutes)
- Arithmetic calculations and edits
- REPLACE/SPLIT RESULTS
- Programming Interface
- Labs (approximately 140 minutes)-OUTREC, Arithmetic calculations and edits, REPLACE/SPLIT RESULTS, Programming Interface
- Introduction to CICS
- Programming Considerations (Table Definitions, Program Design, Pseudo conversational tasks, passing application data between CICS tasks)
- Command Level Interface
- Program Control
- Terminal Control (SEND, RECEIVE, CONVERSE)
- Knowledge Assessments
- CICS Overview
- Programming Considerations
- Command Level Interface
- Program Control
- Terminal Control
- Labs (approximately 30 minutes)- CICS Workshop #1 – CECI Exercise navigating a SEND MAP
- Basic Mapping Support (SEND MAP, RECEIVE MAP)
- Terminal Message Processing Support
- Communicating Between Programs (Through ‘RETURN’)
- Labs-
- Create and assemble a BMS map
- Write a simple program that puts out a map
- Communicating Between Programs (Continued)
- File Request Processing (Through 'READ FILE' )
- Labs-
- Write MAIN MENU program
- File Request Processing (Continued)
- LUW and Long Running Tasks
- Labs-
- Write CUSTOMER Maintenance program
- Temporary Storage Services
- Transient Data Processing
- Other CICS Functions and Features
- Labs-
- Write ORDER processing program
- Introduction to Modeling and Data Modeling
- Data Flow Diagrams
- Conceptual Data Modeling
- Normalization
- Labs (approximately 180 minutes)-Code COB90x, VSAM update program, create JCL to run program COB90x
- Skill Assessment #4 – Intermediate Mainframe (90 minutes)
- Online (mainframe) exercise requiring student to
- a.Purge output jobs no longer needed using SDSF
- b.Override JCL proc according to instructions
- c.Compress partitioned data sets, Compare two datasets to each other
- Relational Database Concepts (approximately 180 minutes)
- Basic Data Manipulation
- SPUFI
- Labs (approximately 90 minutes)-Basic Data Manipulation
- Knowledge Assessment – 60 minutes:
- Introduction to DB2 and SQL Review
- Intermediate Data Manipulation (approximately 210 minutes)
- Built-in Functions
- Aggregation
- Labs (approximately 210 minutes)-Intermediate Data Manipulation, built-in Functions
- Joins (approximately 120 minutes)
- Labs (approximately 200 minutes)-Join
- SQL Subqueries (approximately 120 minutes)
- Labs (approximately 200 minutes)-Non-Correlated Subqueries, Correlated Subqueries
- Set Operations (UNION, INTERSECT & EXCEPT)
- Data Modification
- Labs (approximately 210 minutes)- Set Operations (UNION, INTERSECT & EXCEPT), Data Modification
- Introduction to Embedded SQL(approximately 210 minutes)
- Program Preparation
- Using SELECT . . . INTO
- Labs (approximately 210 minutes)-Embedded SQL Workshop (Singleton Select)
- Using INSERT, searched UPDATE, and DELETE to modify rows (approximately 120 minutes)
- Using indicator variable(s) on SELECT and INSERT statements
- COMMIT, ROLLBACK, and unit of work processing
- Labs (approximately 210 minutes)- Embedded SQL Workshop (Update Program)
- Case Study (approximately 90 minutes):Tenth TEAM meeting, finalize presentation for case study logic
- Cursor Processing
- Labs (approximately 210 minutes)-Embedded SQL Workshop Lab – Using Cursors in a COBOL program to UPDATE and DELETE rows
- CURSOR WITH HOLD
- Indicator Variables
- Dynamic SQL
- Lab-Revise Cursor lab, using CURSOR WITH HOLD and Dynamic SQL statements
- Skill Assessment #5 – Running SQL queries in SPUFI and COBOL (120 minutes)
- Skill assessment via online (mainframe) exercise requiring student to
- a.Navigate DB2 Interactive facility to run queries using SPUFI
- b.Run SQL queries using SPUFI producing correct answers
- c. Add SQL statements to COBOL program providing correct results to program
- Non-Scrollable and Scrollable Cursors
- Lab-Revise Cursor lab, using Scrollable Cursor(s)
- Multi-Row Operations
- Native SQL Stored Procedures
- Lab-Revise Cursor lab, using Scrollable Cursor(s)
- Table Expressions
- SET Operations
- Advanced Grouping
- Advanced Functions (RANK, DENSE RANK, ROW NUMBER)
- Labs-Advanced Queries, including views, Nested Table Expressions, and Common Table Expressions, UNION in several advanced contexts, ROLLUP, and CUBE
- DB2 SQL Performance Introduction
- Performance Overview with Guidelines
- Stage 1 and Stage 2 Predicates
- Tuning Guidelines and Examples
- EXPLAIN Plan – TS, MIS, NMIS, IXONLY, SORT, Part Scan
- The DSN_STATEMNT_TABLE
- Improving SQL statements using EXPLAIN results
- Lab-Run EXPLAIN and analyze performance for several SQL queries
- The 3 JOIN Methods
- SubQuery Analysis - Single Valued, Multiple Valued, Correlated
- UNION Analysis - The “Good“ and the “Bad“ of UNION
- Application Program Performance Analysis – REOPT, Optimize for N rows, Dynamic SQL, PK & FK, Prefetch, Correlated Columns, Massive Batch Jobs, Massive Online Jobs
- VQUBE – Very Quick Upper Bound Estimate
- Accounting Trace and Performance Monitors
- Workshops: Run EXPLAIN and analyze performance for several SQL queries
Recognition
When you complete the Instructor-Led version of this course, you will be eligible to earn a Training Badge that can be displayed on your website, business cards, and social media channels to demonstrate your mastery of the skills you learned here.
Learn more about our Miscellaneous Badge Program →Related Courses
-
Professional Services
LQPS- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 0.00 USD
-
Introduction to Oracle Database 12c and SQL
DBOR-950- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration