DB2 Version 8: The Official Guide

by Zikopoulos, Paul C.; Baklarz, George; deRoos, Dirk; Melnyk, Roman B.

• ISBN13: 9780131401587
• ISBN10: 0131401580
• Edition: CD
• Format: Paperback w/CD
• Copyright: 2004-01-01
• Publisher: IBM Press

Summary

DB2 Version 8 represents one of the most feature-packed and significant releases in DB2's history! This book is well organized into topics such as Performance Enhancements, Manageability Enhancements, SQL Enhancements, etc. Each section presents not only the new features in Version 8, but also gives technical details about the new features, gotchas, tips and tricks, and examples of how to use them - this kind of insider information is not currently available on the market today!

Table of Contents

Foreword

Dedications and Acknowledgments

Packaging and Licensing

Changes to DB2 Universal Database and DB2 Connect Packaging and Licensing

DB2 Universal Database and DB2 Connect Supported Operating Systems

Changes to DB2 Universal Database Licensing and Packaging

DB2 UDB Personal Edition

DB2 UDB Express

DB2 UDB Workgroup Server and Workgroup Server Unlimited Editions

DB2 UDB Enterprise Server Edition and the Database Partitioning Feature

DB2 UDB Data Warehouse Edition

Changes to DB2 Connect Licensing and Packaging

DB2 Connect Application Server Edition

Integrated DB2 Connect Component in DB2 Universal Database Enterprise Edition

Miscellaneous Changes

Changes to Related DB2 Universal Database Products

Performance

Multidimensional Clustering Tables

MDC 101: A Simple Contrast between Traditional and Multidimensional Tables

Terminology Required to Understand MDC Tables

MDC Table

Dimension

Slice

Cell

Block

Block Size or Blocking Factor

Block Index

Block ID

Generated Column

Monotonicity

How MDC Tables Work

Creating an MDC Table

Indexes and MDC Tables

MDC and Query SELECT, INSERT, UPDATE, and DELETE Operations

Picking a Dimension for an MDC Table

Summary

Declared Global Temporary Tables

Index Support for DGTTs

Index Restrictions on a DGTT

Creating an Index on a DGTT

Minimal Undo Logging to Support the Rollback of Data Changes to DGTTs

Statistics Support on DGTTs

System Default Value and NULL Compression

How Data Compression Works in DB2 UDB

The New Row Record Format

Compression Example

Supported Data Types for Compression

How Do I Know if Compression Is Turned On?

Estimating Compression Savings

Informational Constraints

Why Informational Constraints?

Using Informational Constraints

Informational Constraints Example

Usage Considerations. 6. Connection Concentrator

Connection Management Improvements

Activating the Connection Concentrator

Connection Concentrator Operation

User-Maintained Materialized Query Tables

Restrictions

Creating Materialized Query Tables

Populating Materialized Query Tables

Leveraging Materialized Query Tables for Improved Query Performance

Database System Monitoring Enhancements

Preventing the Collection of Timestamps

Enhanced Deadlock Monitoring

SQL Access to Event Monitor Data

SQL Access to Snapshot Monitor Data

SNAPSHOT_FILEW Snapshot Request Types

Capturing a Snapshot to a File with SNAPSHOT_FILEW

Capturing a Snapshot From a File

DB2_SNAPSHOT_NOAUTH Registry Variable

Performance Monitor Control Center Tool Has Been Deprecated

Miscellaneous Performance Enhancements

Distributed Catalog Cache

Prefetching Enhancements with Block-Based Buffer Pools

Page Cleaner I/O Improvements

Multithreading of Java-Based Routines

64-Bit Support

Automatic Relationship and Association Management (ARAM)

New Join Variations

Increased Opportunity for Selection of Bit-Filters

Manageability

Logging

Transactional Logging Improvements

Increased Log Space

Infinite Active Log Space

Controlling the Consumption of Log Space

Transactional Logging Performance Improvements

Log Mirroring

Blocking Transactions When the Logs Are Full

Diagnostic Logging Improvements

Load Enhancements

Online Load

Locking Behavior

New Table States

Loading Data into Partitioned Databases

Loading Data from a Cursor

Load Wizard

DB2 Tools

Configuration Assistant

Health Center

Memory Visualizer

Memory Tracker

Storage Management

Storage Management View Columns

Indoubt Transaction Manager

Fault Monitor

Container Operations

Table

Table of Contents provided by Publisher. All Rights Reserved.