DB2 Universal Database Administration Workshop for Windows

start > courses and registration > training feature sheet

This course has been upgraded to:

»	CL231 DB2 9 Administration Workshop for Windows

This course is no longer publicly scheduled and displayed for reference purposes only. To find more information about this course expiry or request this archived course, send us an email.

DB2 Universal Database Administration Workshop for Windows

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

CF231

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,300

IACET credits 3.2

Learn how to perform database administration tasks using DB2 UDB for Linux, UNIX, and Windows. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Use a Windows operating system during hands-on labs.

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 database administrators and other technical individuals who plan, implement, and maintain DB2 UDB for Linux, UNIX and Windows databases.

prerequisites

You should complete:

? DB2 SQL Workshop (CF120)

? OR have equivalent knowledge of SQL basics

and be able to:

? Use the basic functions of Windows and the user interface
State the functions of the SQL and construct Data Definition Language (DDL), Data Modification Language (DML), and authorization statements

? Discuss basic relational database concepts and objects, such as tables, indexes, views, and joins

skills gained

	List and describe the components of DB2 UDB
	Implement DB2 security
	Perform basic administration of a DB2 database system
	Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
	Describe the application development process with respect to DB2 considerations

course materials

The course materials address DB2 UDB for Linux, UNIX, and Windows Version 8.

hands-on labs

Nine labs are included to address DB2 UDB for Linux, UNIX, and Windows.

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.

skill level

Intermediate

ibm education advantage program eligibility:

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

related courses, exams and materials

	before related training and products

CE120 SQL Workshop

	after related training and products

CF491 DB2 UDB Advanced Recovery for Single Partition Databases

course content details

	Overview of DB2 UDB

	list the DB2 family of products
	identify the DB2 UDB products
	describe the functions of DB2 components
	compare DB2 packaging options and product requirements
	list DB2 supported configurations

	Getting started with DB2 UDB Graphical User Interface (GUI)

	list the GUI tools in DB2 UDB
	explore the various ways to access the GUI tools
	use different methods to execute a command or statement in DB2 UDB

	Creating databases and data placement

	create DB2 databases
	identify default objects that are created when a database is created
	identify how table spaces may be defined to store different types of data
	describe the two types of table space management
	identify when each type of table space management should be used
	create System Managed Storage (SMS) table spaces
	create Database Managed Storage (DMS) table spaces

	Create objects

	describe DB2 object hierarchy
	create database objects: tables, indexes, views, aliases, and schemas
	alter tables and add check constraints, triggers, and referential integrity
	describe Large Objects (LOB)

	Moving data

	describe and use the export and import utilities
	describe and use the load utility
	describe the functionality of the DB2 replication component

	Recovery

	state the three types of recovery support
	explain the principles DB2 uses for its recovery/restart functions
	describe the capabilities and functional requirements of DB2 logging
	use the utilities to back up and recover user data and DB2's catalog
	recover data to a prior point in time
	state general considerations regarding disaster recovery
	prepare and implement standard recovery procedures for data recovery

	Monitoring and problem determination

	use error logs
	identify the different monitor types
	identify how to obtain a db2trc
	describe the function of EXPLAIN and use this facility to assist basic analysis
	identify additional commands for listing application information

	Concurrency

	list objects that may be locked by the database manager
	discuss available lock modes and their compatibility
	influence locking strategies used by the database manager

	Application alternatives

	prepare applications that access DB2 data for execution
	use PRECOMPILE and BIND options that are appropriate for specific application requirements
	describe the application alternatives available to access DB2 data or request other DB2 functions
	list the benefits, and possible disadvantages, of the various interfaces

	Application performance

	list reasons for REBIND of application programs and execute this command
	define the concept of single dimensional clustering, and determine the proper cluster sequence, if any, for DB2 tables
	use RUNSTATS, REORGCHK, and REORG to enhance application performance
	identify configuration parameters that impact performance of applications

	Security

	use DB2 access control mechanisms to implement security within the database
	use group IDs to create a control hierarchy
	describe privileges within a database
	describe privileges required for binding and executing a package
	describe the difference between explicit privileges and implicit privileges
	describe the different DB2 authorization levels

	Daily Agenda

	Day 1

	Welcome
	Overview of DB2 Universal Database
	Getting Started with DB2 UDB GUIs
	Lab (DB2 Customization)
	Creating Databases and Data Placement
	Lab (Creating Databases/Tablespaces)

	Day 2

	Lab (Creating Databases/Tablespaces) (Continued)
	Create Objects
	Lab (Create Objects)
	Moving Data
	Lab (Moving Data)

	Day 3

	Lab (Moving Data) (Continued)
	Recovery
	Lab (Recovery)
	Monitoring and Problem Determination
	Concurrency
	Lab (Investigating DB2 Locking)
	Application Alternatives

	Day 4

	Lab (Preparing Applications for Execution)
	Application Performance
	Lab (Application Performance Tools)
	Security
	Lab (Securing the DB2 Environment)