|
Course title:
DB2 UDB Advanced Database Administration for Experts
Course duration: 5.0 days
Course number: CF46
Abstract: Learn to fully use the advanced technical functions and features of DB2 UDB. Perform advanced monitoring using the snapshot table functions and extend the functionality for your specific needs. 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 space. Problems monitored and resolved include buffer pool activity, lock contention, long running SQL statements, and log space utilization. Investigate the DB2 UDB process model, including its processes for log management, Input/Output (I/O) prefetching, page cleaning and utility processing for load, backup, and restore. Support intra-partition parallelism of SQL queries with appropriate settings of configuration parameters. 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. 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. Also, 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. Explore SQL Procedure Language (SQL PL) routine language elements, execution model, design, development, debugging, and deployment. Improve performance of SQL PL procedures using best practice examples. For Multidimensional Clustering (MDC) tables, determine how to select dimension columns and table space extent size. Determine configuration options to use for connecting DB2 clients to DB2 UDB database servers using TCP/IP, configuration assistant, and Lightweight Directory Access Protocol (LDAP). Support remote administration through use of DB2 Administration Server (DAS). Federate DB2 databases to allow multiple databases to be accessed in a single SQL statement. Compare and contrast the functionality of SQL based and Q based replication. You get practical experience in the planning and utilization of a wide variety DB2 UDB utilities. Also, complete series of lab exercises using DB2 UDB Enterprise Server Edition Version 8.2. Course Materials The course materials cover DB2 UDB for Linux, UNIX, and Windows Version 8.2. Hands-On Labs Eleven labs are included to address advanced usage of DB2 UDB for Linux, UNIX, and Windows Version 8.2. 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. Other courses in a single partition database environment: http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000371 Other courses in a multiple partition database environment: http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000372
This is an advanced course for DB2 UDB experienced database administrators who support DB2 UDB for UNIX, Windows, and Linux databases.
| 
