Welcome to the DB2 Everyplace Version 8.2 release notes.
These release notes contain information about new features, enhancements, and updated procedures in the Version 8.2 release of the DB2 Everyplace.
The DB2 Everyplace Launchpad provides out-of-the-box access to release notes, installation instructions, and other features to help you install and use DB2 Everyplace Enterprise Edition and DB2 Everyplace Express Edition. To start the DB2 Everyplace Launch Pad:
Example: C:\test\DB2Everyplace82\setup.exe
Example: /home/tmp/DB2Everyplace82Beta2/setup.bin
Installing DB2 Everyplace Express is a now two-step process: copy files from a source to the server, then configure the environment. With separate processes, you can change your DB2 Everyplace setup as needed without having to go through the entire installation each time. You can perform either step using wizards or from the command line.
The XML Scripting Tool can now register replication sources, create capture and apply control tables, and define DataPropagator subscription sets. The XML Scripting tool eliminates the need to use the Replication Center to set up the DataPropagator portion of a DB2 Everyplace DataPropagator Table Subscription.
You can add custom logic to a table subscription to perform actions at specific points during the synchronization and replication processes. Custom logic can execute before, during, and after the initial handling of input data from the users in any table subscriptions and before, during, and after the replication of data between the mirror and source tables.
Previously, mirror tables and columns inherited their names from the source database and the user-specified table and column names were only used in the mobile database. The DB2 Everyplace administrator can now define the names of tables and table columns in the mirror database. The existing XML tags as well as the existing table and column name fields in Mobile Devices Administration Center have changed their behavior accordingly, so that the new table and column names are now used in the mirror database as well as the device database.
The DB2 Everyplace Sync Server can create control tables and mirror global tables in a non-default table space.
A wizard is now available to assist the DB2 Everyplace administrator in creating Sync Server instances on the supported UNIX platforms.
To increase security, DB2 Everyplace stores passwords in configuration files, XML scripts, and other locations in encrypted format.
DB2 Everyplace filtering has been enhanced by relaxing some of the filter limitations. You can now use filters that have subqueries nested inside another subquery, multiple table references inside a FROM clause of a subselect, and lookup tables that can be referenced more than once in a clause. In addition, filter syntax follows the syntax for search conditions located in the IBM DB2 Universal Database SQL Reference Volume 1.
Resetting a device, user, or group refreshes the data for the device, user, or group during the next synchronization of the client. It no longer results in loss of pending client changes.
Synchronization sessions are no longer put on hold for the duration of replication between source and mirror database, increasing throughput and availability.
You can now analyze (report) and recover (apply) message data that has been left over in the "Message Store." Data can be left in the Message Store when the client doesn't synchronize after a partial failure.
You can run this utility before resetting a device or user to collect data that can help you diagnose client synchronization problems.
You can collect information about synchronization sessions, including statistics, status, and trace data, and then upload it to the server through a regular upload subscription. It contains a sample application that demonstrates how to utilize data about synchronization activity. The sample application includes a component that generates reports detailing synchronization activity in Microsoft Excel format.
DB2 Everyplace now supports IBM Cloudscape Version 10 as a source database.
For PalmOS, PocketPC, and Symbian OS platforms, the IBM Sync application has been renamed to DB2 Sync. For Windows 32-bit operating systems, PocketPC, Linux, and Neutrino platforms, the command prompt-based sample testisync has been renamed to db2sync_console.
Sync Client activity can be traced at three levels:
The DB2 Sync Client provides a feature for collecting information about synchronization sessions, including statistics, status, and trace data. It uploads the information to the server through an upload subscription. The subscription set DSYCLIENTSTAT_SET, which includes the upload subscription DSYCLIENTSTAT, is created automatically when you install DB2 Everyplace. After installation, you can associate the subscription set with specific groups or users, enabling them to use this feature.
The DB2 Everyplace Sync Client now measures the progress of the synchronization session in finer granularity.
The new Java client supports IBM Cloudscape Version 10 as target database. This client supports background synchronizations while the client database is being used.
The following functions have been added or enhanced:
Different threads within one process (for example, from Java) can have their own connection to the same DB2 Everyplace database.
The length for constraint statements and default values has been increased to 32767 bytes from 512 bytes (constraint) and 128 bytes (default values).
I/O flushes that update the database are handed to the operating system or pushed directly to the storage media after a COMMIT (in manual commit mode) or after completion of the SQL statement (in autocommit mode). An attribute changes this behavior on Windows(R) and Linux on x86 only.
By supporting the DbEdit Eclipse plug-in, DB2 Everyplace provides various additional metadata methods to perform new database operations
JDBC applications can set default statement attributes at connection time.
DB2 Everyplace applications can now set statement properties at connection time as a connection property.
This section contains fixes to the documentation. Each fix describes the name and location of the topic and the error in the documentation
In the "Command line scripts for the DB2 Everyplace Sync Server" topic under the Reference section of the Sync Server Administration Guide and the Information Center, the following fixes are needed:
In the Configuring DB2 Everyplace section of the Installation and User's Guide, the following topic is missing:
Prerequisites:
Install DB2 Everyplace files.
The DB2 Everyplace application server is created by the following steps, with the appropriate configuration parameters. If a copy of the DB2 Everyplace server is already running, stop the server before continuing.
To configure DB2 Everyplace in WebSphere Application Server:
Windows
Run wsadmin.bat.
<WAS_HOME>\bin\wsadmin.bat -f dsyInstallDB2e.jacl WAS_node_name WAS_virtual_host existing_server_name IP_address DSYINSTDIR DSYSQLIBINSTDIR UDB_version
Linux or UNIX
Run wsadmin.sh.
<WAS_HOME>/bin/wsadmin.sh -f dsyInstallDB2e.jacl WAS_node_name WAS_virtual_host existing_server_name IP_address DSYINSTDIR DSYSQLIBINSTDIR UDB_version
To create a JDBC subscription with DB2 on OS/390 (on zSeries server), the user ID for the database connection requires DBADMIN plus CREATEIN privilege for the schema DSY.
ALTER INDEX DSYI19099874167 PIECESIZE 256M using STOGROUP DB2ERSTG PRIQTY 80000 SECQTY 40000
The DB2 Everyplace database JDBC getString() method called on a TIMESTAMP column returns a timestamp in ISO format "YYYY-MM-DD-HH.MM.SS.ZZZZZZ". This is different from the JDBC timestamp escape format "YYYY-MM-DD HH:MM:SS.FFFFFFFFF". DB2 UDB version 8 JDBC returns a timestamp in the format "YYYY-MM-DD HH:MM:SS:FFFFFF".
The following terms are trademarks of the International Business Machines Corporation in the United States, or 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.