CV871G: DB2 10 for z/OS Utilities for Database Administrators
Transform and modernize your data management with AI-driven solutions.
IBM Db2 is a family of data management products, including the Db2 relational database. The products feature AI-powered capabilities to help you modernize the management of both structured and unstructured data across on-premises and multicloud environments. By helping to make your data simple and accessible, the Db2 family positions your business to pursue the value of AI.
CV871G: DB2 10 for z/OS Utilities for Database Administrators
Transform and modernize your data management with AI-driven solutions.
IBM Db2 is a family of data management products, including the Db2 relational database. The products feature AI-powered capabilities to help you modernize the management of both structured and unstructured data across on-premises and multicloud environments. By helping to make your data simple and accessible, the Db2 family positions your business to pursue the value of AI.
This CV871G: DB2 10 for z/OS Utilities for Database Administrators 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.
Skills Covered
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
Who Should Attend
Please refer to course overview.
Course Curriculum
Prerequisites
DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or
DB2 10 for z/OS Database Administration Workshop Part 1 (CV831),
