What's New

Contents

Contents

Preface

Who Should Read This Book
How This Book Is Structured
DB2 Version 7.2 Enhancements

Chapter 1. Introducing Version 7

Ease of Use
Launchpads
First Steps
Quick Tour
Information Center
Wizard Enhancements
Information Feedback
New Products and Packages
DB2 Warehouse Manager
QMF for Windows
DB2 Query Patroller
DB2 Relational Connect
Workgroup Edition on UNIX
DB2 OLAP Starter Kit
DB2 Spatial Extender
DB2 Universal Database Text Information Extender
DB2 Net Search Extender
Application Development Client
DB2 Life Sciences Data Connect
Migration to Version 7
Migrating from Visual Warehouse Version 3.1 or Version 5.2

Chapter 2. e-business Enhancements

XML Extender Support
Web Services
Net.Data Enhancements
Stored Procedures
Stored Procedure Builder
MQSeries Integration
MQSeries Assist Wizard
OLE DB Assist Wizard
Nested Stored Procedure Support
SQL Procedure Language
Visual Basic Stored Procedures
Calling Stored Procedures
Stored Procedure Samples
Java Stored Procedure Class Loader
DB2 Universal Database on Linux
DB2 Universal Database Enterprise Edition for Linux on S/390
DB2 Universal Database Enterprise - Extended Edition on Linux
JDBC 2.0 for Linux and HP-UX
Raw I/O for DB2 Universal Database for Linux 2.4

Chapter 3. Business Intelligence Enhancements

Data Warehouse Center
Star Schema Builder
Process Modeler
Enhanced Support for Creating and Changing Warehouse Target Tables
Name and Address Cleansing Support
Mandatory Fields
OLAP Capability
OLAP Starter Kit
Relational OLAP Capabilities
Business Intelligence Tutorial
e-Video Central Tutorial
New Warehouse Sources
DB2 Warehouse Manager Connector for i2 TradeMatrix BPI
DB2 Warehouse Manager Connector for SAP R/3
DB2 Warehouse Manager Connector for the Web
MQSeries Message Queues
Microsoft OLE DB and Data Transaction Services Support
Metadata Interchange
Common Warehouse Metamodel Support
IBM ERwin Metadata Extract Program
Interim Commits when Importing Warehouse Metadata
Additional Metadata Templates
Heterogeneous Distributed Query
Access to New Database Management Systems
New Support for Accessing Heterogeneous Data from SQL Procedures
Query Patroller
QMF
Global Snapshot
Convert ODBC (Dynamic SQL) to Static SQL
Temporary Table Support
Object Relational Features
Structured Types
Transform Functions
SQL-Bodied Functions
Dynamic Compound Statements
Variables and Control Flow in Triggers and SQL Functions
Typed Tables
User-Defined Extended Index Types
Replication
Data Links
Capture and Apply
Data Link Replication Support on the Solaris Operating Environment
Updateable Partitioning Keys
Additional Enhancements

Chapter 4. Data Management Enhancements

DB2 Data Links Manager
Native OLE DB Support
SQL Assist
Closing Log After Backup
On Demand Log Archiving
Identity Column Support
Larger Index Key
Externalized Savepoint Support
Increased Log Limit to 32GB
Block Transactions When Log Directory Is Full
Rename a Table Space
Database Buffer Pool
Windows 2000 Address Windowing Extensions (AWE)
64-Bit Support on AIX, HP-UX, and the Solaris Operating Environment
Increased Locklist Limit
Unicode Enhancements
Encrypting and Decrypting String Data
Database Recovery
Suspended I/O
Dual Logging
Parallel Recovery
Backup from Split Image
Named Pipe Support for Backup and Restore Operations
Incremental and Delta Backups
Sequence Support
Statement-Level Isolation Levels
New SQL Built-in Scalar Functions
Parallel Container Creation

Chapter 5. DB2 Family Enhancements

Mobile Computing
DB2 Everyplace
>8 Character UserID Support
Pre-Version 7 Servers
Replication
DB2 Universal Database for OS/390
DB2 Universal Database for AS/400
Import and Export
Stored Procedures
LOAD Authority
USE OF TABLESPACE Authority
BIND Options
OS/390 in the Control Center
Generate DDL
OS/390 Utilities
Windows 32-bit Operating Systems
Windows 2000
Visual C++ Application Development
Visual Studio Integration
Administering DB2 UDB Workgroup Edition and DB2 UDB Personal Edition as Satellites
Running Compiled SQL Procedures
Cross-Platform Backup and Restore
DB2 Data Links Manager for the Solaris Operating Environment
TSM Integration with DB2 Data Links Manager

Chapter 6. DB2 Connect Enhancements

DB2 Connect Managed Access
Improved Support for Microsoft Transaction Server (MTS) and COM+ Technologies
Multisite Update Improvements
DB2 Connect Web Starter Kit
DB2 Connect for Linux
Support DCL SNA Product

Appendix A. Using the DB2 Library

DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online

Appendix B. Notices

Trademarks

Index

Contacting IBM

Product Information