DB2 UDB V8.2 on the Windows Environment

DB2 UDB V8.2 on the Windows Environment

by Whei-Jen Chen, Ajit Mungale, Carlos Raymundo, Andreas Thuering
Released October 2004
Publisher(s): IBM Redbooks
ISBN: None

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 Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This IBM Redbooks publication is an update of DB2 UDB Exploitation of the Windows Environment (SG24-6893), with a focus on DB2 UDB Version 8.2 functions and features.

We illustrate, step-by-step, the installation and migration processes. The new autonomic computing technology that makes the DBA’s job easier is described in detail. The new security features and their integration with the Windows environment are discussed intensively.

This book covers the new performance and monitoring enhancements of Version 8.2. New, exciting high availability functions are described in detail.

Further, we discuss aspects of DB2 application development with .NET 2003 and Java and provide programming details using ADO.NET, CLR, and Java.

Table of contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
      1. Acknowledgements
    2. Become a published author
    3. Comments welcome
  3. Chapter 1: Introduction
    1. DB2 UDB overview
      1. DB2 technology strategy priorities
      2. DB2 family (1/2)
      3. DB2 family (2/2)
      4. DB2 UDB products for Windows
    2. DB2 UDB V8.2 technology highlights
      1. SQL enhancements
      2. Security enhancements
      3. Business intelligence enhancements
      4. Autonomic computing enhancements
      5. Usability enhancements
      6. High availability enhancements
    3. DB2 UDB V8.2 integration with Windows
      1. System security
      2. Application development
  4. Chapter 2: Installation and migration
    1. DB2 UDB V8.2 installation
      1. Installation overview for DB2 on Windows
      2. DB2 UDB V8.2 server installation
      3. DB2 UDB V8.2 client installation
    2. Migration
      1. Migrating DB2 between versions of Windows (1/2)
      2. Migrating DB2 between versions of Windows (2/2)
      3. Migrating between versions of DB2 UDB
      4. Migrating from 32-bit to 64-bit
      5. Migrating everything at once
  5. Chapter 3: Administration and management
    1. Backup, recovery, and logging
      1. Automatic backup
      2. Self-tuning backup and restore
      3. Backup compression
      4. Logs in backup images
    2. Automated log file management
    3. RECOVER command
    4. Automated table maintenance
      1. Automatic statistics collection
      2. Automatic statistics profiling
      3. Automatic reorganization (1/2)
      4. Automatic reorganization (2/2)
    5. Integrated Design Advisor (1/7)
    6. Integrated Design Advisor (2/7)
    7. Integrated Design Advisor (3/7)
    8. Integrated Design Advisor (4/7)
    9. Integrated Design Advisor (5/7)
    10. Integrated Design Advisor (6/7)
    11. Integrated Design Advisor (7/7)
  6. Chapter 4: Security
    1. Windows Domain handling and user IDs
      1. Improved Windows Domain and Active Directory support
      2. User ID and group name enhancements
    2. Running DB2 under the local system account
    3. Protecting DB2 UDB system files
    4. Using DB2 with data encryption
    5. The new DB2 security exit
      1. DB2 authentication before Version 8.2
      2. The new DB2 authentication model in Version 8.2
      3. DB2 security plug-ins (1/2)
      4. DB2 security plug-ins (2/2)
      5. Developing security plug-ins
      6. Deploying a userid/password plug-in
      7. Deploying a group retrieval plug-in
      8. Deploying a GSS-API plug-in
      9. Error handling
  7. Chapter 5: Performance and monitoring
    1. SQL query optimization enhancements
      1. Native SQL procedures
      2. SQL statement size limit increased to 2 MB
      3. Data sampling in SQL queries
      4. Dynamic SQL re-optimization
      5. Specifying a lock wait mode strategy
      6. Improved query execution plans
      7. Multipage file allocation on SMS table spaces
      8. Automatic setting of table space prefetch size
    2. Multidimension clustering tables
      1. MDC performance recommendations
    3. Improvement of the RUNSTATS utility
      1. Improved RUNSTATS performance through sampling
      2. Throttling of the RUNSTATS utility
    4. DB2 performance elements in Windows
    5. DB2 Activity Monitor (1/3)
    6. DB2 Activity Monitor (2/3)
    7. DB2 Activity Monitor (3/3)
  8. Chapter 6: High availability
    1. High Available Disaster Recovery (1/5)
    2. High Available Disaster Recovery (2/5)
    3. High Available Disaster Recovery (3/5)
    4. High Available Disaster Recovery (4/5)
    5. High Available Disaster Recovery (5/5)
    6. Automatic client reroute
    7. Index logging
  9. Head : - Chapter 7. Using DB2 with Java
    1. Head 1 - 7.1 Java Database Connectivity (JDBC)
      1. Head 3 - 7.1.1 Types of JDBC driver:
      2. Head 3 - 7.1.2 Writing a JDBC application (1/2)
      3. Head 3 - 7.1.2 Writing a JDBC application (2/2)
    2. Head 2 - 7.2 SQL Java (SQLJ)
      1. Head 3 - 7.2.1 Writing SQLJ applications
  10. Chapter 8: Using DB2 with .NET framework
    1. An overview of ADO.NET
    2. ADO.NET architecture
      1. Connection
      2. Command
      3. DataReader
      4. DataAdapter
      5. DataSet
    3. Connecting to the database
    4. Data providers for DB2
      1. OLE DB .NET Data Provider
      2. ODBC .NET Data Provider
      3. DB2 .NET Data Provider
      4. Comparison between providers
    5. Performing operations on a DB2 database
      1. Using DataAdapter and DataSet (Disconnected model)
      2. Calling stored procedures
      3. Controlling transaction
      4. Using large objects (LOBs)
      5. Binding Data Controls with ADO.NET (1/2)
      6. Binding Data Controls with ADO.NET (2/2)
      7. Accessing DB2 with Web Forms
    6. Add-ins and stored procedures in CLR
      1. IBM DB2 Development Add-In overview
      2. DB2 Toolbar
      3. DB2 Database Project type
      4. Data Connections folder in the IBM Explorer
      5. DB2 SQL Editor
    7. Developing DB2 stored procedures in .NET
      1. Save and build the solution (1/2)
      2. Save and build the solution (2/2)
  11. Chapter 9: Consuming DB2 Web services in .NET
    1. Web services and DB2
    2. Web Services Object Runtime Framework (WORF)
      1. Document access definition extension (DADX)
      2. DB2 XML Extender
      3. How WORF processes a Web service request
      4. Setting up a WORF environment for Windows
      5. Creating and deploying DB2 WORF service (1/2)
      6. Creating and deploying DB2 WORF service (2/2)
    3. Consuming the DADX Web service using .NET client
  12. Chapter 10: Problem resolution
    1. RAS
    2. PD/PSI
    3. Information to collect
    4. db2support utility
    5. Understanding DB2DIAG.LOG
    6. DB2DIAG tool
    7. Prevention versus resolution (1/2)
    8. Prevention versus resolution (2/2)
  13. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  14. Index (1/3)
  15. Index (2/3)
  16. Index (3/3)
  17. Back cover

Product information

  • Title: DB2 UDB V8.2 on the Windows Environment
  • Author(s): Whei-Jen Chen, Ajit Mungale, Carlos Raymundo, Andreas Thuering
  • Release date: October 2004
  • Publisher(s): IBM Redbooks
  • ISBN: None