title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
DB2 10 for z/OS Utilities for Database Administrators
Course Description
Overview
This course is designed to teach you advanced topics about DB2 for z/OS utilities. It is assumed that you attended course DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) so that you already have basic skills about the main utilities. Recovery-oriented topics are not part of this course, so such utility functions are not presented.
Objectives
- Use RUNSTATS to accelerate the performance of a given SQL access
- Employ DSN1COPY, REPAIR, and DIAGNOSE for DBA tasks which are not recovery-oriented
- Use parallel index build with the LOAD, REORG and REBUILD INDEX utilities
- Load partitions in parallel
- Determine the appropriate LOAD options to use while considering concurrency and performance requirements
- Choose appropriate options with REORG and UNLOAD to achieve optimal performance and availability
- Provide appropriate LISTDEF, TEMPLATE, and OPTIONS utility control statements for use in DB2 utilities
Audience
Please refer to course overview.
Prerequisites
- DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or DB2 10 for z/OS Database Administration Workshop Part 1 (CV831), or have attained a similar level of knowledge
You should have attended course:
Topics
- (CV831) utilities review
- RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE
- LOAD and REBUILD INDEX performance and availability
- Online CHECK DATA
- REORG performance and availability
- UNLOAD performance and availability
- Generic utility jobs (LISTDEF and TEMPLATE)
- Appendix: Clone tables
The course includes extensive machine exercises.
Recognition
When you complete the Instructor-Led version of this course, you will be eligible to earn a Training Badge that can be displayed on your website, business cards, and social media channels to demonstrate your mastery of the skills you learned here.
Learn more about our Data Storage Badge Program →Related Courses
-
DB2 10 for z/OS Database Administration Part 2
CV842G- Duration: 24 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 2,445.00 USD
-
DB2 10 for zOS System Administration
CV851G- Duration: 40 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 4,075.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.

STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration