IBM Books

What's New

IBM DB2 Universal Database
What's New

Version 5


Before using this information and the product it supports, be sure to read the general information under Appendix A. "Notices".

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.


Table of Contents

Parallel Features

  • DB2 Version 5 Parallel Features
  • Symmetric Multi-Processor (SMP) Enhancements
  • Usability Enhancements

  • Graphical Tools
  • Connectivity and Protocol Configuration and Auto-Discovery
  • Instance Profile Manager
  • Licensing
  • SQL Enhancements

  • Outer Join Support
  • Additional Authorization Support
  • REAL Data Type Support
  • New CREATE SCHEMA and DROP SCHEMA Statements
  • User-defined Table Functions Supported
  • Unique Constraints Supported
  • CUBE and ROLLUP Aggregations
  • New RENAME TABLE Statement
  • Friendly Arithmetic and Conversion
  • Built-in Functions
  • 500 Table Columns
  • Application Development Enhancements

  • Open Database Connectivity (ODBC) 3.0 Support
  • Additional Support in the DB2 Precompiler and APIs
  • User Defined Function (UDF) Enhancements
  • Precompile and Bind Enhancements
  • Support for Java Programming
  • Performance, Capacity, and Memory Enhancements

  • Index ANDing
  • Star Joins
  • Global SQL Cache
  • Faster Restart
  • Multiple Buffer Pools, Very Large Memory Support
  • LOAD Improvements
  • More Efficient Client/Server Communications
  • Deferred Prepare
  • DRDA Enhancements

  • DRDA Using the TCP/IP Communications Protocol
  • DRDA Two-phase Commit
  • DRDA Multi-row Stored Procedures
  • Communications Enhancements

  • Named Pipe Support in Windows
  • Other Enhancements

  • LOAD and Import
  • DCE Security
  • DB2 Governor
  • Table Space Recovery To a Point in Time
  • Restore Subset of Table Spaces from Backup
  • Query Table Space Enhancements
  • Database and Directory Migration
  • Authentication Enhancement
  • FORCE Command
  • Serviceability Enhancements

  • DB2 Database Repair Tool
  • DB2 Messages Improvements
  • Appendix A. Notices

  • Trademarks
  • Trademarks of Other Companies
  • Appendix B. Contacting IBM



    [ Top of Page | Next Page ]

    [ DB2 List of Books | Search the DB2 Books ]