DB2 UDB Advanced Administration Workshop

start > courses and registration > training feature sheet

code.

CF453

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

IACET credits 3.2

This course replaces CF452. Learn how to perform advanced database administration tasks using DB2 UDB. These tasks include problem determination, advanced load usage, parallelism and Symmetric Multiprocessor (SMP) exploitation, DB2 governor, audit facility, job scheduling, distributed data management, remote administration, multidimensional data clustering, online reorganizations, and use of Health Center and federated database support.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an intermediate course for system administrators, database administrators, and technical individuals, who plan, implement, and maintain DB2 UDB.

prerequisites

You should complete:

	DB2 Universal Database Administration Workshop for Linux (CF201) or
	DB2 Universal Database Administration Workshop for UNIX (CF211) or
	DB2 Universal Database Administration Workshop for Windows (CF231) or
	DB2 UDB Administration Workshop for Sun Solaris (CF271) or
	DB2 UDB Multi Partition Database Administration Workshop for UNIX (CF241) or
	Fast Path to DB2 UDB for Experienced Relational DBAs (CF281) or
	DB2 UDB Multi Partition Environment for Single Partition DBAs (CG241)
	OR have working knowledge of DB2 UDB Version 7 or 8

skills gained

	Effectively apply advanced techniques to administer a DB2 UDB
	Explore parallelism and SMP enablement
	Explore problem determination tools and techniques
	Use online index and online table reorganization
	Explore the multidimensional clustering
	Explore advanced load utilities
	Explore federated databases
	Configure the DB2 governor to enforce time and Central Processing Unit (CPU) restrictions
	Manage a distributed data environment

course materials

The course materials cover DB2 UDB Enterprise Server Edition (ESE) Version 8.

hands-on labs

Eleven labs are included to address using DB2 UDB Enterprise Server Edition (ESE) Version 8.

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.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Education Pack
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

skill level

Advanced

course content details

	Managing jobs through the control center

	manage jobs (scripts) through DB2's scheduler graphical tool
	complete online lab to schedule single and recurring jobs, schedule reorganizations via the task center, and use the command center to schedule a backup

	Remote administration

	learn remote administration using the DB2 UDB Administration Server (DAS), discovery, and working at the instance level with the ATTACH and DETACH commands
	complete online lab to configure and administer remote systems

	The governor and audit

	set up usage rules for a database that are enforced by the DB2 UDB governor
	learn how to stop and start the governor, control it through a configuration file, and interpret its log file
	learn how audit works and how to set up, start, and stop this utility
	complete online lab using the DB2 governor
	complete optional online lab to use the audit function

	Problem determination tools and techniques

	interpret the notification log files for problem determination, use of the inspect, db2support and trace utility
	get additional information in DB2 UDB problem determination
	complete online lab to solve a problem and to use inspect and db2support

	Parallelism and SMP enablement

	Learn how to describe the parallelism and SMP enablement in DB2 UDB
	Complete online lab using Visual Explain to explore an SMP access strategy

	Advanced utility topics

	move large numbers of tables from one database to another using db2move tool
	build a customized catalog for Open Database Connectivity (ODBC) applications using db2ocat
	estimate the storage requirements for your data as it grows using Estimate Size GUI
	use db2look for Data Definition Language (DDL) extract
	use db2cfexp and db2cfimp to export and import profiles, the change of Database Managed Storage (DMS) containers and the high availability monitor.
	complete online lab using db2move, db2cfexp and the advanced capacity management of table spaces.

	Online table and index reorganization

	use online table and index reorganization
	complete online lab demonstrating use of online table and index reorganizations

	Multidimensional clustering

	get introduced to capability of DB2 UDB multidimensional clustering
	complete online lab to examine what happens when you create tables with multidimensional clustering.

	Advanced load

	focus on some of the advanced facilities available in the load facility
	perform a load from a cursor (select statement), an online load, and a load terminate.

	Distributed management

	learn the differences between distributed unit of work, remote unit of work, and distributed request
	discuss options that enable and disable multisite read and multisite update capabilities
	complete online lab to understand the difference between remote unit of work and distributed unit of work
	learn the difference between one phase and two phase commit

	Federated databases

	access data from different databases by using the federated database feature
	complete online lab to configure the DB2 Federated Server so it can access its backend data sources
	complete configuration steps to create wrappers and define servers via the DB2 Control Center or DB2 DDL
	establish client connectivity by cataloging the naming directories (that is, DB2 NODE directory), and possibly link editing the product specific client/server libraries to their respective DB2 Wrapper

	Replication (optional)

replicate (or copy) data from one database to another using DB2 UDB replication capabilities