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