Course description: DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9

If you are transitioning from DB2 for LUW V8.2 to 9.5, you should consider the full 4-day transition courses, DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (CL310) or DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 - ILO (3L310)

NOTE: This is an instructor led online course. Please do not make travel arrangements for this course. Your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. All Instructor Led On Line US courses start at 9:00 am Central time.

Get the technical information about the new functions and features available in DB2 9.5 for Linux, UNIX, and Windows for current DB2 9.1 database systems. This course is Instructor Led Online version of classroom delivered course (CL311).

View this course in other countries

Training Paths that reference this course are:

• DB2 for Linux, UNIX and Windows Transition

Back to top

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - Online Account

Back to top

This intermediate course is for database administrators, application designers, technical support, and technical specialists who require information about the features and functions of DB2 9.5 for Linux, UNIX, and Windows.

Back to top

You should have working knowledge of DB2 9 for Linux, UNIX, and Windows.

Back to top

• Plan the installation and migration to DB2 9.5 for Linux, UNIX, and Windows
• Describe the new functions and options for administration of DB2 databases provided by DB2 9.5
• Assess the applicability of the DB2 9.5 features and functions in your application environment to maximize the performance, recoverability, security and operational management
• Discuss the advantages and potential impact of this release of DB2 to your environment

Back to top

DB2 9.5 Performance-related Considerations

• Describe the thread based process model implemented in DB2 9.5 and the impact on database and instance configuration options
• Select appropriate settings for INSTANCE_MEMORY, DATABASE_MEMORY and APPL_MEMORY using the DB2 9.5 memory architecture
• Plan the implementation of real time statistics collection
• Utilize the ROW CHANGE expression and RID_BIT function to support applications using optimistic locking
• Describe the advantages of using deferred index cleanup for rollout operations on MDC tables
• List some of the Risky access strategies that may be avoided by the DB2 9.5 optimizer
• Describe the changes in DB2 9.5 to enable parallel processing for creating new indexes to improve performance

DB2 9.5 Security and Audit Enhancements

• Describe the use of database roles to simplify database security
• List the security administration tasks for DB2 databases that require the SECADM database authority, including managing roles, creating trusted contexts and performing database level audits
• Explain the differences between using database roles and group-based privileges
• Plan the implementation of a trusted context to improve database security for a three-tiered application system
• Explain the differences between an explicit trusted connection and an implicit trusted connection
• Create audit policies to enable collection of specific categories of audit data for a DB2 database
• Assign audit policies to selected tables, users or database roles using the AUDIT statement

Application Development Enhancements and Tools

• Describe the support for array data types in Version 9.5.
• Explain the benefits of using the new DECFLOAT data type provided by DB2 9.5.
• Use the CREATE VARIABLE statement to define a Global Variable that enables sharing data between different SQL statements running in the same session (or connection) without the need for application logic to support this data transfer.
• List some of the key features provided by IBM Design Studio for supporting database application development.

DB2 9.5 Installation and Migration Considerations

• Identify the new names for DB2 components used for DB2 9.5
• Effectively plan the installation of DB2 9.5 server and client software
• Plan the migration of DB2 instances and Databases from DB2 Version 8 or DB2 9.1 to utilize DB2 9.5
• List the new database manager and database configuration options supported by DB2 9.5
• Describe the key changes in DB2 instance and database configuration in DB2 9.5
• Plan for installation and maintenance of a DB2 instance using a non-root user on a Linux or UNIX system

DB2 9.5 XML Support Enhancements

• Explain how the XQuery updating expressions enable you to modify portions of an existing XML document instead of having to construct a new one
• Utilize a LOAD utility to load tables with XML columns
• Add small XML columns to a table or change existing XML columns and store these documents in a row of the base table instead of in the default XML storage object
• Describe the functions, XMLRow, XMLGroup and XSLTransform, provided for XML data in DB2 9.5
• List some of the support enhancements for XML data including check constraints, triggers and replication support

DB2 9.5 High Availability and Database Recovery Features

• Describe using the integrated Cluster Management options in DB2 9.5 to simplify implementation and administration when DB2 databases with Cluster Managers
• Utilize the DB2 high availability instance configuration utility db2haicu to configure and administer your database solutions in clustered environments
• Describe selecting a HADR peer window to reduce the risk of data loss during cascading or multiple failures
• Plan and implement DB2 Advanced Copy Services to provide high performance database backup and restore facilities
• Configure the DB2 database option auto_del_rec_obj to automate removal of database objects
• Utilize the Single System View enhancements in DB2 9.5 to simplify backup and recovery of DB2 multiple partition DPF databases

DB2 9.5 Problem Determination and Database Resilience Enhancements

• List several ways to access the DB2 messages that are written to the administration notification log, including a SQL query with the PD_GET_LOG_MSGS table function.
• Utilize the PD_GET_DIAG_HIST table function to query DB2 messages recorded in several different message and error logs based on the level of impact.
• Describe the First Occurrence Data Capture (FODC) facilities implemented in DB2 9.5.
• Use the db2fodc command to manually capture diagnostic information for hang condition on a DB2 server.
• Configure the DB2_CAPTURE_LOCKTIMEOUT registry variable to collect diagnostic information for lock timeouts.
• Implement the storage protection features of DB2 9.5 using the DB2_MEMORY_PROTECT and DB2_THREAD_SUSPENSION registry variables.

DB2 9.5 Partitioned Database (DPF) Enhancements

• Describe the changes in DB2 9.5 for updating the configuration of partitioned databases using the UPDATE DATABASE CFG command.
• Plan and implement the enhanced REDISTRIBUTE command options provided by DB2 9.5 to efficiently redistribute data to new database partitions or remove database partitions.
• Describe the changes to REDISTRIBUTE processing to reduce the need to reorganize tables after data redistribution.
• Explain the impact on database recoverability when using the enhanced REDISTRIBUTE command options.
• Utilize the STOP AT and TABLE options of REDISTRIBUTE to better manage large data redistribution operations for partitioned DB2 databases.

Introduction to DB2 Workload Management

• Explain the need for DB2 workload management
• Describe DB2 workload management
• List the components of DB2 workload management
• Define DB2 service classes
• Explain how to use DB2 WLM workloads to group connections
• Describe how thresholds are used with DB2 WLM
• Explain how work actions are used to map work classes
• Describe the monitoring capabilities of DB2 WLM
• Explain how Query Patroller works in conjunction with DB2 WLM

Agenda

Day 1

• Welcome
• Unit 1: DB2 9.5 Performance-related Considerations
• Unit 2: DB2 9.5 Security and Audit Enhancements
• Unit 3: Application Development Enhancements and Tools
• Unit 4: DB2 9.5 Installation and Migration Considerations
• Unit 5: DB2 9.5 XML Support Enhancements

Day 2

• Unit 6: DB2 9.5 High Availability and Database Recovery Features
• Unit 7: DB2 9.5 Problem Determination and Database Resilience Enhancements
• Unit 8: DB2 9.5 Partitioned Database (DPF) Enhancements
• Unit 9: Introduction to DB2 Workload Management

Back to top

• Edit your profile

Easy ways to get the answers you need.

• Online text chat

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

• My enrollments

• My training plan

• How to get to class

• Subscribe to IBM Training RSS feeds

• Training paths will help you decide

• Subscribe to IBM Training News

• IBM Training Flyer (98KB)

• Certification flyer (355KB)

• Training special offers

• IBM Education Pack

  Save on training

• Get Adobe® Reader®