DB2 Everyplace Enterprise Edition Release Notes for Version 9.1

Welcome to the DB2® Everyplace® Version 9.1 Release Notes.

This document contains the enhancements that are addressed by DB2 Everyplace version 9 release 1 (hereafter referred to as DB2 Everyplace V9.1).

New features for the DB2 Everyplace database

  • Support for JDBC 3.0 Savepoint

    An application can set, release, or roll back a transaction to designated savepoints.

  • Support for Microsoft® .NET Compact Framework 2.0
  • Support for 128-byte identifiers

    The maximum length of table names, column names and index names has been extended from 18 bytes to 128 bytes.

  • Support for unique index
  • Support for the following new data types: CHAR FOR BIT DATA and VARCHAR FOR BIT DATA

    You can store fixed-length byte strings by using CHAR FOR BIT DATA type. VARCHAR FOR BIT DATA type allows you to store variable-length binary strings.

New features for the DB2 Everyplace Sync Server

  • Automatic replication statistics collection

    The DB2 Everyplace Sync Server will automatically collect replication statistics in order to provide additional information to manage the replication performance and frequencies.

  • Source schema consistency checking command

    You can use the command dsycheck to check DB2 Everyplace Sync Server for inconsistencies between source databases and mirror databases. For more information, see command-line scripts for the DB2 Everyplace Sync Server.

Support for IPv6

  • DB2 Everyplace Enterprise Edition V9.1 supports IPv6 (Internet Protocol Version 6), the next generation Internet protocol. For more information, see DB2 Everyplace IPv6 support.

Changes in DB2 Everyplace backend database support

  • DB2 Everyplace Enterprise Edition V9.1 does not support Cloudscape™, Sybase and Lotus® Domino® as backend databases.

Known considerations and restrictions

This section contains known defects in this release of DB2 Everyplace. It also provides information on any fix or workaround that exists for these limitations and issues.

  • For the DB2 Everyplace Sync Client: The IUpgrade application for Symbian mobile devices is available only in German, English, Spanish, French, and Italian.
  • For the DB2 Everyplace Sync Server: On Windows®, after you refresh an item in the left panel of MDAC, three dots "..." might display as part of the item name. For example, Users might change to Users... or .... Try to refresh the item again.
  • For the documentation: If the Sync Server Help page is started in an Internet Explorer browser under Windows XP, the browser displays the following warning: "To help protect your security, Internet Explorer has restricted this file from showing active content that could access your computer. Click here for options...". Click the warning message to display the content.

Trademarks

The following terms are trademarks of the International Business Machines Corporation in the United States, or other countries, or both.

Cloudscape
DB2
Domino
Everyplace
IBM
Lotus

Linux® is a registered trademark of Linus Torvalds in the United States, other countries, or both.

Microsoft, Windows, Windows NT®, and the Windows logo are registered trademarks of Microsoft Corporation in the United States, other countries, or both.

Other company, product, or service names may be trademarks or service marks of others.