Core
Db2 Database Administrator - Core
The learning streams here provide an overview of IBM Z mainframes and their components, and discusses key concepts of the z/OS operating system, including security, and how JES2 is used to process workloads.
Content then focuses on the use of TSO/ISPF and z/OS Explorer to access z/OS data. Background on the types of storage devices implemented in the mainframe environment are also covered, with training then progressing to JCL where basic statements used to construct a batch job are discussed, along with the use of procedures and symbols, working with VSAM, generation and tape data sets, as well as z/OS UNIX files. The use of SDSF to monitor batch job processing and output is also covered in detail, while extensive information on utilities such as IEBGENER, IEBCOPY, and IDCAMS is also covered. An overview on the use of SMP/E to install and managed z/OS system software is also discussed.
Introductory content relating to databases generally, and then Db2, is also presented.
Db2 Database Administrator / Core / z/OS Operating System - Learning Plan
3 hours
IBM (z/OS) - The Evolving Mainframe
3 hours
IBM (z/OS) - Working with the Mainframe
1 hour
IBM Z - Introduction to the IBM Z Systems
4 hours
z/OS - Concepts
4 hours
z/OS - Managing and Processing z/OS Data
3 hours
Parallel Sysplex - Fundamentals
Printed on:
Db2 Database Administrator / Core / Security - Learning Plan
5 hours
Security - Introduction to Mainframe Security
1 hour
Cryptography - Pervasive Encryption z/OS
Printed on:
Db2 Database Administrator / Core / Mainframe Storage - Learning Plan
3 hours
Storage - Introduction to Storage and Disk Systems
3 hours
Storage - Understanding Tape Storage
Printed on:
Db2 Database Administrator / Core / Interacting with z/OS Data - Learning Plan
3 hours
ISPF (z/OS) - TSO and ISPF Basics
3 hours
ISPF (z/OS) - Configuring ISPF for General Use
1 hour
ISPF (z/OS) - TSO/ISPF Concepts Assessment
2 hours
z/OS Explorer - IBM Explorer for z/OS
3 hours
SDSF - Introduction and Basic Concepts
1 hour
SDSF - Operations
4 hours
SDSF - Working with SDSF Data
0.5 hours
SDSF Concepts Assessment
Printed on:
Db2 Database Administrator / Core / Monitoring and Managing z/OS Batch Activity - Learning Plan
3 hours
SDSF - Introduction and Basic Concepts
1 hour
SDSF - Operations
4 hours
SDSF - Working with SDSF Data
0.5 hours
SDSF Concepts Assessment
3 hours
SDSF - Job Activity Basics
3 hours
SDSF - Controlling and Managing Jobs
3 hours
SDSF - Advanced Job Management and Monitoring
3 hours
SDSF - Using SDSF to Display and Control Job Output
3 hours
SDSF - Using SDSF to Display and Control Printers
1 hour
SDSF Monitoring Job Activity Using SDSF Assessment
Printed on:
Db2 Database Administrator / Core / Basic Batch Job Creation - Learning Plan
3 hours
JCL (z/OS) - Introduction to JCL
1 hour
JCL (z/OS) - JCL Concepts Assessment
4 hours
JCL (z/OS) - JCL Coding Basics - JOB and EXEC Statements
4 hours
JCL (z/OS) - JCL Coding Basics - DD Statements and Data Sets
3 hours
JCL (z/OS) - JCL Coding Basics - DD Statements and SYSOUT
5 hours
JCL (z/OS) - Advanced JCL Data Set Use
3 hours
JCL (z/OS) - Working with Procedures and Symbols
1 hour
JCL (z/OS) - JCL Coding Assessment
Printed on:
Db2 Database Administrator / Core / z/OS Utilities - Learning Plan
4 hours
Utilities - General Data Set Utilities
3 hours
Utilities - Copy, Compare, and List Data Utilities
3 hours
Utilities - Sort and Update Data Utilities
1.5 hours
Utilities - Advanced - Tips and Tricks
1 hour
VSAM - Introduction to VSAM
3 hours
VSAM - Defining, Altering, and Deleting VSAM Data Sets
3 hours
VSAM - Working with VSAM Data Sets
0.5 hours
VSAM - Advanced - Tips and Tricks
Printed on:
Db2 Database Administrator / Core / Installing and Maintaining Software - Learning Plan
3 hours
SMP/E - Introduction to SMP/E
Printed on:
Db2 Database Administrator / Core / Databases and Db2 - Learning Plan
4 hours
Databases - Introduction to Databases and Database Managers
3 hours
Databases - Database Communication
4 hours
Databases - Introduction to SQL
4 hours
Databases - Advanced SQL
4 hours
Databases - Database Manager Resources
4 hours
Db2 - Introduction to Db2
Printed on:
Advanced
Db2 Database Administrator - Advanced
The learning streams above address the advanced skills, knowledge, and practices dealing with products that a Db2 Database Administrator will need to know about at some stage of their career. These focus on advanced Db2 operations and programming, advanced problem identification and resolution of batch JCL, Db2 database performance, and use of managed file transfer practices.
Db2 Database Administrator / Advanced / Advanced Db2 - Learning Plan
4 hours
Db2 - Managing Db2 Operations on z/OS
5 hours
Db2 - Creating and Maintaining Db2 Programs
3 hours
Db2 - Building Db2 COBOL Programs
5 hours
Db2 - Optimizing Db2 Application Performance
Printed on:
Db2 Database Administrator / Advanced / Batch Job Problem Resolution - Learning Plan
3 hours
JCL (z/OS) - Controlling Job and Step Processing
3 hours
JCL (z/OS) - Running and Debugging JCL
1 hour
JCL (z/OS) - JCL Problem Resolution Assessment
1 hour
JCL (z/OS) - Advanced - Tips and Tricks
Printed on:
Db2 Database Administrator / Advanced / Data Transfers - Learning Plan
3 hours
Managed File Transfer for Operations
Printed on:
Db2 Database Administrator / Advanced / Db2 Database Performance - Learning Plan
0.5 hours
Db2 Coding - Defining Database Performance - Expert Videos
0.75 hours
Db2 Coding - Coding Relationally - Expert Videos
0.75 hours
Db2 Coding - General SQL and Indexing Guidelines - Expert Videos
0.83 hours
Db2 Coding - Coding for Concurrent Access - Expert Videos
0.83 hours
Db2 Coding - Understanding and Reviewing Db2 Access Paths - Expert Videos
1 hour
Db2 Coding - SQL Coding Tips and Techniques - Expert Videos
Printed on:
Business
Db2 Database Administrator - Business
The learning streams above provide content focussing on business-related information. This includes disaster recovery, where the Db2 Database Administrator often plays a critical role in ensuring recoverability of business data, ensuring they comply with any regulatory requirements. This person also needs to understand how coaching and mentoring practices can be implemented to ensure they, and other staff, are trained to meet their full potential.
Db2 Database Administrator / Business / Disaster Recovery - Learning Plan
3 hours
DR - Ensuring Data Center Business Continuity
Printed on:
Db2 Database Administrator / Business / Coaching and Mentoring - Learning Plan
2 hours
Coaching and Mentoring for Technical Specialists
Printed on:
Optional
Db2 Database Administrator - Optional
The learning streams here are not mandatory but help to provide a holistic view of the mainframe environment that you are working in. For example, z/OS UNIX is available on a z/OS system, and use of z/VM and Linux operating systems is also likely, so knowledge in these areas is going to help you. Other topics such as Blockchain, Big Data, and Hadoop provide an overview of various technologies available on the mainframe that your organization may be using. The cloud is playing an ever increasing role in Data Center processing so knowing how it works, its structure, and security configuration may be of interest. Knowledge of script languages such as CLIST and REXX can assist in creating programs used to simplify complex or often-performed tasks.
Db2 Database Administrator / Optional / Emerging Technologies - Learning Plan
4 hours
Blockchain Technologies
0.75 hours
Quantum - Easy Introduction to Quantum Computing - Expert Videos
4 hours
AI – Artificial Intelligence and Modern Business
3 hours
AI – Big Data and Hadoop
3 hours
AI – Data Analytics and Apache Spark
Printed on:
Db2 Database Administrator / Optional / Cloud - Learning Plan
3 hours
Introduction to Cloud Computing
3 hours
Understanding Cloud Architecture
1 hour
Cloud Security
Printed on:
Db2 Database Administrator / Optional / Related Operating Systems - Learning Plan
3 hours
z/OS UNIX - z/OS UNIX System Services Basics
4 hours
z/OS UNIX - Interacting with the z/OS UNIX System
4 hours
z/OS UNIX - Working with z/OS UNIX
3 hours
z/VM - Introduction and Concepts
5 hours
Linux on IBM Z Fundamentals
Printed on:
Db2 Database Administrator / Optional / Scripts - Learning Plan
3 hours
CLIST - Basics
4 hours
REXX - Fundamentals
4 hours
REXX - Coding and Execution Basics
3 hours
REXX - General REXX Instructions
4 hours
REXX - Basic REXX Functions and Subroutines
4 hours
REXX - Manipulating and Converting Data
3 hours
REXX - Program Flow
3 hours
REXX - Handling Errors
4 hours
REXX - Working in the TSO Environment
4 hours
REXX - Host Commands and System REXX
Printed on: