DB2® Version 8: The Official Guide

DB2® Version 8: The Official Guide

by Paul C. Zikopoulos, Roman B. Melnyk, George Baklarz, Dirk Deroos
Released September 2003
Publisher(s): IBM Press
ISBN: 9780131401587

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible.

Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux®, UNIX®, or Windows®.

The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team. They offer detailed, never-before-published technical guidance for the key challenges you'll face in delivering high-performance DB2 databases, e-business infrastructure, and enterprise integration solutions. Coverage includes:

  • Simplifying management with the Configuration Advisor, HealthCenter(, and Memory Visualizer

  • Integrating the enterprise via Federated Web Services and the DB2 enhanced XML productivity tools

  • Maximizing database scalability, availability, and robustness

  • Using multidimensional data clustering and other integrated business intelligence tools

  • Integrating with IBM WebSphere and Microsoft software development tools

  • Leveraging key improvements in DB2 SQL functionality

    • The accompanying CD-ROM contains a complete trial version of IBM® DB2® Universal Database Personal Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus the DB2 demonstration program for trying out the various SQL commands on your own machine.

    If you're an experienced DB2 professional who's ready to take DB2 Version 8 to the max, DB2 Version 8: The Official Guide is the book you've been searching for.

    Table of contents

    1. Copyright
    2. IBM Press Series —Information Management
    3. Foreword
    4. Dedications and Acknowledgments
    5. Packaging and Licensing
      1. Changes to DB2 Universal Database and DB2 Connect Packaging and Licensing
        1. DB2 Universal Database and DB2 Connect Supported Operating Systems
        2. Changes to DB2 Universal Database Licensing and Packaging
        3. DB2 UDB Personal Edition
        4. DB2 UDB Express
        5. Changes to DB2 Connect Licensing and Packaging
    6. Performance
      1. Multidimensional Clustering Tables
        1. MDC 101: A Simple Contrast between Traditional and Multidimensional Clustering Tables
        2. Terminology Required to Understand MDC Tables
        3. How MDC Tables Work
        4. Picking a Dimension for an MDC Table
        5. Summary
      2. Declared Global Temporary Tables
        1. Index Support for DGTTs
        2. Minimal Undo Logging to Support the Rollback of Data Changes to DGTTs
        3. Statistics Support on DGTTs
      3. System Default Value and NULL Compression
        1. How Data Compression Works in DB2 UDB
        2. Compression Example
        3. Supported Data Types for Compression
        4. How Do I Know if Compression Is Turned On?
        5. Estimating Compression Savings
      4. Informational Constraints
        1. Why Informational Constraints?
        2. Using Informational Constraints
      5. Connection Concentrator
        1. Connection Management Improvements
        2. Activating the Connection Concentrator
        3. Connection Concentrator Operation
      6. User-Maintained Materialized Query Tables
        1. Restrictions
        2. Creating Materialized Query Tables
        3. Populating Materialized Query Tables
        4. Leveraging Materialized Query Tables for Improved Query Performance
      7. Database System Monitoring Enhancements
        1. Preventing the Collection of Timestamps
        2. Enhanced Deadlock Monitoring
        3. SQL Access to Event Monitor Data
        4. SQL Access to Snapshot Monitor Data
        5. DB2_SNAPSHOT_NOAUTH Registry Variable
        6. Performance Monitor Control Center Tool Has Been Deprecated
      8. Miscellaneous Performance Enhancements
        1. Distributed Catalog Cache
        2. Prefetching Enhancements with Block-Based Buffer Pools
        3. Page Cleaner I/O Improvements
        4. Multithreading of Java-Based Routines
        5. 64-Bit Support
        6. Automatic Relationship and Association Management (ARAM)
        7. New Join Variations
        8. Increased Opportunity for Selection of Bit-Filters
    7. Manageability
      1. Logging
        1. Transactional Logging Improvements
        2. Diagnostic Logging Improvements
      2. Load Enhancements
        1. Online Load
        2. Locking Behavior
        3. New Table States
        4. Loading Data into Partitioned Databases
        5. Loading Data from a Cursor
        6. Load Wizard
      3. DB2 Tools
        1. Configuration Assistant
        2. Health Center
        3. Memory Visualizer
        4. Storage Management
        5. Indoubt Transaction Manager
        6. Fault Monitor
      4. Container Operations
        1. Table Space Maps
        2. Dropping Containers from a DMS Table Space
        3. Reducing the Size of Containers in a DMS Table Space
        4. Adding Containers to a DMS Table Space without Rebalancing
      5. Dynamic Memory Allocation and Online Reconfiguration
      6. Online Utilities
        1. Online Reorganization
        2. Online Database Inspection Tool
        3. Incremental Maintenance of Materialized Query Tables
      7. Miscellaneous Manageability Enhancements
        1. Throttling Utilities
        2. New Administration Notification LOG
        3. Table Space Change History File
        4. QUIESCE Command
        5. RUNSTATS Command Enhancements
        6. Point-in-Time Rollforward Recovery to Local Time
        7. XBSA Support
        8. Data Movement Enhancements for Original Equipment Manufacturer Databases
        9. Trace Facility Enhancements
        10. Multiple Service Level Install for UNIX
        11. New Tivoli-focused Options
        12. LDAP Support on Linux
        13. Dynamic LPAR Support for AIX5.2B
        14. Dynamic System Domain Support
        15. Transaction Log Space Usage
        16. ALTER TABLE VARGRAPHIC
        17. Command History Support and CLP Roundtrip Editing
    8. Development
      1. SQL Enhancements
        1. SQL Insert through UNION ALL
        2. Using Table Spaces with UNION ALL
        3. INSTEAD OF Triggers
        4. ORDER BY Enhancements
        5. FETCH FIRST
        6. SQL Functions
        7. Identity Column Support
        8. CALL Statement
        9. MERGE SQL
        10. SQL Sampling
        11. Summary
      2. Application Development Enhancements
        1. Development Center
        2. Debugging Java and SQL PL
        3. SQL Assist
        4. Java Enhancements
        5. Package Version Identifiers
        6. Flush Package Cache
        7. Summary
      3. DB2 in the Microsoft Environment
        1. Windows 2003 Support
        2. DB2 Development Add-Ins for Visual Studio .NET
        3. Native Managed .NET Providers
        4. DB2 Database Project for Visual Studio .NET
        5. Loosely Coupled Transaction Support
        6. Windows Management Instrumentation (WMI)
        7. OLE DB Provider
        8. Summary
    9. Information Integration
      1. Federated Systems
        1. DB2 Information Integrator
        2. Federated Systems Enhancements
        3. WebSphere MQ Integration Enhancements
      2. Web Services
        1. DB2 as a Web Services Consumer
        2. DB2 as a Web Service Provider
        3. DB2 Web Tools and the Application Server for DB2
        4. XML Enhancements
      3. Replication Enhancements
        1. Replication Center
        2. Replication Monitoring
        3. General Enhancements
        4. Capture Enhancements
        5. Apply Enhancements
        6. Replication Performance
      4. CD-ROM Installation
        1. DB2 Installation
        2. Documentation
        3. DB2DEMO
      5. Article
      6. About the CD-ROM
        1. License Agreement
        2. Technical Support

    Product information

    • Title: DB2® Version 8: The Official Guide
    • Author(s): Paul C. Zikopoulos, Roman B. Melnyk, George Baklarz, Dirk Deroos
    • Release date: September 2003
    • Publisher(s): IBM Press
    • ISBN: 9780131401587