 |
An IBM Certified Advanced Database
Administrator is the lead DBA for the DB2 products on one or more of the
following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and
Windows. This individual has extensive experience as a DBA and extensive
knowledge of DB2 9. This person is capable of performing the advanced tasks
such as performance, high availability, security and networking that are
required.
|
|
|
Course title:
DB2 UDB Performance Tuning and Monitoring Workshop
Course duration: 4.0 days
Course number: CF41 (Worldwide). CF413 (US)
Abstract: Learn how to tune for optimum performance the IBM DB2
UDB for Linux, UNIX, and Windows relational database management system and
associated applications written for this environment. Learn about DB2 UDB for
Linux, UNIX, and Windows in a single partition database environment. Explore
performance issues affecting the design of the database and applications using
the database, the major database performance parameters, and the different
tools that assist in performance monitoring and tuning. Use tools in
class that are common across the Linux, UNIX, and Windows environments. During
labs running on DB2 UDB V8.2, develop your ability to use the common tools to
independently tune a database running on your local Windows workstation.
Course Materials The course materials cover DB2 UDB Version 8.2
for Linux, UNIX, and Windows. Hands-On Labs Ten labs are
included to address using DB2 UDB Version 8.2 for Linux, UNIX, and Windows.
Certification Prepare for IBM Certification Test 704: DB2 UDB
V8.1 for Linux, UNIX and Windows Advanced Database Administration.
Training Path This course is part of an IBM Training Path.
Taking this course in the recommended sequence allows you to maximize the
benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag
e&contentID=a0000371
This is an advanced course for database designers, database administrators,
and application developers working with DB2 UDB for Linux, UNIX, and Windows
who are concerned about performance.
| |
Course title:
DB2 UDB Advanced Database Administration for Experts
Course duration: 5.0 days
Course number: CF46 (Worldwide), CF460 (US)
Abstract: Learn to fully use the advanced technical functions
and features of DB2 UDB. Perform advanced monitoring using the snapshot
table functions and extend the functionality for your specific needs. Use the
db2diag.log file messages to direct your investigation of problems using db2pd,
INSPECT, db2support, and DB2 traces. Use DB2's health monitoring and Health
Center to review the health indicator status for the instance, database, and
table space. Problems monitored and resolved include buffer pool activity, lock
contention, long running SQL statements, and log space utilization.
Investigate the DB2 UDB process model, including its processes for log
management, Input/Output (I/O) prefetching, page cleaning and utility
processing for load, backup, and restore. Support intra-partition parallelism
of SQL queries with appropriate settings of configuration parameters.
Explore DB2's management of disk space usage in Database Managed Storage
(DMS) table spaces, including the activities of the rebalancer. Use DB2
commands and utilities to check the high water mark on table spaces and to
monitor the rebalance operation. Move data from one table to another or from
one database to another using utilities, such as db2move and db2relocatedb.
Exploit and monitor the REORG utility processing for offline and online
table, and index reorganization This includes planning for the disk space and
database log space necessary for reorganization. Configure the options and
policies to automate the collection of table and index statistics. Also, the
reorganization of DB2 tables and indexes to improve performance and provide
efficient disk space utilization. Monitor and review DB2's automated operations
using health monitoring and diagnostic log messages. Explore SQL
Procedure Language (SQL PL) routine language elements, execution model, design,
development, debugging, and deployment. Improve performance of SQL PL
procedures using best practice examples. For Multidimensional Clustering
(MDC) tables, determine how to select dimension columns and table space extent
size. Determine configuration options to use for connecting DB2 clients to DB2
UDB database servers using TCP/IP, configuration assistant, and Lightweight
Directory Access Protocol (LDAP). Support remote administration through use of
DB2 Administration Server (DAS). Federate DB2 databases to allow
multiple databases to be accessed in a single SQL statement. Compare and
contrast the functionality of SQL based and Q based replication. You get
practical experience in the planning and utilization of a wide variety DB2 UDB
utilities. Also, complete series of lab exercises using DB2 UDB Enterprise
Server Edition Version 8.2. Course Materials The course materials
cover DB2 UDB for Linux, UNIX, and Windows Version 8.2. Hands-On Labs
Eleven labs are included to address advanced usage of DB2 UDB for Linux,
UNIX, and Windows Version 8.2. Training Path This course is part
of an IBM Training Path. Taking this course in the recommended sequence allows
you to maximize the benefits from your education. Other courses in a
single partition database environment: http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag
e&contentID=a0000371 Other courses in a multiple partition
database environment: http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag
e&contentID=a0000372
This is an advanced course for DB2 UDB experienced database administrators
who support DB2 UDB for UNIX, Windows, and Linux databases.
| |
Course title:
DB2 UDB for Linux, UNIX, and Windows Quickstart for Experienced
Relational DBAs
Course duration: 4.0 days
Course number: CF48 (Worldwide), CF483 (US)
Abstract: Learn how to perform, basic and advanced, database
administrative tasks using IBM DB2 Universal Database. These tasks include
creating and populating databases and implementing a logical design to support
recovery requirements. Examine access strategies and describe strategies chosen
by Optimizer using Explain tools. Use the db2diag.log file messages to direct
your investigation of problems by using db2pd, INSPECT, and db2support and DB2
traces. Also, investigate the DB2 UDB process model, including its processes
for log management, Input/Output (I/O) prefetching, page cleaning and utility
processing for load, backup, and restore. This course addresses a quickstart to
DB2 UDB database administration skills for experienced relational Database
Administrators (DBA). Course Materials The course materials
address DB2 UDB for Linux, UNIX, and Windows V8.2. Hands-On Labs
Eleven labs are included to address DB2 UDB for Linux, UNIX, and Windows
V8.2. Certification Prepare for IBM Certification Test 701: DB2
UDB V8.1 for Linux, UNIX and Windows Database Administration. Training
Path This course is part of an IBM Training Path. Taking this course in
the recommended sequence allows you to maximize the benefits from your
education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag
e&contentID=a0000371
This is an intermediate course for experienced DBAs and technical
individuals, on other relational database platforms, who plan, implement, and
maintain DB2 UDB for Linux, UNIX, and Windows databases.
| |
Course title:
DB2 UDB Advanced Recovery for Single Partition
Databases
Course duration: 4.0 days
Course number: CF49 (Worldwide), CF491 (US)
Abstract: Gain a deeper understanding of the advanced recovery
features of DB2 UDB for Linux, UNIX, and Windows environments. Get practical
experience in the planning and utilization of a wide variety of DB2 UDB
recovery facilities in a series of database recovery scenarios you complete
during lab exercises DB2 UDB Enterprise Server Edition Version 8.2 for a single
partition database. Note: If you support multiple partition DB2 UDB
databases you should plan on attending: DB2 UDB Advanced Recovery for
Multiple Partition Databases (CF49E) Course Materials The course
materials cover DB2 UDB Version 8.2 for Linux, UNIX, and Windows.
Hands-On Labs Eleven labs are included to address using DB2 UDB
Version 8.2 for Linux, UNIX, and Windows. Certification Prepare
for IBM Certification Test 704: DB2 UDB V8.1 for Linux, UNIX and Windows
Advanced Database Administration. Training Path This course is
part of an IBM Training Path. Taking this course in the recommended sequence
allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag
e&contentID=a0000371
This is an advanced course for experienced database administrators and
technical individuals, who plan, implement, and maintain recovery and high
availability for DB2 UDB for Linux, UNIX, and Windows single partition
databases.
|
| |
|
