DB2 UDB V8.2 on the Windows environment / [Whei-Jen Chen ... et al.].

Format:

Book

Contributor:

Chen, Whei-Jen.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Microsoft Windows (Computer file).

Physical Description:

xii, 344 p. : ill.

Edition:

1st ed.

Other Title:

Database Two Universal Database version 8.2 on the Windows environment

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, 2004.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Front cover

Contents

Notices

Trademarks

Preface

The team that wrote this redbook

Acknowledgements

Become a published author

Comments welcome

Chapter 1. Introduction

1.1 DB2 UDB overview

1.1.1 DB2 technology strategy priorities

1.1.2 DB2 family

1.1.3 DB2 UDB products for Windows

1.2 DB2 UDB V8.2 technology highlights

1.2.1 SQL enhancements

1.2.2 Security enhancements

1.2.3 Business intelligence enhancements

1.2.4 Autonomic computing enhancements

1.2.5 Usability enhancements

1.2.6 High availability enhancements

1.3 DB2 UDB V8.2 integration with Windows

1.3.1 System security

1.3.2 Application development

Chapter 2. Installation and migration

2.1 DB2 UDB V8.2 installation

2.1.1 Installation overview for DB2 on Windows

2.1.2 DB2 UDB V8.2 server installation

2.1.3 DB2 UDB V8.2 client installation

2.2 Migration

2.2.1 Migrating DB2 between versions of Windows

2.2.2 Migrating between versions of DB2 UDB

2.2.3 Migrating from 32-bit to 64-bit

2.2.4 Migrating everything at once

Chapter 3. Administration and management

3.1 Backup, recovery, and logging

3.1.1 Automatic backup

3.1.2 Self-tuning backup and restore

3.1.3 Backup compression

3.1.4 Logs in backup images

3.2 Automated log file management

3.3 RECOVER command

3.4 Automated table maintenance

3.4.1 Automatic statistics collection

3.4.2 Automatic statistics profiling

3.4.3 Automatic reorganization

3.5 Integrated Design Advisor

Chapter 4. Security

4.1 Windows Domain handling and user IDs

4.1.1 Improved Windows Domain and Active Directory support

4.1.2 User ID and group name enhancements

4.2 Running DB2 under the local system account

4.3 Protecting DB2 UDB system files

4.4 Using DB2 with data encryption

4.5 The new DB2 security exit.

4.5.1 DB2 authentication before Version 8.2

4.5.2 The new DB2 authentication model in Version 8.2

4.5.3 DB2 security plug-ins

4.5.4 Developing security plug-ins

4.5.5 Deploying a userid/password plug-in

4.5.6 Deploying a group retrieval plug-in

4.5.7 Deploying a GSS-API plug-in

4.5.8 Error handling

Chapter 5. Performance and monitoring

5.1 SQL query optimization enhancements

5.1.1 Native SQL procedures

5.1.2 SQL statement size limit increased to 2 MB

5.1.3 Data sampling in SQL queries

5.1.4 Dynamic SQL re-optimization

5.1.5 Specifying a lock wait mode strategy

5.1.6 Improved query execution plans

5.1.7 Multipage file allocation on SMS table spaces

5.1.8 Automatic setting of table space prefetch size

5.2 Multidimension clustering tables

5.2.1 MDC performance recommendations

5.3 Improvement of the RUNSTATS utility

5.3.1 Improved RUNSTATS performance through sampling

5.3.2 Throttling of the RUNSTATS utility

5.4 DB2 performance elements in Windows

5.5 DB2 Activity Monitor

Chapter 6. High availability

6.1 High Available Disaster Recovery

6.2 Automatic client reroute

6.3 Index logging

Head 0 - Chapter 7. Using DB2 with Java

Head 1 - 7.1 Java Database Connectivity (JDBC)

Head 3 - 7.1.1 Types of JDBC driver:

Head 3 - 7.1.2 Writing a JDBC application

Head 2 - 7.2 SQL Java (SQLJ)

Head 3 - 7.2.1 Writing SQLJ applications

Chapter 8. Using DB2 with .NET framework

8.1 An overview of ADO.NET

8.2 ADO.NET architecture

8.2.1 Connection

8.2.2 Command

8.2.3 DataReader

8.2.4 DataAdapter

8.2.5 DataSet

8.3 Connecting to the database

8.4 Data providers for DB2

8.4.1 OLE DB .NET Data Provider

8.4.2 ODBC .NET Data Provider

8.4.3 DB2 .NET Data Provider

8.4.4 Comparison between providers

8.5 Performing operations on a DB2 database.

8.5.1 Using DataAdapter and DataSet (Disconnected model)

8.5.2 Calling stored procedures

8.5.3 Controlling transaction

8.5.4 Using large objects (LOBs)

8.5.5 Binding Data Controls with ADO.NET

8.5.6 Accessing DB2 with Web Forms

8.6 Add-ins and stored procedures in CLR

8.6.1 IBM DB2 Development Add-In overview

8.6.2 DB2 Toolbar

8.6.3 DB2 Database Project type

8.6.4 Data Connections folder in the IBM Explorer

8.6.5 DB2 SQL Editor

8.7 Developing DB2 stored procedures in .NET

8.7.1 Save and build the solution

Chapter 9. Consuming DB2 Web services in .NET

9.1 Web services and DB2

9.2 Web Services Object Runtime Framework (WORF)

9.2.1 Document access definition extension (DADX)

9.2.2 DB2 XML Extender

9.2.3 How WORF processes a Web service request

9.2.4 Setting up a WORF environment for Windows

9.2.5 Creating and deploying DB2 WORF service

9.3 Consuming the DADX Web service using .NET client

Chapter 10. Problem resolution

10.1 RAS

10.2 PD/PSI

10.3 Information to collect

10.4 db2support utility

10.5 Understanding DB2DIAG.LOG

10.6 DB2DIAG tool

10.7 Prevention versus resolution

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"October 2004."

"SG24-7102-00."

Includes bibliographical references and index.

OCLC:

137342257