Back to Search Results

Training Course Summary:

Learn how to perform advanced database administration tasks using DB2 Universal Database. These tasks include client administration, problem determination, advanced load usage, parallelism and SMP exploitation, DB2 Governor, Audit Facility, job scheduling, distributed data management, remote administration, Multidimensional Data Clustering, Online Reorganizations as well as Federated Database support.

Pre-Requisites:

Before taking this course, you should have a working knowledge of DB2 Universal Database. You can develop this knowledge through job experience or by taking the following courses:
DB2 UDB Database Administration Workshop for UNIX (CF21)
DB2 UDB Database Administration Workshop for Windows NT (CF23)
DB2 UDB for Experienced Relational DBAs (CF28).
DB2 UDB Administration Workshop for UNIX (CF21N7GB)
DB2 UDB Administration Workshop for Windows (CF23N7GB)
Fast Path to DB2 UDB for Experienced Relational DBA's (CF28N4GB)

Who Should Attend:

System administrators, database administrators, and technical personnel who are involved in planning, implementing, and maintaining DB2 Universal Databases.

Training Course Overview/Content:

After completing this course, you should be able to:
o Effectively apply advanced techniques to administer a DB2 Universal Database
o Explore parallelism and symmetric multiprocessor (SMP) enablement
o Explore problem determination tools and techniques
o Use Online Index as well as Online Table reorganization
o Explore the Multi Dimensional Clustering
o Explore Advanced Load utilities
o Explore Federated databases
o Configure the DB2 Governor to enforce time and CPU restrictions
o Manage a distributed data environment.