Providing Technology Training and Mentoring For Modern Technology Adoption
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.
Student skills are refined for the areas of sequential file processing, program looping, conditional program statements, and table processing. Both external design documentation and internal program documentation are stressed as the key to building more maintainable, more understandable, and more reliable programs. The causes of program dumps are discussed along with solutions to the most common causes of program dumps. A program dump is reviewed in detail.
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.
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.
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.
The structure of VSAM will be discussed. Each of the three VSAM file types (KSDS, ESDS, RRDS) will be reviewed in detail showing the design and efficiency features of each. The concepts of Control Area (CA), Control Interval (CI), and other space management features will be covered, as will the features of Alternate Indexing (AIX) and alternate index access PATH (PATH).
All file structures will be related to the MVS/ VSAM space allocation and catalogs necessary to support the files.
IDCAMS will be fully discussed and used. Creating VSAM files using DEFINE CLUSTER will be described for all file types, as well as other IDCAMS functions of DELETE, PRINT, REPRO, LISTCAT, VERIFY and ALTER.
The workshop application will create fixed and variable length record VSAM files, load the files, create an alternate index and path, and read/insert/delete records using a COBOL program.
The LISTCAT command will be used to review the VSAM catalog information at critical points in the course.
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.
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.
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. The results of the DB2 EXPLAIN Plan / VISUAL EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access DB2 data. Extensive workshops allow the students to test the performance “goodness” of several SQL statements. The Performance Guidelines are applied to COBOL Application programs. Discuss how & when the Optimizer uses Filter Factors based on Valid Statistics & Defaults
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. QMF and/or SPUFI are used to execute SQL statements. DB2 database design and Referential Integrity (RI) are discussed.
This series of course, gives the Entry-Level programmer a solid basis in each of the technical areas.
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.
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. The Structured Analysis workshop sessions provide opportunities to practice the use of these major tools. The design portion of the class discusses the use of (the major Structured System Design tool) the Structure Chart. Two strategies are discussed for developing Structure Charts based on Data Flow Diagrams (Transaction- and Transform-Centered). Several quality standards are discussed for determining the "correctness" of a Structure Chart. A Structured Design workshop is used to practice developing Structure Charts; and determine of their "correctness".
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. Several Application Programming languages are reviewed to reveal their capabilities such as COBOL. Hands on demonstrations are provides for TSO/ISPF, JCL, SDSF, DB2 and COBOL as needed.
The course begins with a review of CICS Command Level Programming. The structure and flow of several working CICS Programs is discussed in detail.Basic Mapping Support (BMS) screens also reviewed in detail. A working CICS Applications is modified to add several NEW features. These new features include the use of PF Keys, changing screen field attributes, help facility for a screen and individual fields on the screen, application paging and error handling.Build a “large” application where several CICS programs and user screens interface together.The course consists of a series of lectures, discussions, class exercises, and with hands-on programming workshop problems.Build applications using the following additional CICS features such as - Storage Control, Paging Transactions, Online Printing, CICS System Information, EIB, system storage, DFHCOMMAREA, Changing field attributes, debugging tool such as InterTest or Xpediter
REXX is a powerful multi-purpose and user-friendly programming tool used to exploit many IBM and third-party operational products. It is the tool of choice in most (if not all) of today's larger data centres for those who need to implement new operational procedures both quickly and effectively. This three-day course is designed for TSO/ISPF users who wish to learn how to create and use programs in the REXX language. The course is taught combining formal classroom teaching with many practical exercises and problem scenarios, thus ensuring a full understanding.
This course will provide attendees with an accelerated learning approach to the broad scope of z/OS data storage management. This boot camp is designed for anyone new to storage administration or anyone that requires a comprehensive understanding of the z/OS data storage discipline for their particular role within technical support.
This four-day course is a complete introduction to the use of SMP/E for installing new software and applying changes to existing software (PTFs, APARs etc) for the z/OS environment. All the important aspects of using SMP/E are covered, including a detailed explanation of what happens 'under the covers'. The course contains valuable and extensive hands-on exercises that demonstrate all the major aspects of using SMP/E to install products and apply maintenance.
The skills taught in this course prepare the student to work on CICS/TS application projects. The student is introduced to basic CICS functionality and features, coding CICS Cobol programs and basic debugging strategies.
This class provides a variety of subject matter pertaining to the day to day operation of an IBM mainframe computer system. It covers both hardware and software related issues, from I/O configuration details including FICON connectivity, to the processor’s use of storage, to IPL considerations. Many aspects of a typical mainframe processing configuration are considered. Work flow through the system is covered, as are various problem determination issues such as when an I/O error related fault occurs.
This 5 day course will introduce students to the skills necessary to code PL/I programs in z/OS environments.
This course introduces and explains CICS Transaction Server (CICS/TS) to those who have limited or no knowledge of CICS but who need a clear understanding of what CICS is, what it does and how it does it. The course describes and explains the main concepts and facilities of CICS, and introduces the growing family of CICS server and client products that are available. This course is the essential first step for anyone wishing to work effectively in a CICS environment, and forms a solid foundation on which future CICS education can be based.
This course is intended for system programmers, application programmers, administrators, analysts, operators and others who need to increase their programming power through advanced REXX facilities. Skills learned can be applied to z/OS, Unix as well as vendor products that use REXX. Students will learn to use and manipulate compound variables in order to process REXX arrays, to create advanced parsing templates, to use interactive tracing and error trapping methods as well as how to debug complex REXX code. A working knowledge of basic REXX programming is a prerequisite for this class. When conducted at your site, the class can cover other platform environments as well. Hands-on lab exercises are used to reinforce lectures.
This course combines lectures and workshops to teach student techniques of writing on-line application programs in the mainframe CICS/TS environment. The principal CICS facilities covered are Task Control, Program Control, Terminal control, File control, Temporary Storage and design structure. Students also learn the techniques of pseudo-conversational programming and prevention of task abends. This course is hands-on and workshop oriented.
This course is designed to provide system programmers, administrators, operators, managers, support personnel and application programmers with a basic understanding of data communications concepts and terminology. Topics to be discussed include Network Components, LAN Components, Link Level Protocols, Systems Network Architecture (SNA), SNA Software and Network Management Systems.
Attendees will gain a solid foundation in the fundamental structure of MVS, enabling further study in areas such as debugging, performance, installation and customisation of the MVS operating system. This part concentrates on laying the ground rules of MVS in terms of architecture, storage management, major MVS control blocks and how to interpret them. The course also introduces the major MVS components.
This course examines and explains the critical factors that affect DB2 UDB for z/OS performance. The teaching of the effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course. This course is appropriate for DB2 for z/OS environments up to and including DB2 for z/OS.
This course uses hands-on labs to help new RACF administrators and auditors learn how to define, administer, monitor and audit the RACF security product. Students learn about the facilities, authorities and attributes of RACF and how to best use them to meet the access control requirements of their organization, whether the RACF database is stand-alone, shared in a sysplex or synchronized in a distributed network.
This course give the student a strong foundation to the Java language with the emphasis on comparing Java to the COBOL language. Through hands-on exercises on any platform, the student will become familiar with the Java syntax and the object oriented approach that this language utilizes
This course focuses of Java proficiency. The student will refine their Java skills, learn best practices for code development, learn effective debugging techniques, and have the opportunity to get real life experience in Tier Architecture. Through hands-on exercises using Eclipse this class builds upon a basic Java foundation to reinforce Object-Orients concepts and Java syntax preparing for Servets and JSPs.
This course is the definitive DB2 systems administration course. It comprises all the information required to understand and manage DB2 system functions. It describes and explains the installation and tailoring of the DB2 system and its attachments, system security, problem determination, system recovery and performance issues.This course is applicable to all DB2 for z/OS environments.
This course teaches the skills required by Applications Developers and Data Base Administrators to develop and design efficient DB2 applications and databases in all DB2 for z/OS environments.
This course provides attendees with an effective introduction to the skills and knowledge required to implement a DB2 system. The planning, installation and setting up of a DB2 subsystem are discussed in detail, along with an overview of operational issues. This course also provides valuable information regarding the migration to new releases.
Covering DB2 for z/OS environments, this course provides attendees with a comprehensive introduction to the recovery of DB2 objects. The course examines all the provided DB2 utilities and service aids, and discusses their involvement in recovery scenarios involving user data and DB2 data such as the catalog and directory.
This comprehensive ten-day 'Boot Camp' course provides attendees with an accelerated learning approach to the DBA role in a DB2 for z/OS environment. The course is ideal for anyone new to the DBA role or those who coming to DB2 for z/OS from another database environment. The regular, hands-on lab exercises give students the opportunity to try out their newly-gained skills immediately. On successfully completing this boot camp, attendees will have reached the skill level needed to enable them to efficiently and effectively manage their DB2 for z/OS database environment.
This comprehensive ten-day 'Boot Camp' course provides attendees with an accelerated learning approach to developing applications in a DB2 for z/OS environment. The course is ideal for those coming new to the DB2 for z/OS environment. The regular, hands-on lab exercises give students the opportunity to try out their newly-gained skills immediately. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively. On successfully completing this boot camp, attendees will have reached the skill level needed to enable them to write, maintan and amend programs for a DB2 for z/OS environment.
Day one of this course provides delegates with a good understanding of IBM's WebSphere MQ (formerly MQSeries) messaging system. The following three days are a workshop, covering the installation, operation, administration and support of WebSphere MQ systems and applications relating to those systems in a z/OS environment. Regularly upgraded to reflect the new releases of the product, this course covers the administration of WebSphere MQ up to Version 7x.
This is the definitive course for DB2 DBAs. It teaches the skills that are essential for administrators, enabling them to provide effective and efficient database design, implementation and support. It explains the database design process, from the logical database model right through to the implementation of the physical database. The system architecture, operational facilities and utilities used in a DB2 for z/OS environment are fully explained and demonstrated. In addition, monitoring, security and recovery techniques are also covered.
This course is designed for the experienced DB2 developer, focusing on advanced SQL statements and options. Additionally, the DB2 EXPLAIN facility is discussed as a tool to be used when choosing amongst competing SQL and design alternatives.
This course provides a detailed understanding of the DB2 for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and facilities of DB2 including monitoring, security and recovery techniques.
This course provides a detailed explanation of the methodology to be followed in order to design and implement efficient DB2 for z/OS databases. The course discusses all aspects of database design from the logical data model and implementation of the physical design, through to ongoing performance monitoring of the resultant database.
This course describes how the correct design of indexes can improve query performance for both single and multiple table access. It covers the different methods by which an index may be utilised by DB2, such as matching and non-matching index scans, index screening, index lookaside and use of multiple indexes and list prefetch. The factors involved in determining the best index to use to satisfy a given statement are also discussed. Different types of index are covered, as well as many of the design options available (such as the column sequence of a multiple column index) and the options available when the index is defined. Interpreting catalog columns and running relevant utilities to maintain index performance are also explained.
This course examines and explains the critical factors that affect DB2 for z/OS performance from a systems perspective. The effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course. This course is appropriate for DB2 for z/OS environments up to and including DB2 10 for z/OS.
IBM's powerful procedural language, REXX, offers the mainframe professional the opportunity to code highly effective SQL queries rapidly, without the need to write complex host language programs.This course describes and explains how DB2 data may be accessed and manipulated using REXX. It also introduces the concepts of DB2 static and dynamic SQL.
This course introduces and explains the fundamental principles of the DB2 UDB family of products. The course focuses on the relational theory and concepts, and how DB2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, DB2 utilities, and the use of DB2 Interactive (DB2I) and the relevant centres.
The course is designed for those applications programmers, designers, analysts and DBAs responsible for developing and maintaining an efficient DB2 LUW environment. The presentation combines formal classroom tuition with hands-on, practical workshop sessions, which will introduce all aspects of relational technology as implemented by DB2 UDB for Linux, UNIX or MS Windows.
This course introduces and explains all aspects of relational technology as implemented by DB2 UDB for Linux, UNIX and/or MS Windows. The course is designed for applications programmers, designers, analysts and DBAs who have used DB2 in a mainframe environment. The presentation combines formal tuition with practical workshop sessions.
This course is designed to teach how to develop, implement and maintain DB2 applications using advanced functions and features, with a view to optimising their performance. The course combines formal classroom tuition with realistic, practical exercises.
This course teaches experienced application programmers and developers to code CICS TS (Transaction Server) commands within COBOL programs and to write the logic that supports pseudo-conversational, multi-module, online transaction applications. CICS with DB2 is an optional/additional day with this course.
This course focuses on writing efficient, complex CICS Applications and using new features found in CICS TS and CICS/ESA.
Many CICS COBOL programs access and perhaps also update VSAM files. CICS provides its own file management commands for COBOL.
This course introduces the main concepts and principles of the computer systems development environment. Students learn how problems are defined in the development environment and ways solutions are designed and undertaken. A design case study is done to apply the techniques taught during class. Understandings of logic constructs are emphasized.
This class introduces the newcomer to the world of z/OS. It introduces the components of the z/OS package and explains the responsibilities of each of these components. It then examines how work is performed and how programs run in the z/OS environment. Concepts, terminology and acronyms associated with z/OS and MVS/ESA are explained, as is the relationship of z/OS to the world of PCs, Open Systems and Unix.
This course is a technical introduction to VTAM, CICS, DB2 and IMS, their terminology and especially their relationships to z/OS. Completion of this course will help you communicate with others in the MVS environment. A wide range of people will find the course beneficial, from new or experienced MVS system programmers to support personnel specializing in any of the subsystems. Administrators and technical managers working in MVS will find it worthwhile, too. You will need an understanding of MVS and its structure before attending.
This workshop introduces the student to the world of the fiber optic serial interface. Students learn to plan for, evaluate, configure and manage an FICON configuration. Both IOCP and HCD considerations are covered together with studies of the physical fiber cable structure and FICON architecture, including data transmission facilities.