IBM DB2 Universal Database V7.1 Transition Part 2: Business Intelligence and DB2 Enhancements

Rating:
Summary: IBM DB2 Universal Database V7.1 Transition Part 2: Business
Review: Course Overview
This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements.

Learn To

Identify the components of the data warehousing process.
Identify the enhancements in Business Intelligence (BI) products available for DB2 version 7.1
Identify the components of Visual Warehouse in DB2 version 6.1 and version 7.1.
Identify the guidelines for enabling dynamic to static SQL conversion.
Identify the modes of the conversion mechanism.
Identify the features of the DB2 Capture Utility (DB2CAP).
Identify the features of DB2 Everyplace.
Identify the DB2 Connect enhancements.
Identify the functions of DB2 connection concentration.

Audience
The audience for this course includes database administrators, application designers, technical support and technical specialists who require information about the features and functions of DB2 UDB for Unix, Windows and OS/2 V7.1.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.80 CEUs

Language Options
US English

Total Learning Time
8 hours

Objectives
Unit 1: Business Intelligence 3 hours

Identify the components of the data warehousing process.
Identify the enhancements in BI products available for DB2 version 7.1.
Identify the components of Visual Warehouse in DB2 version 6.1 and version 7.1.
Identify the main components of the process for populating the target database.
Identify the data sources and target databases of data warehousing.
Identify the characteristics of steps.
Identify the characteristics of DB2 DataPropagator.
Sequence the steps in DB2 replication integration.
Identify the features of Control Databases in the warehouse environment.
Identify benefits of the information catalog.
Identify the features of the Data Warehouse Center.
Identify the general and platform-specific features of DB2 version 7.1 Warehouse Manager.
Identify the features of the Information Catalog Manager.
Identify the features of the Query Management Facility (QMF).
Identify features of the DB2 Query Patroller.
Identify new features in warehousing.

Unit 2: Administrative Enhancements 3 hours

Identify the guidelines for enabling dynamic to static SQL conversion.
Identify the functions of the DB2ckbkp utility.
Identify the characteristics of a log flush.
Identify the functions of filtered log recovery.
Identify the new format extensions supported by the Import and Load utilities.
Identify the features of identity column support.
Identify the modes of the conversion mechanism.
Identify the features of the DB2CAP.
Identify the features of generated column support.
Identify the factors to consider when using Load authority.
Identify the features of the DB2batch command in parallel export.
Identify the enhancements to replication.
Identify the DB2 support features for Windows 2000.
Identify the character lengths supported by DB2.
Identify the consistency features of the DB2 family.
Identify the performance and capacity enhancements for DB2 V7.1.

Unit 3: DB2 Family Enhancements 2 hours

Identify the features of DB2 Everyplace.
Identify the DB2 Connect enhancements.
Identify the functions of DB2 connection concentration.
Identify the connection concentrator restrictions with DB2.
Identify the additional DB2 Connect enhancements.
Identify the DB2 for OS/390 functions incorporated into the Control Center.
Identify the Data Links enhancements in DB2 version 7.1.
Identify the additional Data Links enhancements to DB2 version 7.1.
Identify the enhancements to satellite administration.