Release Notes - DB2 Everyplace Version 8.1.1

These Release Notes provides information about DB2 Everyplace Version 8.1.1. It contains updates that have not been added to the DB2 Everyplace Version 8.1 documentation. The DB2 Everyplace Version 8.1 documentation is included on the DB2 Everyplace Version 8.1.1 CD-ROM or with the evaluation code that you downloaded from the DB2 Everyplace Web site.

Contents

CD Structure and languages

DB2 Everyplace for Windows operating system CD: DB2 Everyplace for Unix platform CD: The DB2 Everyplace Release and install Notes are combined into one file and can be found in: Unix platforms supported:

Install notes, Migration, Creating an instance, and Adjusting operating system parameters for UNIX

Prerequisites

This section explains the hardware, software, and operating system requirements for DB2 Everyplace.

Hardware requirements

To use DB2 Everyplace, your system must meet the following hardware requirements:

Software requirements

To use DB2 Everyplace Sync Server, you must have the following software installed:

Operating system requirements

DB2 Everyplace runs on the following operating systems:

Preparation for migration before you install DB2 Everyplace Version 8.1.1

It is strongly recommended that all synchronization sessions are completed before upgrading an existing DB2 Everyplace installation to DB2 Everyplace Version 8.1.1 A device with an unfinished synchronization risks loosing some or all of the data it has collected since the last synchronization.

The following steps are intended to preserve data from synchronization sessions which have not completed prior to the upgrade of DB2 Everyplace to Version 8.1.1, and to let the synchronization session complete after the upgrade. We still strongly recommend that you do not rely on these steps but rather take all necessary precautions to complete all synchronization sessions prior to the upgrade installation.

To preserve the data of uncompleted synchronization sessions:

  1. Copy the DB2 Everyplace installation directory (RDbAdapterQM) and everything it includes into a temporary directory. RDbAdapterQM is a directory which contains synchronization information.
  2. Uninstall the previous version of DB2 Everyplace.
  3. Delete the directory structure for the previous version of DB2 Everyplace.
  4. Install DB2 Everyplace Version 8.1.1.
  5. Create the subdirectory, MESSAGES under %DSYINSTRDIR%\Server\.
  6. Copy the content of the temporary directory (that you created in Step 1) into the new MESSAGES directory located in %DSYINSTRDIR%\Server\MESSAGES.
  7. Start the newly installed Sync Server.

Installing DB2 Everyplace

To install DB2 Everyplace on a Windows or UNIX server:

  1. Run the setup program:

    If you installing from a CD-ROM:

    If you are installing from the DB2 Everyplace Web site:

    The next series of windows in the DB2 Everyplace Installer provides information about the Release Notes and License Agreement.

  2. Select the appropriate options and click Next.

    For Windows, if DB2 Universal Database is not currently installed on your workstation, an embedded copy with limited functionality will be installed. A new window opens:

    1. Enter a user ID and password for the DB2 Universal Database administrator.
    2. Click Next.
  3. Select the location where you want DB2 Everyplace installed and click Next.
  4. Select the check box next to the installation type that you want to install, and click Next. The installation types available include:
  5. Select the features that you want installed on DB2 Everyplace:

    The installation begins. The files for the selected setup type and features will be copied into the destination directory that was specified previously. The installation progress bar charts the progress of the installation.

    Once the installation is complete, proceed through the next series of windows which are described in step 6.

  6. Post installation configuration

    For Windows, follow the steps in this section for each installation type.

    Single Server

    1. After the installation of DB2 Everyplace is complete, an authentication window displays. Type the user ID and password that you created in Step 2 for the DB2 Everyplace Administrator and click Next.
    2. Type an unused port number. Click Next.
    3. Enter the user ID and password to create the sample database and subsciption when prompted and click Next.

    Multiple Server

    1. After the installation of DB2 Everyplace is complete, a window displays asking if you want the server (that you are installing DB2 Everyplace on) to be the server where the control database resides.
    2. Select the check box and click Next.
    3. Type a user ID and password for the DB2 Everyplace Administrator and click Next.
    4. Optional: To install the sample application, select Create the sample application check box. Click Next.

    Custom

    1. After the installation of DB2 Everyplace is complete, an authentication window displays. Type a user ID and password that you created for the DB2 Everyplace Administrator and click Next.
    2. Type an unused port number in the next window. Click Next
    3. Optional: To install the sample application, select Create the sample application check box. Click Next.

    For UNIX, the steps described in this section apply to all three installation types with one exception. In a multiple server installation, you do not need to specify a port number.

    1. After the installation of DB2 Eveyplace is complete, a window is displayed asking whether or not you want to create a DB2 Everyplace instance and create sample databases for that instance.
    2. Select the check box if you want to create a DB2 Everyplace instance and the check box if you want to create the sample database. Click Next.
    3. Enter the name of the DB2 Everyplace instance owner, DB2 Everyplace instance password and the instance locale (the name you enter has to be a valid DB2 instance and the locale a valid locale supported by DB2 Universal Database). Click Next.
    4. For custom and single server installation, Type the port number for the Sync Server in the next window. Click Next.
    5. For multiple server installation, you will be prompted if you want to create the control database for the DB2 Everyplace instance to be created. Select the check box and click Next.
  7. When the post installation configuration is complete, click Finish.

Creating DB2 Everyplace Instance on UNIX

If you did not create a DB2 Everyplace instance during installation or you would like to create additional instances outside of the installation process, use the dsyicreate command. Note: A DB2 Everyplace instance must be a DB2 Universal Database instance as well. Therefore, only userids which are DB2 Instance owners can host a DB2 Everyplace instance.

To create a DB2 Everyplace instance, use the dsyicreate.sh command located in the instance directory of the root installation directory (/opt/DB2Everyplace81 on Linux, and /usr/lpp/DBEveryplace81 on AIX and Solaris). Execute the dsyicreate.sh command as root user.

Adjusting operating system parameters for UNIX

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in segmentation errors on Solaris, and the inability to create a new connection to the database on Linux and AIX.

For Linux and Solaris, we recommend that the kernel parameters are adjusted. For AIX, the extended shared memeory segments should be enabled. This section provides the instructions for Linux, AIX, and SOlaris. Note: Only 32 bit DB2 Universal Database instances are supported.

Linux

For Linux systems running kernel 2.4 or higher, issue the following commands on the command line as the root user:

To execute the commands automatically, edit the file /etc/rc.d/rc.local, and place the above commands at the end of the file. On every subsequent system boot, the values will be set automatically. Additional setting recomendations can be found in the Linux 7.2 Release Notes for the FixPak you are running.

For each DB2 Universal Database instance running DB2 Everyplace, modifiy the login profile (most likely /home/<username>/.bashrc) to include the following if you are experiencing problems with java freezing early in the execution of java processes:

export LD_ASSUME_KERNEL_PATH=2.2.5

Exit the user shell, and login as the user to make the changes effective.

Solaris

For Solaris systems, the default system kernel parameters are insufficient to run DB2 Universal Database and DB2 Everyplace. These values can be added or edited in the file, /etc/system . The recommended kernel settings are listed in the DB2 Universal Database Version 7.2, FixPak 7 Release Notes. You can find these Release Notes @ http://www-3.ibm.com/software/data/db2/udb/ad/db2irfp7/db2ir50.htm.

The format for setting these values is

set parameter_name = value

The suggested parameters in the DB2 Universal Database Version 7.2, FixPak 7 Release Notes should be further adjusted to include the following minimum values:

After modification of any kernel parameters, reboot the system to make the kernel settings effective.
AIX

For each DB2 instance running DB2 Everyplace:

  1. Modify the login profile (most likely /home/<username>/.profile), to include the following:
    export EXTSHM=ON
  2. Exit the user shell.
  3. Login as the user (to make the changes effective and open a new shell).
  4. From the shell promt, execute the following command:
    db2set DB2ENVLIST=EXTSHM
  5. Restart the DB2 Universal Database instance.

  6. New features and fixes for the DB2 Everyplace Database

    This section begins with a list of features which is followed by recent fixes for the DB2 Everyplace Database.

    Version 8.1 features for the DB2 Everyplace Database

    Application Development

    Performance

    Security and new features

    Fixes for the DB2 Everyplace Database

    This list of fixes include an APAR number (where applicable) which is provided for your convenience.

    Problems fixed since DB2 Everyplace Version 8.1 and Version 7.2.1.


    New features and fixes for the Sync Server and Sync Client

    This section begins with a description of the new Version 8.1 features which is followed by a section for important fixes.

    Features for the Sync Server and Sync Client

    Operational features

    Performance features

    Reliability Line items

    Fixes for the Sync Server and Sync Client

    This list of fixes include an APAR number (where applicable) which is provided for your convenience.

    Problems fixed since DB2 Everyplace 8.1: