DB2 9 Administration Workshop for Windows

start > courses and registration > training feature sheet

code.

CL231

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Use a Windows operating system during hands-on labs.

Phoenix, AZ	aug.11.2008 - aug.14.2008	register
Tucson, AZ	aug.25.2008 - aug.28.2008	register
Tucson, AZ	oct.14.2008 - oct.17.2008	register
Phoenix, AZ	oct.21.2008 - oct.24.2008	register
San Jose, CA	aug.18.2008 - aug.21.2008	register
Sacramento/Elk Grove, CA	sep.15.2008 - sep.18.2008	register
San Francisco, CA	sep.15.2008 - sep.18.2008	register
El Segundo/Los Angeles, CA	sep.15.2008 - sep.18.2008	register
San Jose, CA	sep.29.2008 - oct.2.2008	register
El Segundo/Los Angeles, CA	nov.3.2008 - nov.8.2008	register
Santa Clara, CA	nov.3.2008 - nov.6.2008	register
Sacramento/Elk Grove, CA	nov.3.2008 - nov.6.2008	register
Englewood/Denver, CO	aug.11.2008 - aug.14.2008	register
Englewood/Denver, CO	oct.21.2008 - oct.24.2008	register
Englewood/Denver, CO	nov.3.2008 - nov.6.2008	register
Washington, DC	sep.22.2008 - sep.25.2008	register
Washington, DC	dec.15.2008 - dec.18.2008	register
Tampa, FL	nov.10.2008 - nov.13.2008	register
Atlanta, GA	oct.14.2008 - oct.17.2008	register
Chicago, IL	aug.18.2008 - aug.21.2008	register
Chicago, IL	nov.17.2008 - nov.20.2008	register
Overland Park, KS	oct.21.2008 - oct.24.2008	register
Boston, MA	nov.3.2008 - nov.6.2008	register
Hunt Valley/Baltimore, MD	aug.25.2008 - aug.28.2008	register
St louis/Maryland Heights, MO	aug.11.2008 - aug.14.2008	register
St louis/Maryland Heights, MO	oct.21.2008 - oct.24.2008	register
Durham/Raleigh, NC	oct.27.2008 - oct.30.2008	register
New York/Downtown, NY	sep.8.2008 - sep.11.2008	register
New York/Downtown, NY	dec.1.2008 - dec.4.2008	register
Philadelphia, PA	oct.6.2008 - oct.9.2008	register
Irving/Dallas, TX	sep.29.2008 - oct.2.2008	register
Bellevue/Seattle, WA	sep.15.2008 - sep.18.2008	register
Bellevue/Seattle, WA	nov.3.2008 - nov.6.2008	register

who can benefit

This is an intermediate course for system administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

prerequisites

Before taking this course you should be able to:

	Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
	State the functions of the Structured Query Language (SQL), and be able to construct Data Definition Language (DDL), Data Manipulation Language (DML), and authorization statements
	Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
	These skills can be developed by taking:
	OS Training
	Windows Systems Administration
	or have equivalent administration experience
	SQL Basics
	DB2 SQL Workshop (CF120, CF12G, CE120, CE120G) or
	DB2 SQL Workshop (self-paced virtual class) (C12A1) or
	DB2 SQL Workshop - (Instructor Led OnLine)(3E120, 3E12G, 3E120G)
	or have equivalent knowledge of SQL basics

skills gained

After completing this course, you should be able to:

	Administer a DB2 database system using commands and GUI tools
	Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
	Implement a given logical database design using DB2 to support integrity and concurrency requirements
	List and describe the components of DB2
	Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
	Use autonomic features of DB2
	Implement DB2 security

course materials

The course materials address DB2 9.5 for Linux, UNIX, and Windows.

hands-on labs

Eleven labs are included to address DB2 9.5 for Linux, UNIX, and Windows.

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

what's next

Use the link to the Training Path in the course description for easy access to prerequisite courses, and other courses that might be of interest to you.

The next courses that may be of interest to you include:

	DB2 9 for LUW Advanced Database Administration for Experts (CF460, CF46G, CL460, CL460G)
	DB2 9 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop (CF413, CF41G, CL410, CL410G)
	DB2 9 for LUW Advanced Database Recovery (CF492, CF49G, CL490, CL490G)

related courses, exams and materials

	before related training and products

CE120 SQL Workshop

	after related training and products

	CF413 DB2 9 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
	CF460 DB2 UDB Advanced Database Administration for Experts

course content details

	Overview of DB2 9 on Linux, UNIX and Windows

	Contrast the DB2 Family of products
	Identify the DB2 Products
	Describe the functions of DB2 components
	Explore installation and parameters

	Command Line Processor (CLP) and Graphical User Interface (GUI) usage

	Use the Command Line Processor
	Explore the GUI environment
	Describe the DAS role with GUI tools

	The DB2 environment

	Specify the key features of an Instance
	Create and drop an Instance
	Use db2start and db2stop
	Distinguish between types of configuration
	Describe and modify the Database Manager Configuration

	Creating databases and data placement

	Review specifics of creating a database
	Explore the System Catalog tables and views
	Compare DMS versus SMS table spaces
	Describe how to setup and manage a DB2 database with Automatic Storage enabled
	Differentiate between table spaces, containers, extents, and pages
	Define table spaces
	Use the get snapshot for tablespaces command to display table space statistics
	Explore Database configuration parameters

	Creating database objects

	List DB2 object hierarchy and physical directories and files
	Create the following objects: Schema, Table, View, Alias, Index
	Explore the use of table partitioning
	Review the use of Temporary Tables
	Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
	Exploring the need for and the use of Large Objects
	Recognize Extensible Markup Language (XML) and its native store as critical infrastructure for emerging technologies

	Moving data

	Discuss the INSERT statement and recognize its limitations
	Explain the differences between IMPORT and LOAD
	Explain the EXPORT, IMPORT, and LOAD syntax
	Create and use Exception Tables and Dump-Files
	Distinguish and resolve Table States: Load Pending and Set Integrity Pending
	Use the SET INTEGRITY command
	Discuss the db2move and db2look commands

	Backup and recovery

	Describe the major principles and methods for backup and recovery
	State the three types of recovery used by DB2
	Explain the importance of logging for backup and recovery
	Describe how data logging takes place, including circular logging and archival logging
	Use the BACKUP, RESTORE, and ROLLFORWARD commands
	Perform a table space backup and recovery
	Restore a database to the end of logs or to a point-in-time
	Discuss the configuration parameters and the recovery history file and use these to handle various backup and recovery scenarios

	Locking and concurrency

	Explain why locking is needed
	List objects that can be locked
	Describe and discuss the various lock modes and their compatibility
	Explain four different levels of data protection
	Set isolation level and lock time out for current activity
	Explain lock conversion and escalation
	Describe the situation that causes deadlocks

	Problem determination

	Collect information for problem analysis and resolution
	Use error logs for basic problem analysis
	Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, and Health Monitor
	Describe the function of EXPLAIN and use this facility to assist basic analysis
	Use a series of basic commands to better work with connections and sessions
	Retrieve statistics and other information from a running DB2 instance

	Security

	Use DB2 access control mechanisms to implement security within the database
	Use group IDs to create a control hierarchy
	Describe Label Based Access Control (LBAC)
	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

	Agenda - Day 1

	(00:30) Welcome
	Unit 1 - Overview of DB2 on Linux, UNIX and Windows
	Lab 1 (Starting your lab environment)
	Unit 2 - Command Line Processor (CLP) and GUI usage
	Lab 2 (DB2 CLP usage)
	Unit 3 - The DB2 environment
	Lab 3 (Create an instance and explore the environment)

	Day 2

	Unit 4 - Creating databases and data placement
	Lab 4 (Creating databases and data placement)
	Unit 5 - Creating database objects
	Lab 5 (Create objects)
	Unit 6 - Moving data
	Lab 6 (Moving data)

	Day 3

	Unit 7 - Backup and recovery
	Lab 7 (Backup and recovery)
	Unit 8 - Locking and concurrency
	Lab 8 (Investigating DB2 locking)

	Day 4

	Unit 9 - Problem determination
	Lab 9 (Problem determination)
	Unit 10 - Security
	Lab 10 (Security)