| Course Name |
Hours |
List Price |
Content |
| DB3010: DB2 for z/OS Database Administration |
35.00 |
$3,200.00 |
|
Description: This course provides guidance information for Database and System Administration personnel responsible for the DB2 production and test Data Bases. The course covers creation, utility support, recovery, monitoring and management of DB2 Databases. Physical Database Implementation and control are the key issues addressed by this course.
|
| DB3011 - DB2 for z/OS Database Recovery and Advanced Utilities |
21.00 |
$1,920.00 |
|
Description: In this course, you will cover guidance information for all personnel who will be participating in the Recovery of DB2 for z/OS Databases and Applications. Recovery detail includes Unit of Work Recovery, Current point in time and prior point in time recovery, Recovery analysis, Recovery from I/O errors, out of space conditions, building and implementing DB2 Recovery related utilities. Both data sharing and non-data sharing recovery considerations are covered.
|
| DB3052 - DB2 for z/OS Database Performance Tuning |
21.00 |
$1,920.00 |
|
Description: In this course, you will cover detail guidance information for all personnel who will be participating in DB2 for z/OS database performance analysis and tuning. Both data sharing and non-data sharing considerations are covered. Upon successful completion of this course, the student will be able to: Develop a Performance Monitoring Strategy, Reduce overall CPU consumption, Reduce overall lock , contention problems, Improve overall application response times, Identify and tune I/O overhead.
|
| IBM: Db2 11.1 Quickstart for Experienced Relational DBAs (CL487G) |
28.00 |
$3,100.00 |
|
Description: This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).
The lab demonstrations are performed using DB2 LUW 11.1 for Linux. For some lab tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.
|