Mainframe Training and Courseware

This course is a combination of lecture, discussion and hands-on lab sessions. This course covers the various zSeries Hardware components and the various z/OS Software components. The major capabilities of Database Management systems and Transaction Processing systems are presented as 2 major application components of z/OS for providing end-use services.
 More Info

The Analysis portion presents the major Structured System Analysis tools used to improve the requirements definition / analysis activities of a project - Data Flow Diagrams, Data Dictionary, Processing Specifications, Data Structure Diagrams.
 More Info

This course is intended for senior analysts, project team leaders, and project managers who need to build and/or sharpen their Project Management skills and to run successful projects.
 More Info

This series of course, gives the Entry-Level programmer a solid basis in each of the technical areas.
 More Info

First, the concepts of DB2 are presented and discussed. The major features of the Structured Query Language (SQL) are presented as the means to access DB2 data (and to create and secure DB2 components).  Several of the “special features” of SQL are presented. Optionally, guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.
 More Info

Review overall DB2 SQL Performance Considerations. Discuss the issues in Performance “problems”. Discuss the "behavior" or “mis-behavior” of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed via the EXPLAIN Plan / VISUAL EXPLAIN feature. The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail.   
 More Info

The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build “custom:” reports from DB2 data using the extensive powers of the QMF FORMs panels. Use several other QMF facilities such as Help, Retrieve/”?”, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.
 More Info

First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered.
 More Info

First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components).  Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered. 
 More Info

The course covers, in detail, all aspects of using VSAM and IDCAMS that are important to the senior application COBOL programmer in new system development or maintenance.  The class lab is designed to provide an in-depth work experience. 
 More Info

The course is a series of lectures, discussions, written exercises, and programming exercises dealing with the concepts, capabilities, and coding for IMS Transaction Monitor programs. Students will design terminal screens and code Message Format Services (MFS) macros to implement those screen designs. The students will modify a skeleton COBOL program to receive an input message (from an on-line terminal), process that message, and send a message (to an on-line terminal), change screen attributes, send a message to another program, and use PFF keys. The Batch Terminal Simulator (BTS) is used for Program testing.
 More Info

This is a lecture, discussion, and hands-on programming course covering IMS/VS database programming concepts, design, coding, testing and debugging. Segment Search Arguments (SSAs) are covered in detail along with emphasis on checking the PCB mask to understand the results of IMS database calls. Each workshop is preceded by lecture, discussion, and written exercise sessions.
 More Info

This course covers the use of File-AID and manipulating MVS file with capabilities above and beyond those of ISPF. The class attendees are guided through the File-Aid menu structures and extensive capabilities. Record selection, browsing, allocating files (including VSAM) and editing files are discussed.
 More Info

The course starts with an overview COBOL for z/OS and many of the differences from previous version of COBOL including the callable functions. An overview of the Language Environment / 370 (LE/370) is presented along with how some of its features can benefit the COBOL for z/OS programmer. Extensive workshop sessions utilize many of the COBOL for z/OS features that are different from previous COBOL environments.  The LE/370 features are also used in workshop sessions.
 More Info

The course starts with an overview of structured programming concepts.  The four divisions of a COBOL program and their functions are reviewed in detail.  Students will gain hands on experience through a series of class discussions and workshop exercises that include several modifications to a skeletal COBOL program.  File processing, program looping, conditional program statements, and table processing are covered in detail. Development of clear and understandable program designs is stressed along with building maintainable programs. Program debugging techniques are also discussed.
 More Info

This course introduces students to the basic skills required to write assembler programs using the IBM High Level Assembler (HLASM). Students will code Assembler programs.
 More Info

This course is a combination of lecture, discussion and hands-on lab sessions. First, an overview of JCL is given which describes the purpose of JCL, its relationship to the operating system, and the format / rules for coding. Next, the JOB, EXEC and DD statements are covered extensively. The purpose and use of each statement is described in detail; along with many parameters available to provide information to the operating system. Procedures and several commonly used IBM utilities are covered in detail. Recognize, analyze & correct typical ABENDs “caused” by JCL “errors”.
 More Info

Review overall DB2 SQL Performance Considerations. Discuss the issues in Performance “problems”. Discuss the "behavior" or “mis-behavior” of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed via the EXPLAIN Plan / VISUAL EXPLAIN feature.
 More Info

The concepts of DB2 are briefly presented and discussed.  The Structured Query Language (SQL) is presented as the means to access DB2 data.  Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build “custom:” reports from DB2 data using the extensive powers of the QMF FORMs panels. Use several other QMF facilities such as Help, Retrieve/”?”, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.
 More Info

The concepts of DB2 are presented and discussed. Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components).  Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered.
 More Info