DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs

start > courses and registration > training feature sheet

DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs

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

code.

CF484

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

Learn how to perform, basic and advanced, database administrative tasks using DB2 9 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the commands db2pd, INSPECT, and db2support and DB2 traces. Also, investigation of the DB2 process model, including its processes for log management, Input/Output (I/O) prefetching, page cleaning and utility processing for load, backup, and restore will be covered. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. This course provides a quickstart to DB2 database administration skills for experienced relational Database Administrators (DBA).

Phoenix, AZ	may.27.2008 - may.30.2008	register
Phoenix, AZ	jul.14.2008 - jul.17.2008	register
Phoenix, AZ	aug.25.2008 - aug.28.2008	register
Phoenix, AZ	oct.6.2008 - oct.9.2008	register
Sacramento/Elk Grove, CA	jul.14.2008 - jul.17.2008	register
San Francisco, CA	jul.14.2008 - jul.17.2008	register
El Segundo/Los Angeles, CA	jul.14.2008 - jul.17.2008	register
Sacramento/Elk Grove, CA	aug.25.2008 - aug.28.2008	register
El Segundo/Los Angeles, CA	aug.25.2008 - aug.28.2008	register
Sacramento/Elk Grove, CA	oct.6.2008 - oct.9.2008	register
El Segundo/Los Angeles, CA	oct.6.2008 - oct.9.2008	register
Santa Clara, CA	oct.6.2008 - oct.9.2008	register
Englewood/Denver, CO	may.27.2008 - may.30.2008	register
Englewood/Denver, CO	jul.14.2008 - jul.17.2008	register
Englewood/Denver, CO	aug.25.2008 - aug.28.2008	register
Englewood/Denver, CO	oct.6.2008 - oct.9.2008	register
Washington, DC	aug.11.2008 - aug.14.2008	register
Atlanta, GA	jul.21.2008 - jul.24.2008	register
Chicago, IL	jun.2.2008 - jun.5.2008	register
Overland Park, KS	may.27.2008 - may.30.2008	register
Overland Park, KS	aug.25.2008 - aug.28.2008	register
St louis/Maryland Heights, MO	may.27.2008 - may.30.2008	register
St louis/Maryland Heights, MO	aug.25.2008 - aug.28.2008	register
Durham/Raleigh, NC	sep.15.2008 - sep.18.2008	register
New York/Downtown, NY	may.13.2008 - may.16.2008	register
New York/Downtown, NY	oct.14.2008 - oct.17.2008	register
Irving/Dallas, TX	may.19.2008 - may.22.2008	register
Bellevue/Seattle, WA	jul.14.2008 - jul.17.2008	register
Bellevue/Seattle, WA	aug.25.2008 - aug.28.2008	register
Bellevue/Seattle, WA	oct.6.2008 - oct.9.2008	register

who can benefit

This is an intermediate course for experienced DBAs and technical individuals, on other relational database platforms, who plan, implement, and maintain DB2 for Linux, UNIX, and Windows databases.

prerequisites

You should be able to:

	Perform basic database administration tasks on a relational database system
	Use basic Operating System (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: AIX 5L Basics, Linux Basics and Administration, Windows Systems Administration, or by having equivalent Hewlett-Packard Universal Interactive Executive (HP-UX) or Solaris administration experience
	DB2 SQL Workshop
	DB2 Universal Database Fundamentals

skills gained

After completing this course, you should be able to:

	List and describe the components of DB2 9 for Linux, UNIX, and Windows
	Implement DB2 security
	Perform basic administration of a DB2 database system
	Plan the tasks necessary to support a recovery strategy
	Describe the application development process with respect to DB2 considerations
	Effectively apply advanced techniques to administer a DB2 database
	Investigate the DB2 process model, including its processes for log management, I/O prefetching, page cleaning and utility processing for load, backup and restore
	Explore the DB2 recovery facilities and database configuration options
	Perform the implementation of automated archival and retrieval of database logs
	Identify Explain tools to examine access strategies
	Select the appropriate utility to relocate a database or a portion of a database, including using the RESTORE utility or the db2relocatedb command
	Use the DB2 Design Advisor to analyze SQL statements to suggest new indexes to improve application performance
	Examine Explain output to determine access strategy chosen by Optimizer
	Use the db2diag.log file messages to direct your investigation of problems using db2pd, INSPECT, db2support, and DB2 traces. Use DB2 health monitoring and Health Center to review the health indicator status for the instance, database and table space

course materials

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

hands-on labs

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

certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX and Windows Database Administration.

ibm education advantage programs eligibility:

Yes - IBM Education Pack - Online Account

related courses, exams and materials

	before related training and products

	LX020 Linux Basics and Installation
	AU130 AIX 5L Basics
	CE120 SQL Workshop

course content details

	Overview of DB2 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
	Explore db2set and registry entries

	Command Line Processor (CLP) and 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
	Differentiate between table spaces, containers, extents, and pages
	Define table spaces
	Use the get snapshot for tablespaces and get snapshot for tablespace containers commands
	Explore 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 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, Backup Pending, 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

	Application issues and performance

	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 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

	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

	DB2 Process model

Describe the DB2 process model used for DB2 9 databases and instances: DB2 process model without Database Partitioning Feature (DPF), DB2 process model with DPF, and utilities (load / backup / restore)

	DB2 Recovery Log management

	Configure the DB2 Database parameters that support the DB2 logs
	Describe the user exit interface used to archive logs in previous DB2 versions
	Configure the database options to automate log management
	Identify the options provided by DB2 to reduce log volume, including the NOT LOGGED INITIALLY option.

	DB2 Database and Table space relocation

	Explain the facility of the DB2 RESTORE command to recover table spaces to different containers
	Use the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore
	Utilize the RESTORE utility to change the database storage paths for AUTOMATIC STORAGE table spaces
	Plan the use of redirected restore as part of a disaster recovery
	Use the GENERATE SCRIPT option of RESTORE to set up a command script for a redirected restore operation
	Use db2relocatedb when moving or copying DB2 databases with non-DB2 utilities.

	Using Explain tools

	Describe the advantages of using Visual Explain
	Describe the advantages of using db2exfmt
	Create special tables used by Visual Explain and db2exfmt
	Identify how to set the explain snapshot and explain mode registers to capture the information of interest
	Differentiate between the different methods of viewing explain information

	Using Indexes for Performance

	Describe the Indexing options that can be used to improve performance: Index Only Access, Clustered Index, Reverse Scans, Include Columns, and Index Freespace
	Describe the Block Indexing capability for MDC tables
	Explain how multiple indexes can be combined using Index ORing and Dynamic Bitmap Index ANDing
	Use the Design Advisor to predict performance gains from adding new indexes

	Advanced problem determination

	Describe the types of information collected by DB2 that can be used to diagnose problems, including the db2diag.log and the administration notification log
	Plan the use of various diagnostic tools to address specific problems, including the db2diag command, db2pd, db2dart, inspect and db2level
	Collect supporting information for DB2 database problems using db2support and db2trc
	analyze DB2 generated messages in the db2diag.log file and choose appropriate tools and commands to resolve the problems
	Utilize the Health Monitoring functions of DB2 to check the health indicators for a DB2 instance, database, or table space

	Daily Agenda - Day 1

	Overview of DB2 on Linux, UNIX, and Windows
	Command Line Processor (CLP) and GUI usage
	Lab 1 (DB2 Customization)
	The DB2 environment
	Creating databases and data placement
	Lab 2 (Creating Databases/Table Spaces)
	Creating database objects
	Lab 3 (Create Objects)