When does class start/end?
Class hours may vary, please reach out to contact@ascendientlearning.com if you have any questions.
Db2 13 for z/OS Advanced Database Administration
This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. Performance...
Read More
$1,900 USD
Duration
2 days
Course Code
CV881G
Available Formats
Classroom, Virtual
Overview
This course introduces advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. Performance and availability features of utilities, including LOAD, REBUILD INDEX, REORG, and UNLOAD are covered.
This course does not cover distributed data processing or data sharing.
Skills Gained
Unit 1: Program Preparation and the Use of Packages - Part 1
- Describe the significance of the Db2 catalog and directory in the program preparation process and how they interact with Db2 applications
- Explain the role and components of DCLGEN in program preparation
- Describe the precompilation process
- Demonstrate the BIND process
- Identify common execution time errors in Db2 applications and explain how to troubleshoot and resolve them
- Demonstrate CREATE, REPLACE, and REBIND packages in Db2
Unit 2: Online Schema Changes - Part 1
- Explain the different types of valid and invalid data type changes for Db2 tables
- Describe the impact of altering a column- s data type and steps to mitigate performance degradation
- Explain the concept of schema versioning in Db2 and the limitations on the number of active versions
- Demonstrate how to modify indexes by adding columns and describe the restrictions and states *AREO* and RDBP) resulting from them
- Use REORG and MODIFY RECOVERY to minimize the active versions in Db2 tables and indexes
Unit 3: Online Schema Changes - Part 2
- Explain how to view pending schema changes and the role SYSIBM.SYSPENDINGDDL catalog table plays in tracking these changes
- Explain how to drop columns from a table, the necessary conditions, and the impact on table availability
- List the steps in converting a classic-partitioned table space to a partition-by-range (PBR) table space
- Explain the restrictions and considerations of pending changes on Db2 operations, including CREATE INDEX, CREATE TABLE, and DROP TABLE
Unit 4: Partition Management - Part 1
- Explain table-controlled partitioning and how to add new partitions using the ALTER TABLE statement
- Define the ROTATE PARTITION statement and explain its syntax, including the RESET option
- Execute the ALTER TABLE ROTATE n TO LAST statement and explain how to determine the physical and logical partition numbers
- Interpret the output of the DISPLAY DATABASE command after partition rotations
- Perform a ROTATE PARTITION operation and describe the necessary conditions and constraints to ensure data integrity and performance
Unit 5: Partition Management - Part 2
- Modify partition boundary keys using the ALTER TABLE - ALTER PARTITION - ENDING AT statement
- Explain rebalancing partitions in a table-controlled partitioning and how to do it
- Execute a REORG TABLESPACE - REBALANCE operation
Unit 6: Stored Procedures - Part 1
- Describe the purpose and benefits of stored procedures in reducing network traffic and facilitating versatile client/server environments
- Differentiate between external, native SQL and external SQL stored procedures and their execution environments
- Create a stored procedure using the CREATE PROCEDURE statement
- Use the ALTER PROCEDURE and DROP PROCEDURE statements
- Manage stored procedure execution using the START, STOP, and DISPLAY PROCEDURE commands
Unit 7: LOAD and REBUILD INDEX
- Describe the process of running a LOAD utility without parallel index build
- Explain how to use parallel index build during the LOAD utility and the role of SORTKEYS
- Perform the REBUILD INDEX utility and explain the SCOPE PENDING option
- Utilize dynamic allocation for sort work data sets during the REBUILD INDEX process
Unit 8: REORG
- Describe the basic flow of the REORG TABLESPACESHRLEVEL NONE process
- Explain the REORG process with the NOSYSREC option
- Execute a REORG operation with SHRLEVEL CHANGE, including the LOG phase and management of changes
- Utilize the SCOPE PENDING option in the REORG TABLESPACE utility
- Implement the FORCE option in the REORG utility to handle blocking claimers and ensure successful completion
Unit 9: UNLOAD
- Describe the purpose and capabilities of the UNLOAD utility
- Construct an UNLOAD utility control statement to unload data from a specific table space or table using the HEADER, SAMPLE, and LIMIT options
- Execute the UNLOAD utility in parallel mode for partitioned table spaces
- Unload data from partitioned and non-partitioned tables spaces into a single data set or multiple data sets
(Optional) Unit 10: Program Preparation and the Use of Packages - Part 2
- Demonstrate table mirroring and implement the BIND PACKAGE command to create packages with different qualifiers for identical table structures
- Diagnose and resolve issues by setting the CURRENT PACKAGESET special register
- Create and manage multiple versions of a package using the VERSION option in the BIND PACKAGE command
- Configure plan management settings using the PLANMGMT option in the REBIND PACKAGE command
- Implement the APRETAINDUP and APCOMPARE options in the REBIND PACKAGE command
(Optional) Unit 11: Stored Procedures - Part 2
- Create a native SQL stored procedure using the CREATE PROCEDURE statement
- Use the VERSION keyword in the CREATE PROCEDURE statement to develop multiple versions of a native SQL stored procedure
- Implement a versioning strategy for SQL stored procedures
- Deploy SQL stored procedures across different environments using the BIND PACKAGE command with the DEPLOY option
Who Can Benefit
Administrators familiar with Db2 who wish to augment their skill set in administering Db2 13 for z/OS database environment.
Prerequisites
Before taking this course, you should have:
- Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF
- Familiarity with SQL DML (SELECT, INSERT, UPDATE, and MERGE, as well as DDL statements (CREATE, ALTER, DROP)
- Basic skills administering a Db2 13 for z/OS database environment, including use of basic utilities, serialization, and basic database security
Course Details
Course Outline
Unit 1: Program Preparation and the Use of Packages - Part 1
Unit 2: Online Schema Changes - Part 1
Unit 3: Online Schema Changes - Part 2
Unit 4: Partition Management - Part 1
Unit 5: Partition Management - Part 2
Unit 6: Stored Procedures - Part 1
Unit 7: LOAD and REBUILD INDEX
Unit 8: REORG
Unit 9: UNLOAD
(Optional) Unit 10: Program Preparation and the Use of Packages - Part 2
(Optional) Unit 11: Stored Procedures - Part 2
Schedule
4 options available
-
Jul 10, 2025 - Jul 11, 2025 (2 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Aug 21, 2025 - Aug 22, 2025 (2 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Oct 23, 2025 - Oct 24, 2025 (2 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Dec 17, 2025 - Dec 18, 2025 (2 days)
Live Virtual | 9:30AM – 5:30PM EST Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EST- Enroll
- Enroll Add to quote
FAQ
Does the course schedule include a Lunchbreak?
Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.
What languages are used to deliver training?
Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.
What does GTR stand for?
GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.
How do I find an Ascendient Learning training location?
We have training locations across the United States and Canada - View a complete list of classroom training locations.
Which delivery formats are available?
At Ascendient Learning, we offer training that is Instructor-Led, Online, Virtual, and Self-Paced.
Does Ascendient Learning deliver group training?
Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.
What does vendor-authorized training mean?
As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.
Is the training too basic, or will you go deep into technology?
It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.
How up-to-date are your courses and support materials?
We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.
Are your instructors seasoned trainers who have deep knowledge of the training topic?
Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.
Do you provide hands-on training and exercises in an actual lab environment?
Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.
Will you customize the training for our company’s specific needs and goals?
We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.
How do I get started with certification?
Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.
Will I get access to content after I complete a course?
You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.
How do I request a W9 for Ascendient Learning?
View our filing status and how to request a W9.
Reviews
The technical data in the AWS Solutions Architect course was very thorough.
Very good company. I've done technical trainings at their facility in downtown Montreal in the past and I'Ve always appreciated them.
The course was informative, and I learnt a new skill. The instructor was up to the point.
Instructor, Training material & span of the training is neatly planned.
It is very good and very simple instructions. almost to much hand holding.
