DB2 UDB Advanced Administration for Experienced Relational DBAs

IACET credits 3.2

This course replaces CF481. Learn how to administer an IBM DB2 UDB database. Take a fast path to advanced DB2 UDB database administration skills for experienced database administrators on other relational database management systems, such as Oracle, Informix, Sybase, and DB2 for OS/390.

These tasks include problem determination, advanced load usage, parallelism and Symmetric Multiprocessor (SMP) exploitation, DB2 governor, audit facility, distributed data management, remote administration, multidimensional data clustering, online reorganizations, and federated database support.

Learn the skills you need for IBM Certification Test 701: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration.

This course addresses DB2 UDB for Linux, UNIX, and Windows V8. The first two days are identical to:

? Fast Path to DB2 UDB for Experienced Relational DBAs (CF281)

This course can be substituted for the following courses, which are longer versions for individuals with less experience:

? DB2 UDB Advanced Administration Workshop (CF453)
? DB2 Universal Database Administration Workshop for Linux (CF201)
? DB2 Universal Database Administration Workshop for UNIX (CF211)
? DB2 Universal Database Administration Workshop for Windows (CF231)
? DB2 UDB Administration Workshop for Sun Solaris (CF271)

course content details

	Overview of DB2 UDB

	overview of the IBM DB2 UDB
	customize your DB2 system and instance

	Getting started with DB2 UDB GUIs

get started with DB2 UDB GUI tools

	Creating databases and data placement

	create databases
	create tablespaces

	Creating objects

create objects: tables, views, aliases, indexes, referential integrity constraints, check constraints, and triggers

	Moving data

move data using import and load utilities

	Recovery

	develop and implement a recovery strategy
	discuss logging, recovery/restart functions, point in time recovery, and general considerations regarding disaster recovery.
	create backup images of a database, restore a database from a backup image, rollforward a database to perform full recovery, and perform actions to reactivate databases in exception states

	Monitoring and problem determination

	use error logs for problem determination
	explore monitors
	explore explain facility

	Concurrency

	learn what objects are locked
	learn how to manage the locking strategy
	use the system monitor to analyze locking occurring on your database
	use the Snapshot Monitor in order to perform basic lock monitoring, understand the concepts of lock time-outs, and illustrate the concept of deadlocks

	Application alternatives

learn about application alternatives.

	Application performance

use the REORGCHK, REORG, and RUNSTATS utilities

	Security

	administer DB2 authorities
	manage privileges

	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
	configure and administer remote systems

	Problem determination tools and techniques

	interpret the Notification log files for problem determination, use of the inspect, db2support
	solve a problem and to use inspect and db2support

	Advanced utility topics

	move large numbers of tables from one database to another using db2move tool
	use db2cfexp and db2cfimp to export and import profiles
	use the alter tablespace command to manage DMS containers.

	Online table and index reorganization

use online table and index reorganization

	Multidimensional clustering

	learn the capability of DB2 UDB multidimensional clustering
	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

	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

	Data access modules