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 course introduces, describes and explains the fundamental principles of DB2 UDB for z/OS. The course also explains the relational theory and concepts, and shows how DB2 adheres to them. The concepts of DB2 data storage, the DB2 system and its operation, Structured Query Language, the use of DB2 Interactive (DB2I), and the management of DB2 data using standard utility tasks are also introduced and explained. The course includes demonstrations and practical, hands-on exercises.
This intensive course has been designed to provide a comprehensive understanding of the DB2 UDB for z/OS Structured Query Language. It is intended for all personnel who are going to use SQL to report from, and modify DB2 data, in any environment other than embedded in application programs.
This course combines the to teach the skills in the definitive introductory JCL course - z/OS JCL Workshop Part 1 - Foundation Skills and z/OS JCL Workshop Part 2 which includes the exploitation of the important advanced features and facilities available in z/OS JCL. It also shows how JCL maintenance can be simplified in order to aid productivity. The course is taught through a combination of classroom tuition and practical hands-on exercises.
This definitive JCL course is regularly upgraded to reflect recent developments in z/OS. The practical sessions of this course now comprise almost 40% of the course timetable. The course teaches the coding of job control statements to execute programs and access datasets in a z/OS environment. It also shows how to write and test catalogued procedures. The course combines classroom tuition with practical exercises using various IBM utilities.
This course builds on the skills taught in the definitive introductory JCL course - z/OS JCL Workshop Part 1 - Foundation Skills. It teaches the exploitation of the important advanced features and facilities available in z/OS JCL. It also shows how JCL maintenance can be simplified in order to aid productivity. The course is taught through a combination of classroom tuition and practical hands-on exercises.
This course provides the attendee with a firm technical introduction to IBM's mainframe environments with the emphasis on z/Architecture and z/OS, IBM's strategic mainframe operating system. The course also provides an overview of all the associated software and system components that comprise the complete system.
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 hands-on course introduces new TSO/ISPF users to the concepts and facilities of TSO and IBM's Interactive System Productivity Facility (ISPF). It focuses particularly on its functions for data editing and dataset management. The course combines formal classroom tuition with a progressive series of hands-on practical sessions.
This course designed and written by mainframe storage management specialists, describes and explains how best to implement, customise and utilise HSM. Start-up commands and options are examined in detail, giving practical guidance on performance and availability issues. Customisation of the environment is also covered in some detail. Managing and monitoring HSM are also important areas that require some attention, in order to provide a good service to end-users. Another area that is often neglected is disaster backup using HSM. These are both covered, and the course includes the Aggregate Backup facility as well as other alternatives.
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.
A conceptual overview of z/OS and MVS is provided, as is an introduction to the use of TSO and ISPF/PDF, followed by a grounding in basic JCL skills. Topics covering concepts, terminology and acronyms associated with the mainframe and its operating system are included, as well as a TSO introduction, ISPF introduction, the ISPF Editor, ISPF Utilities, job flow, JCL syntax, JOB and EXEC statements, DD statement parameters for both existing and new datasets, and system utilities. Hands-on lab exercises will reinforce material covered in lecture. As an alternative to the Boot Camp, students may attend each of the three component classes which allows for some additional time on each subject.
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.
Introducing new programmers to COBOL, this course teaches how to write and maintain simple COBOL programs. It is taught using a combination of classroom tuition and practical exercises, and includes realistic case studies that can be based on the client's particular environment and work-load.
This course describes and explains how to implement and exploit the features provided by the z/OS storage environment, and covers SMS in particular. It examines both hardware and software features and explains how to fully exploit them. The course will gives attendees a detailed knowledge of how best to design and test the SMS Constructs and ACS routines. It provides a basis for evaluating standards and for establishing an optimised System Managed Storage (SMS) environment. The course also explains key components such as catalogs, VTOCs and I/O definitions. There are a number of online practical sessions during the course which, among other things, teach how to write optimised ACS routines.
This course provides a detailed understanding of the DB2 UDB for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and operational facilities of DB2 including monitoring, security and recovery techniques. This course is suitable for all environments of DB2.
This course describes and explains UNIX System Services from a technician's point of view. The principal UNIX concepts are introduced and explained, and followed by a thourough examination of USS (UNIX) at a conceptual level. The course goes on to describe the facilities available and explains how the MVS system environment has changed to support open system and UNIX concepts through z/OS USS.
This course follows on from the course UNIX System Services Part 1 - Concepts & Facilities. It teaches the skills needed to install, configure and implement UNIX System Services in a z/OS environment. The course goes on to describe and explain how to manage the new environment efficiently and effectively.
This course is vital for all those technicians who need to be able to understand and work with the ICF catalog environment. The prime objective is to enable attendees to evaluate catalog problems and take the appropriate and necessary corrective actions. The course also introduces and explains the tools available for catalog recovery.
This is the definitive administration course for all those who have responsibility for CICS administration on CICS/TS systems. The course combines formal tuition with a series of practical exercises. Over the course of the week attendees build and operate a CICS/TS system from scratch.
This course provides a view of z/OS (with JES2 as the job entry subsystem) through the eyes of the operator and the operator console. It goes through the system's functions by following a sequence which begins with the start-up of the system (IML and IPL) and then follows how the system controls the application workload coming through and exiting the system. The operator's ability to control this process is also discussed in detail.
This course provides a comprehensive overview of the Workload Manager functions. All the key features are described during this course, and details of the migration process to Goal mode are also covered. The course also includes a number of realistic practical hands-on exercises.
This course builds upon the skills taught in the courses DB2 for z/OS: Database Administration. It provides attendees with an understanding of additional and advanced administration tasks. It also examines in-depth a number of the subjects covered by the earlier course. This course is suitable for DBAs working in DB2 for z/OS environments.
This course is a comprehensive introduction to IMS. It provides ideal cross-training for application support specialists from disciplines such as CICS, COBOL, JAVA, or DB2. The course introduces and explains all areas of IMS databases in both the Batch and Online environments, including data access using the DL/I Language Interface and the maintenance of data integrity using the DBRC feature. Practical exercises reinforce the formal tuition sessions. These include the analysis of sample applications and use of the procedures and utilities required to recover from various application and system failures.
This intensive, five-day, hands-on course has been designed to provide a comprehensive understanding of the DB2 UDB for z/OS Structured Query Language and how it is embedded in application programs. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively. This course is suitable for programmers working in DB2 for z/OS environments.
This course introduces and explains in detail IMS on-line operations. It provides the essential cross-training for systems support specialists from parallel disciplines such as z/OS, CICS, COBOL, or DB2. Attendees will learn effective IMS system administration, based on a comprehensive insight into the structure and function of the IMS processes and resources, together with the parameters and operator commands that control them. Typical problems are demonstrated, emphasizing the identification of the appropriate skills and the utility procedures required to resolve them. Practical exercises reinforce the formal tuition sessions. These include hands-on access to the IVP sample applications, together with recovery from various system failures. Following this course, attendees will be able to provide standby support to their IMS colleagues (following an overview of the standards, conventions, and procedures, used in their own IMS department). No Machine Labs.
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 is designed to provide students with a working knowledge of the management and recovery of databases, systems and logs under DBRC through IMS version 9. Topics include RECON datasets, DBRC tracking of log datasets, database datasets and IMS systems; database registration; subsystem interaction and authorization; IMS utility interaction including reorganizations, image copies, change accumulation, database recovery, and batch backout; DBRC system issues; and review and discussion of your RECON. On-line labs are used to reinforce lectures.
This course describes and explains the access method concepts in MVS and the structure and design of VSAM files. It teaches how to create VSAM files using the utility Access Method Services (AMS), both from a functional as well as a performance point of view. Additionally, it provides the Systems Programmer and Operational Analyst with information on the structure of ICF catalogs and the related VTOC and Index VTOC. Online exercises provide experience in creating, accessing and managing VSAM files. Attendees will create and use clusters, alternate indexes and paths.
This course provides detailed information required for the design of IMS Full Function databases. It covers the definition of IMS Control Blocks (DBD and PSB), and the characteristics of HISAM, HDAM and HIDAM organisations. The physical structure of these database types is examined in detail, and the reasons for choosing a particular organisation to match an application's needs. In addition, GSAM and Secondary Indexes are discussed, and the physical implementation of logical relationships, uni-directional and bi-directional (physical and virtual). Other topics are database housekeeping, the relevance of DBRC, database monitoring for performance and error recovery.
This in-depth, five-day course describes and explains the internals of CICS with particular focus on problem determination and debugging. Using dumps and IPCS in on-line labs, attendees will learn how to debug system problems, find failing programs and modules, read the internal CICS trace table and much more. The course combines formal presentation and explanation of theory along with the practical analysis of transaction and system dumps. The course is based on CICS Transaction Server V3.2 for z/OS. The workshop material is COBOL based.
This upgarded and expanded course teaches the effective and efficient coding of the various elements of the Dialog Manager feature of ISPF. The bias is toward the combined use of ISPF/DM and REXX services in a TSO/E environment. The newly introduced CUA features are also included in this course, enabling attendees to greatly enhance panel design. The course is taught with a combination of classroom tuition and practical exercises.
This course teaches the new Common User Access (CUA) features of ISPF Dialog Manager. This enhances panel design and makes it more efficient and productive. Panels supplied by IBM incorporate all these new features. The course is taught combining formal tuition with practical hands-on exercises.
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.
The definitive Assembler course. It is designed for both systems and application programmers who need to understand Assembler, either to install and maintain systems software or to maintain and amend application programs or packages written in Assembler. This course describes how Assembler works and how to read, interpret and modify Assembler routines.
This and its associated Part 2 form the core course of the z/OS curriculum. By attending both components, 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 Boot Camp forms the core course of the z/OS curriculum. By attending, attendees will gain a solid foundation in the fundamental structure of MVS, enabling further skills development in areas such as debugging, performance, installation and customization of the MVS operating system. The first week concentrates on laying the ground rules of MVS in terms of architecture, storage management, major MVS control blocks and how to interpret them, and also introduces the major MVS components.
This course and its associated Part 1 form the core of the z/OS training curriculum. In this second part, attendees learn the functions of the major MVS components in considerable detail, and learn how the interaction of job, task, storage and data management provides service to the end user. This is done by following the sequence of events as a unit of work passes through the MVS system from initial submission to completion.
Recently revised and upgraded to reflect the changes in the z/OS environment, this course is the essential technical introduction to Parallel Sysplex. The course describes and explains the components of the parallel sysplex concept and covers data sharing, installation, IPL, components & services and sysplex exploitation.
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.
A Java Enterprise Application consists of three basic layers; the Presentation Layer, the Business Logic Layer and the Data Layer. This course focuses on the Presentation Layer. Building a Web access to a Java Enterprise Application requires understanding of HTTP, Java Servlets, Java Server Pages (JSPs) and Session management. Through hands-on exercises the student will become familiar with dynamic web applications and coding the Java components required to give the User access to the Business Logic and the Database storage.
Covering DB2 for z/OS environments, this course provides attendees with a comprehensive introduction to the recovery of DB2 objects and the processes involved in starting DB2 following problems. The course examines all the provided DB2 utilities and service aids, and discusses their involvement in recovery scenarios. Start-up, operation, and shut-down of the DB2 system is covered to ensure attendees fully appreciate the additional steps that may be required following an abnormal termination. The need for deferred and conditional restarts is discussed, as are the methods of setting these up, and evaluating any additional work that may be required following the use of these methods. The diagnosis and resolution of other problems that may occur are discussed, such as out of sync. log files, out of space data sets, and read / write errors on recovery data sets.
This new two-day course introduces and discusses the changes and new features of DB2 10 for z/OS. It provides a technical overview, and discusses areas of potential advantage for the new features. The course is intended for system and database administrators, application developers and others needing a technical introduction to the new features of DB2 10.
This two-day course introduces SNA at a conceptual and terminological level and teaches and explains the significant issues involved in VTAM installation and implementation. Attendees will learn how to define the network in order to optimize response time and throughput. Particular attention is paid to the implementation of VTAM network definitions in order to enable support of local and cross-domains.
This course adds IMS DC programming to a developers skill set. Developers learn how the tools and techniques needed to develop online applications that access IMS DB via IMS DC and MFS. Design, code and test topics are thoroughly covered.
This four-day, hands-on class is the definitive RACF course for technicians and administrators. It introduces and explains the concepts, terminology, commands, and procedures involved in administering and auditing RACF. All major aspects of day-to-day RACF administration and auditing are covered. A number of realistic practical exercises are performed during this course.
This two-stage course introduces the world of WebSphere in z/OS environments. In the first part, the Enterprise Java (J2EE) platform (the basis for the WebSphere architecture) is explained. The integration of Java with existing (enterprise) systems is also covered.
This course will provide experienced z/OS Systems Programmers with essential information on the Hardware Configuration Definition (HCD) program, the I/O configuration tool for the z/OS environment.
This two-day course is the essential introduction to IBM's mainframe-based enterprise computing environment and its flagship operating system z/OS. The course introduces the concepts and terminology that are encountered and used by IS personnel every day, and explains them in an easily understandable manner. This course provides a firm foundation for anyone moving into the world of IBM mainframe-based computing.
This one day course is the ideal introduction to RACF for all technicians, administrators, support personnel and managers who will come across it in their daily work. The course introduces the concepts and terminology of RACF, and explains the major RACF commands. No previous RACF experience is assumed.
This course introduces the parallel sysplex's operations environment and teaches how the consoles should be set up in a sysplex, the commands and the command facilities for sysplex operations. It also explains the IPL process and how it changes in a sysplex, showing the correct way to IPL and remove systems in this environment, as well as covering the various errors that can occur at IPL time and how to deal with them. For troubleshooting, the course highlights how all the major points of failure can be detected, recognised and dealt with, including such areas as loss of systems, signalling paths, Coupling Facilities, structures, sysplex timers and Couple Data Sets. This newly upgraded and redesigned course now includes extensive hands-on practical sessions, including real-life recovery scenarios!
This course describes and explains what functions there are in IBM's Job Entry Subsystem 2 (JES2) and teaches how to set up a JES2 system in order to fully exploit the features and capabilities of the product.
This course describes and explains what can go wrong in an IBM Mainframe environment, and what you can do about it as an operator or systems programmer. It looks at failure situations from many points of view: the physical computer rooms, hardware problems and the software environment. The software environment is further examined by looking at the Recovery Termination Manager (RTM) - the 'cleaning-up' function of z/OS - and its ABEND-concept. All the different reports that come out of an MVS system in conjunction with failures (messages, dumps, traces, etc.) are also discussed. The most common reasons for system ABENDs and how you can analyze the information coming out of the system when they occur are also covered.
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.