DB2 UDB Advanced Database Administration for Experts :: CF460

ExitCertified US

ExitCertified Canada English

ExitCertified Canada French



	start > courses and registration > training feature sheet

DB2 UDB Advanced Database Administration for Experts

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

code.

CF460

length.

5 days

type.

Instructor-Led

partner.

IBM

price.

$3,250

This course is designed to teach you how to:

	Fully use the advanced technical functions and features of DB2 LUW.
	Perform advanced monitoring using the DB2 administrative views and routines in SQL queries. Use the db2diag.log file messages to direct your investigation of problems using db2pd, INSPECT, db2support, and DB2 traces. Use DB2's health monitoring and Health Center to review the health indicator status for the instance, database, and table spaces. The type of problems monitored and resolved include buffer pool activity, lock contention, long running SQL statements, and log space utilization.
	Investigate the DB2 LUW process model, including its processes for log management, Input/Output (I/O) prefetching, page cleaning and utility processing for load, backup, and restore.
	Explore DB2's management of disk space usage in Database Managed Storage (DMS) table spaces, including the activities of the rebalancer. Use DB2 commands and utilities to check the high water mark on table spaces and to monitor the rebalance operation. Move data from one table to another or from one database to another using utilities, such as db2move and db2relocatedb.
	Implement automatic storage management for table spaces or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
	Exploit and monitor the REORG utility processing for offline and online table, and index reorganization This includes planning for the disk space and database log space necessary for reorganization. Configure the options and policies to automate the collection of table and index statistics or the reorganization of DB2 tables and indexes to improve performance and provide efficient disk space utilization. Monitor and review DB2's automated operations using health monitoring and diagnostic log messages.
	Utilize the REORG Utility to implement row compression for large tables, to reduce disk utilization and improve I/O performance for a DB2 database.
	For Multidimensional Clustering (MDC) tables, determine how to select the dimension columns and table space extent size for efficient implementation of MDC tables. Compare the block indexes used for MDC table with rows based indexes.
	Determine configuration options to use for connecting DB2 clients to DB2 LUW database servers using TCP/IP using the configuration assistant. Implement DB2 support for Lightweight Directory Access Protocol (LDAP) or DB2 thin client support to reduce administration requirements. Enablement of remote administration through use of DB2 Administration Server (DAS).
	Plan and implement range based table partitioning for large DB2 tables. Utilize the ALTER TABLE ATTACH and DETACH options to support roll-in and roll-out operations for range-partitioned tables. Compare the advantages of selecting or combining range partitioning with the hash-based partitioning used in DB2 DPF databases or the multiple dimensions provided by MDC tables.
	You get practical experience in the planning and utilization of a wide variety DB2 LUW utilities and functions by performing a series of lab exercises using DB2 Enterprise 9 installed on a Linux platform. The exercises build skills that can be applied to DB2 database servers on any Linux, UNIX or Windows environment.

course schedule

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 advanced course for DB2 LUW experienced database administrators who support DB2 for UNIX, Windows, and Linux databases.

prerequisites

You should complete:

	DB2 9 Database Administration Workshop for Linux (CL201) or
	DB2 9 Database Administration Workshop for UNIX (CL211) or
	DB2 9 Database Administration Workshop for Windows (CL231) or
	Fast Path to DB2 9 for Experienced Relational DBAs (CF282) or
	DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CF484 or
	DB2 UDB Multi Partition Database Administration Workshop for UNIX (CF242) or
	DB2 UDB Multi Partition Environment for Single Partition DBAs (CG242)
	or have equivalent experience.

skills gained

After completing this course, you should be able to:

	Monitor a DB2 LUW database using command line processor queries
	Use the db2diag command to search the DB2 diagnostic log messages to resolve various common database problems
	Configure a DB2 database for autonomic utilities, including database statistics collection and table reorganization
	Analyze REORGCHK reports to determine if the table or the index reorganization would improve database efficiency. Invoke and monitor the processing for the REORG utility running offline or online
	Manage the disk space allocated in DMS table spaces using ALTER TABLESPACE to extend or to reduce the containers, and monitor the progress of the DB2 rebalancer process
	Implement automatic resize for DMS table spaces or Automatic Storage management for table spaces to reduce the complexity of managing DB2 LUW databases
	Use the DB2LOOK utility to extract the Data Definition Language (DDL) for existing database objects
	Plan and execute the DB2MOVE utility to copy selected table data for an entire schema for objects from one DB2 database to another
	Configure the TCP/IP connections from DB2 clients to DB2 database servers to support application access or remote administration by database administrators
	Plan the movement of DB2 databases or tablespaces using the Backup and Restore utilities or using the db2relocatedb command with non-DB2 utilities.
	Plan and implement MDC tables to improve application performance, including selecting the appropriate table space extent size
	Utilize range-based partitioned tables to support large DB2 tables that require very efficient roll-in and roll-out capabilities

course materials

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

hands-on labs

Nine labs are included to address advanced usage of DB2 9 for Linux, UNIX, and Windows.

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

course content details

	Advanced Connectivity and Remote Administration

	Describe and verify the relevant registry variables for distributed architecture
	Describe the flow through the different directories used by DB2 for connectivity between clients and servers
	Maintain the directories for database connections
	Enable DB2 LUW LDAP support
	Explain the differences between the different options for client connectivity including the DB2 Client and DB2 Run Time Client
	Implement automatic client rerouting and list the relevant entries
	Describe the purpose of DB2 Administration Server (DAS)
	Establish the TOOLS CATALOG database and identify how it is used
	Utilize the Configuration Assistant to maintain database connection configurations for clients

	Advanced Locking for DB2 9

	Describe the types of locks used by DB2 to support applications using different isolation levels
	Configure the database parameters locklist and maxlocks to minimize lock escalations and lock waits
	Utilize SNAPSHOT and Event monitors to analyze application lock waits and deadlocks • Set the DB2 registry variables to improve application efficiency, including DB2_EVALUNCOMMITTED, DB2_SKIPINSERTED and DB2_SKIPDELETED
	Describe the improved locking characteristics of Type-2 Indexes
	Explain the use of Block level locks for Mulitdimensional Clustering, MDC tables

	Advanced Monitoring

	Compare using GET SNAPSHOT commands to running SQL queries to collect snapshot monitor data
	Describe the impact of enabling the Snapshot Monitor switches on the monitor data available and the performance overhead associated with collecting more detailed monitor data
	Use the DB2 provided Administrative Views and Routines in SQL SELECT statements to retrieve snapshot performance statistics
	Check database health indicators, like log space available and table space utilization using CLP queries with the Administrative Views

	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

	DB2 Process Model

	Describe the Process model used for DB2 databases with and without the Database Partitioning Feature (DPF)
	List some of the DB2 processes used for processing utilities like LOAD, BACKUP, RESTORE and REORG

	Advanced Table Space Management

	Describe the reasons for reorganizing tables and indexes
	Examine a REORGCHK report to determine which tables and indexes to reorganize
	Use GET SNAPSHOT commands, the db2pd command, or queries with DB2 provided table functions to monitor REORG Utility progress
	Analyze DB2 generated messages in the db2diag.log file and administration notification log to resolve the problems
	Utilize the REORG Utility to implement row compression for a table
	Plan the use of offline and online table and index reorganizations to minimize the impact to applications and optimize performance
	Understand the locking and logging required for online and offline REORGs

	Advanced Data Movement

	Describe the options for moving data between tables including using the Import, Export and Load utilities as well as an SQL Insert with a subselect
	Configure the LOAD Utility options to optimize the performance of loading data into DB2 tables
	Select the best method for duplication of table and index definitions, including the db2look utility
	Utilize the db2move utility to move a group of tables into the same or a different database
	Copy the objects for a schema using the db2move utility or the ADMIN_COPY_SCHEMA procedure
	Change the Automatic Storage paths for a database
	Use the RESTORE Utility with a REDIRECT option to move an 1entire database or selected table spaces to a different location
	Setup a db2relocatedb command file to rename a database, copy a database or move table space containers

	Advanced Table Reorganization

	Describe the reasons for reorganizing tables and indexes
	Examine a REORGCHK report to determine which tables and indexes to reorganize
	Use GET SNAPSHOT commands, the db2pd command, or queries with DB2 provided table functions to monitor REORG Utility progress
	Analyze DB2 generated messages in the db2diag.log file and administration notification log to resolve the problems
	Utilize the REORG Utility to implement row compression for a table
	Plan the use of offline and online table and index reorganizations to minimize the impact to applications and optimize performance
	Understand the locking and logging required for online and offline REORGs

	Multidimensional Clustering

	Compare the features and performance advantages of multidimensional clustering (MDC) to single-dimensional clustering
	Define the concepts of MDC tables, including cell, slice, and dimension
	Describe the characteristics of the block indexes used for MDC tables including the index maintenance performed for SQL INSERT, DELETE, and UPDATEs
	Explain how the block and row indexes can be combined to efficiently process SQL statements
	Utilize the LOAD Utility to roll-in new data in a MDC table
	Analyze the effects on table space size of selecting alternative dimensions and extent sizes

	Autonomic DB2 Utilities

	Describe the automatic database maintenance facilities provided by DB2 for database backups, table statistics collection and table reorganization
	Configure a database for automated utilities using the Configure Automatic Maintenance wizard
	Explain the evaluation cycles for each of the automated utilities
	Analyze the DB2 event messages in the db2diag.log file generated by automatic utility evaluation and execution

	Table Partitioning

	Describe the options for handling data roll-in and roll-out using DB2 Version 8.2 features, including DPF database partitioning, Multi-Dimensional Clustering (MDC) and UNION ALL views.
	Describe the basic concepts for range-based table partitioning, including global indexing and multiple table spaces.
	Define the data partition ranges for a table using the short and long form syntax.
	List the steps used for data roll-in and roll-out for table partitioning, including ATTACH, DETACH and ADD for data partitions.
	Compare the roll-in and roll-out functions for table partitioning to using DPF database partitions or MDC tables.
	Plan the use of online SET INTEGRITY as part of the roll-in and roll-out processing for range-partitioned tables.
	Describe the maintenance for refresh immediate materialized query tables when used with table partitioning.
	Select between table partitioning, MDC, and DPF database partitioning depending on the application and data characteristics.

	Agenda - Day 1

	Welcome
	Unit 1 - Advanced Connectivity and Remote Administration
	Exercise 1 - DB2 Advanced Connectivity
	Unit 2 - Advanced Locking
	Unit 3 - Advanced Monitoring
	Exercise 2 - DB2 Advanced Monitoring with SQL

	Day 2

	Unit 4 - Advanced Problem Determination
	Exercise 3 - DB2 Advanced Problem Determination
	Unit 5 - DB2 Process Model
	Unit 6 - Advanced Table Space Management
	Exercise 4 - DB2 Advanced DMS Table Space Management

	Day 3

	Unit 7 - Advanced Data Movement
	Exercise 5 - DB2 Advanced Data Movement
	Unit 8 - Advanced Table Reorganization
	Exercise 6 - DB2 Advanced Table Reorganization

	Day 4

	Unit 9 - Multiple Dimension Clustering
	Exercise 7 - DB2 Multidimensional Clustering
	Unit 10 - Autonomic DB2 Utilities
	Exercise 8 - Autonomic Database Utilities

	Day 5

	Unit 11 - Table Partitioning
	Exercise 9 - Table Partitioning

Free Chumby with IBM Training

Save on IBM Training

Give your team direction. Authorized IT education.

	go to top

© 2008 ExitCertified. All rights reserved.

terms of use and disclaimer :: privacy policy :: webmaster :: link to us

Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware

sun microsystems training | veritas training | linux training | mysql training | symantec training
oracle training| project management training | ibm training | netapp :: network appliance training