Release Notes - DB2 Everyplace Version 7.2.1

This Release Notes file provides information about DB2 Everyplace Version 7.2.1
The latest Release Notes information can be found online at the DB2 Everyplace Web site.
Always use the latest version of Release Notes.

For installation instructions, please view the Installation Notes.

Contents

CD Structure and languages

DB2 Everyplace for Windows operating system CD:

DB2 Everyplace for Unix platform CD:

Unix platforms supported:

Language codes are as follows:
  ar       Arabic
  cs_CZ    Czech
  de_DE    German
  en_US    US English
  es_ES    Spanish
  fr_FR    French (standard)
  it_IT    Italian
  iw_IL    Hebrew
  ja_JP    Japanese
  ko_KR    Korean
  zh_CN    Simplified Chinese
  zh_TW    Traditional Chinese

Publications available

Publications are available from the DB2 Everyplace Web site.

The DB2 Everyplace Installation and User's Guide is available in HTML and PDF format in the following languages:
        o Czech
        o English
        o Korean
        o Simplified Chinese
        o Traditional Chinese
        o Spanish
        o Japanese

The DB2 Everyplace Application Development Guide is available in HTML and PDF format in the following languages:
        o English
        o Korean
        o Simplified Chinese
        o Spanish
        o Japanese

The DB2 Everyplace Sync Server Administration Guide is available in HTML and PDF format in the following languages:
        o English
        o German
        o Japanese
        o Korean
        o Simplified Chinese

The online help within the Mobile Devices Administration Center (MDAC) is available in the national language that you select during installation. English is provided with Arabic, Hebrew, and Czech versions.


Configuring Sync Server for use with IBM WebSphere Application Server (WAS)

This section describes how to set up the DB2 Everyplace Sync Server to use an existing IBM WebSphere Application Server after you have installed Sync Server. It covers the following topics:

Configuring Sync Server for use with WAS 3.5.4 Standard and Advanced Edition

To configure Sync Server to use with WAS 3.5.4:

  1. Install DB2 Everyplace.
  2. Create a DB2 Everyplace instance (UNIX only).
  3. Start the IBM HTTP server.
  4. Start the Adminstration Server for WAS 3.5.4. When you start the WAS Administration Server, you must log in as a DB2 administrator on a Windows NT or Windows 2000 operating system, or as root user on the UNIX operating system. The WAS Administration Server must use the default port number 900 now, but you can change the server to use another port at a later time.
  5. Create an application server under your WebSphere node. An application server with the name IBM DB2 Everyplace is created.

Changing the transport port to resolve port conflict in WAS 3.5.4

The installation script creates an application server for IBM DB2 Everyplace that uses 8999 for the transport port. If another application in WAS has used the same port, a conflict occurs. You can change the transport port in two ways. Method 1 requires you to change an XML script and execute the installation script again. With method 2, you use the WAS Admin Console.

Method 1
  1. In a text editor, open the following file:
  2. Locate the following line:
    <transport-port>8999</transport-port>
  3. Replace 8999 with a free port number you want to use (for example, 9003) and save the file.
  4. Repeat step 5 described above in "Configuring Sync Server for use in IBM WebSphere Application Server (WAS)."
Method 2
  1. Launch the WAS Admin Console.
  2. Change to the topolgy view.
  3. On the left pane, click WebSphere Administrative Domain -> your_node -> IBM_DB2_Everyplace -> DB2e_ServletEngine. Your_node is the node under which you have installed Sync Server.
  4. On the right pane, click the Advanced tab.
  5. In the port field, specify a free port (for example, 9003).

Configuring Sync Server to use with WAS 4.0 Advanced Edition

This section describes how to configure Sync Server to use with WAS 4.0 Advanced Edition. WAS 4.0 Advanced Single Server Edition is not supported.

To configure Sync Server to use with WAS 4.0 Advanced Edition:

  1. Install DB2 Everyplace.
  2. Create a DB2 Everyplace instance. (UNIX only).
  3. Configure WAS to use JDBC 2.0 (Windows NT or Windows 2000 only).
    1. Open a Command Prompt window.
    2. Change the directory to %DSYSQLLIBINSTDIR%\java12.
    3. Run usejdbc2.bat
  4. Start IBM HTTP Server.
  5. Start the Adminstration Server for WAS 4.0. When you start the Administration Server, you must log in as a DB2 administrator on a Windows NT or Windows 2000 operating system, or as root user on the UNIX operating system. The administration server must use the default port number 900 now, but you can change the server to use another port at a later time.
  6. Create an application server under your WebSphere node. If during the execution of the script, an error message that indicates a duplicate port has been used appeared, follow the instructiions in "Resolving transport port conflict in WAS 4.0" below and then continue from here.
  7. Run the DB2 Everyplace installation wizard.
    1. Launch WAS Administration Console.
    2. On the left pane, expand the object tree until you see Enterprise Applications.
    3. Right-click Enterprise Application and select Install Enterprise Application. The Install Enterprise Application wizard starts.
    4. Make sure Install Application is selected on the Specify the Application or Module page.
    5. In the path field under Install Application, type:
      • For Windows NT or Windows 2000, %DSYINSTDIR%\WebSphere\ext-was-cfg\40\common\IBM_DB2_Everyplace.ear.
      • For UNIX, $DSYINSTDIR/install/ext-was-cfg/40/common/IBM_DB2_Everyplace.ear.
      Alternatively, you can click Browse to locate the file.
    6. Click Next on all the pages that follow until you reach the page titled "Selecting Application Servers."
    7. On the Selecting Application Servers page, click Select Server. The Select a Server or Server Group window opens.
    8. Select IBM DB2 Everyplace from the Application Server list and then click OK.
    9. Click Next.
    10. Click Finish to complete the installation wizard.
  8. On the left pane of the WAS Administration Console, right-click the node under which you have installed DB2 Everyplace and select Regen Webserver Plugin. This makes all the change effective.

Changing the transport port to resolve port conflicts in WAS 4.0

The installation script creates an application server for IBM DB2 Everyplace that uses 8999 for the transport port. If another application in WAS has used the same port, a conflict happens. You can change the transport port by using the WAS Administration Console.

To change the transport port:

  1. Start the WAS Administration Console.
  2. On the left pane, click WebSphere Administration Domain -> Nodes -> Application Servers -> IBM DB2 Everyplace Server..
  3. On the right pane, click Services.
  4. Select Web Container Service from the Services list and then click Edit Properties.
  5. Specify a free port in the Transport port field and click OK.


Notes about DB2 Everyplace database

Developing DB2 Everyplace applications in a multitasking environment

The DB2 Everyplace database engine does not support multiple database connections. Multiple read-only statement handles may be used. INSERT, UPDATE, DELETE, CREATE, or DROP operations must be serialized to ensure data integrity. Multithreaded operations must be serialized to ensure data integrity.

Information about Neutrino client Versions

DB2 Everyplace Database supports Neutrino Version 6.0 and Version 6.1. The documentation refers to Neutrino client package as DB2EveryplaceNTO.tar.gz. The file names should be changed to DB2EveryplaceNTO60.tar.gz and DB2EverylaceNTO61.tar.gz respectively.

Known Problems and considerations - DB2 Everyplace database


Notes about the DB2 Everyplace Sync Server

JDBC subscriptions from a pre-7.2 beta release

Any non-Put JDBC subscriptions created using a version earlier than V7.2 must be deleted using the Mobile Devices Administration Center before you install the new version.

Information about Neutrino client Versions

DB2 Everyplace Sync Server supports Neutrino Version 6.0 and Version 6.1. The documentation refers to Neutrino client package as ISyncNTO.tar.gz. The file names should be changed to ISyncNTO60.tar.gz and ISyncNTO61.tar.gz respectively.

Mirror table log space

During replication, mirror tables are updated with information from the master table. Ensure that there is sufficient log space allocated on the mirror database to accomodate these updates. If synchonization fails with the message "DProprException: DataPropagator Process did not complete successfully (RC = -1)", or the sqlcode "SQL0964C The transaction log for the database is full" appears in the DataPropagator trace files, increase the log file space by using the following commands on the DB2 command line:

     db2 update db cfg for MIRROR_DATABASE using logfilsiz N
     (where N is higher than the current setting of logfilsiz)

       OR

     db2 update db cfg for MIRROR_DATABASE using logprimary N
     (where N is higher than the current setting of logprimary)

       OR

     db2 update db cfg for MIRROR_DATABASE using logsecond N
     (where N is higher than the current setting of logsecond)

Remote and DBCS data sources and primary key

When creating a table subscription using a remote data source or a DBCS data source, the primary key is not automatically assigned. Data sources used in a table subscription must have a primary key. The primary key can contain multiple columns. Use the Advanced button in the Define Subscription dialog to select the primary key(s).

For JDBC drivers

You can set the JDBC driver you want to use with Sync Server by modifying the Sync Server path in the DSYINSTDIR environment variable. To modify the variable:

Known Problems and considerations - DB2 Everyplace Sync Server


HATs and FAQs - DB2Everyplace Sync Server


Terms and conditions

Use of DB2 Everyplace is subject to the terms and conditions of the International Program License Agreement. Other non-IBM code provided with DB2 Everyplace is provided for the customer's convenience. The DB2 Everyplace warrantees do not apply to such code.

Notices

IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:
IBM World Trade Asia Corporation
Licensing
2-31 Roppongi 3-chome, Minato-ku
Tokyo 106, Japan


The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact: IBM Canada Limited

Office of the Lab Director
1150 Eglinton Ave. East
North York, Ontario
M3C 1H7
CANADA

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

This information may contain examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.


Copyright license

This information may contain sample application programs in source language, which illustrates programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.

Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows:

(C) (your company name) (year). Portions of this code are derived from IBM
Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_.
All rights reserved.

This product includes software developed by 3Com and its contributors.

Copyright (c) 1998 3Com/Palm Computing Division. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

THIS SOFTWARE IS PROVIDED BY THE 3COM AND CONTRIBUTORS ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL 3COM OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Trademarks

The following terms, which may be denoted by an asterisk(*), are trademarks of International Business Machines Corporation in the United States, other countries, or both.
 ACF/VTAM                              IBM
 AISPO                                 IMS
 AIX                                   IMS/ESA
 AIX/6000                              LAN DistanceMVS
 AIXwindows                            MVS/ESA
 AnyNet                                MVS/XA
 APPN                                  Net.Data
 AS/400                                OS/2
 BookManager                           OS/390
 CICS                                  OS/400
 C Set++                               PowerPC
 C/370                                 QBIC
 DATABASE 2                            QMF
 DataHub                               RACF
 DataJoiner DataPropagator             RISC System/6000
 DataRefresher                         RS/6000
 DB2                                   S/370
 DB2 Connect                           SP
 DB2 Extenders                         SQL/DS
 DB2 OLAP Server                       SQL/400
 DB2 Universal Database                System/370
 Distributed Relational                System/390
 Database Architecture                 SystemView
 DRDA                                  VisualAge
 eNetwork                              VM/ESA
 Extended Services                     VSE/ESA
 FFST                                  VTAM
 First Failure Support Technology      WebExplorer
                                       WIN-OS/2



The following terms are trademarks or registered trademarks of other companies:
Microsoft, Windows, and Windows NT are trademarks or registered trademarks of Microsoft Corporation.

Java or all Java-based trademarks and logos, and Solaris are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

Tivoli and NetView are trademarks of Tivoli Systems Inc. in the United States, other countries, or both.

UNIX is a registered trademark in the United States, other countries or both and is licensed exclusively through X/Open Company Limited.

Other company, product, or service names, which may be denoted by a double asterisk(**) may be trademarks or service marks of others.