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.
