| Course Name |
Hours |
List Price |
Content |
| 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.
# of Days:
Setting:
|
| DB3016: DB2 LUW Administration and Performance |
28.00 |
$2,450.00 |
|
Description: This course makes your life as a DB2 LUW DBA more productive. Over four days, this course covers the roles of the DBA and the activities that are important to the success of DB2. A special emphasis is placed on performance topics. This class uses hands-on and paper exercises to reinforce the topics covered. This class is current to DB2 10.5.
# of Days:
Setting:
|
| 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.
# of Days:
Setting:
|
| 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.
# of Days:
Setting:
|
| OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs |
14.00 |
$1,195.00 |
|
Description: This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. Oracle versions 11g and 12c are covered.
# of Days:
Setting:
|