Live Instructor-Led Training
The course Mainframe Performance Tuning for z/OS (zOS & DB2 Training) is an exploration of DB2 administration from concepts to data use & configuration. The training includes configuration related to availability, scalability & connectivity. You learn about SQL syntax, data sharing & integration and XML. This DB2 course also discusses utilities and a few useful tips & tricks.
Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00
About DB2
Overview of DB2 Functions and Architecture
About the Subsystem and Application functions
About Operations and Performance
About IBM zEnterprise System, System z and z/OS
DFSMS Storage Tiers
Additional Enhancements
Using Compression
Exploring Scalability
Working with Extended RBA and LRSN
Using NOT LOGGED with Declared Global Temporary Tables
More Open Data Sets (DSMAX)
About PBG Mapping Tables
Exploring Availability
Exploring Online Schema Changes
About Recovery Options
Automatic Index Recovery from GRECP or LPL status
About Improved Availability when Altering Limit Keys
Exploring Work File Database Enhancements
About Parallel Processing of Utilities
Compression Dictionary Availability for CDC Tables
Exploring DROP Column Support
Enhancements for Defer define object
Break-In of Persistent Threads and BIND, REBIND, and DDL
Idle Thread Break-In
Data Sharing
The Group Buffer Pool Write-Around Protocol
Improved CASTOUT Processing
Improved DELETE_NAME Performance
Restart light with CASTOUT
About Locking
Index Availability and Performance
Group Buffer Pool Performance
Automatic LPL Recovery
Log Record Sequence Number Spin Avoidance
SQL
Introduction to SQL on DB2
Working with Global Variables
Working with Array Data Type
Aliases for SEQUENCES
New Built-In Functions
Working with SET CURRENT APPLICATION COMPATIBILITY
Working with Temporal Special Registers
Working with CUBE, ROLLUP and GROUPING SETS
Working with ALTER TABLE DROP COLUMN
Working with LIKE_BLANK_INSIGNIFICANT DSNZPARM
Application Integration
Ensuring Application Compatibility
Transparent Archiving of Temporal Data
Providing Support for Big Data
Using the Scoring Adapter
Using JavaScript Object Notation
Suppressing Null Indexes
XML
XML Technologies Overview
XQuery Support
XML Performance
XQuery FLWOR Expressions
Working with XMLTABLE
Connectivity and Administration
About Client Information
Cancel Thread and Cancel SQL Statement
Continuous Block Fetching
Support for Global Variables
Local Stored Procedure Execution
Multi-threaded Java Stored Procedure Environment
ADMIN_COMMAND_MVS Stored Procedure
Drivers, Clients, and Connectivity Requirements
Utilities
Online REORG enhancements
Running Statistics
Backup and Recovery
LOAD and UNLOAD
Compression Dictionaries for Change Data Capture
zOS & DB2 Training: Exploring Mainframe Programming
The course Exploring Mainframe Programming (zOS & DB2 Training) is an introduction to mainframe programming in z/OS. The training includes a general discussion on application architecture in a mainframe environment and covers available mainframe programming languages including Assembler, COBOL, C/C++, CLIST, REXX & more. The course proceeds with an overview of common mainframe programming tasks followed by an exploration of compilation & link editing.
Training course titled zOS & DB2 Training: Exploring Mainframe Programming that will allow you to hone your professional skills.
Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00
zOS & DB2 Training: The Complete DB2 Administration Course
The course The Complete DB2 Administration Course (zOS & DB2 Training) is an exploration of performance tuning & scalability with DB2. The training includes non-partitioned & multi-partitioned databases, tablespaces, buffer pools and database objects. This DB2 course also discusses backup & recovery, availability, security & event monitoring & connectivity. Your skillset is completed with a focused activity on performance tuning & troubleshooting.
Training course titled zOS & DB2 Training: The Complete DB2 Administration Course that will allow you to hone your professional skills.
Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
zOS & DB2 Training: z/OS & Mainframe Introduction
The course z/OS & Mainframe Introduction (zOS & DB2 Training) is an exploration of the modern mainframe. Beginning with an introduction to the Mainframe, the training covers z/OS architecture & basics, data set creation & use, JCL programming, batch processing and the Job-Entry subsystem.
Training course titled zOS & DB2 Training: z/OS & Mainframe Introduction that will allow you to hone your professional skills.
Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00