================================================================================================= DB2 Everyplace Version 8.1.4.8 for Webshere Everyplace Access Version 5.0 Fixpack 2 Interim Fix 7 ================================================================================================= This readme contains: * list of fixes included in this fix pack * installation instructions for the server * backup instructions for the server * uninstall instructions for the server Note: DB2 Everyplace Version 8.1.4.8 includes all the fixes from previous fix packs. ================================================ Fixes included in DB2 Everyplace Version 8.1.4.8 ================================================ IC42187 A table which is part of a DataPropagator table subscription will exhibit one of the following problems if its primary key columns are ordered differently between the table schema and the primary key definition. If the primary key columns are not all of the same datatype, an SQL0401N message will be reported during replication, and replication will fail to complete. If the primary key columns are all of the same datatype, clients will not be properly notified of rejected rows which they have synchronized. IC42223 The USERNAME and DATABASENAME columns in DSYCTLDB. DSY.LOG are too short. Thus, when we attempt to log messages to DSY.LOG and provide a user name and/or database name, the insert fails. IC42333 When the XML Scripting tool creates a file subscription, it displays a message if the source file specified by the subscription does not exist. The XML Scripting tool still creates the subscription, but the user must make sure that DB2 Everyplace Sync Server can access the source file at synchronization time. IC42768 Synchronization fails if there are output messages left from the previous session. IC42769 The Sync Server consumes large amounts of disk space by backing up the synchronization messages. IC42886 While running DB2 Everyplace version 8.1.4, you get the following error message in Mobile devices Administrati, FixPak n Center log: DSYS005E Replication failed for database 'source_database_name' DSYJ001E A database error occurred. SQL0204N "DSY.LFxxxxxxxxxxxx" is undefined name. This error message should not have been logged and therefore, can be ignored. IC42984 The DB2 Everyplace Sync Server fails to prune the message store backup files. IC43043 Dropping a source table that is being used by subscription causes replication to fail silently (it mistakenly reports success), and deleting such a subscription does not drop related tables in source and mirror databases (there are left over tables, rows). IC43057 The Sync Client fails to synchronize the configuration subscription as a result of heavy load on the Sync Server. The Sync Client log contains the message DSYC613E: Internal Sync Server Error and the Sync Server log contains the message Sync Client fails to synchronize the configuration under high concurrency. IC43097 When creating an upload subscription, customers are unable to change or remove an index. In addition, the default value data filter name cannot be defined through the Mobile Devices Administration Center. IC43192 Clients may receive incorrect master conflicts during synchronization in the following scenario: 1) an error is encountered by the Sync Server while processing data from a client's input message for a table subscription, and 2) the following replication fails while deferring this client's partially processed input data. IC43193 Replication fails with a NullPointer Exception with the following error in the Mobile Devices Administration Center logs folder: DSYS005E Replication failed for database :java.lang.NullPointerException. IC43391 When the administrator specifies a blank password for a user, the synchronization fails to authenticate. IC43392 Creating a JDBC subscription on a DB2 on AS/400 table using the IBM Toolbox for Java driver fails with the error "java.lang.RuntimeException: The system name for DSYH was not found in the system catalog" where is a string of numbers. IC44853 The device is unable to synchronize successfully. DSYC613E error is reported on the device, and a DSYG001E: Null Pointer Exception is logged at the sync server. IC45118 Lotus Domino Server 6.x does not allow anonymous access to HTTP server. As a result, the client obtains the initial object of the server as an IOR; using the HTTP protocol fails. Instead of using HTTP protocol, DB2 Everyplace now uses DIIOP protocol, and you can now configure your server to allow or not allow anonymous access on the web server. IC46278 DB2 Everyplace replication fails to collect the changed data from a Lotus Domino source database when Australia observes Daylight Saving Time. In the Australian Eastern Time zone, if DB2 Everyplace replication takes place less than one hour after you have deleted, updated, or inserted a document from the Lotus Domino source database, this document is not replicated to the mirror database. You must wait at least one hour to perform replication. Server Installation Instructions ================================= This fix pack is available as two files: * DB2eWEA5002IF7.zip (Windows) * DB2eWEA5002IF7.tar (AIX) Prerequisites: The target machine must have DB2 Everyplace version 8.1.4 installed. It is recommended that the fixpack be tested in your development/test environment before applying it to your production environment. If you wish to backup your current DB2 Everyplace install prior to installing this fixpack, please refer to the "Server Backup Instructions" below. A backup will be required in order to uninstall this fixpack. For Windows: ------------- To install the latest fix pack for IBM DB2 Everyplace version 8.1.4 on Windows systems: 1. Stop all DB2 Everyplace processes For example, the DB2 Everyplace Mobile Devices Administration Center and ensure that all replication and synchronization processes are finished. 2. Login as the windows administrative user. 3. Stop the DB2 Everyplace Application Server in WAS. 4. Unzip the file DB2eWEA5002IF7.zip in a temporary directory. 5. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from \DB2eWEA5002IF7\Server\lib to the \Server\lib directory. 6. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from \DB2eWEA5002IF7\Server\lib to the \installedApps\\db2everyplace.ear\IBM_DB2_Everyplace.war\WEB-INF\lib directory. 7. Copy the ear file (IBM_DB2_Everyplace.ear) from \DB2eWEA5002IF7\config\template\was to the \config\template\was directory. 8. Open a DB2 command window and change directory to the \Server\bin directory. 9. Execute the commands --- dsysetproperty.bat DSYIdflt DSYBuildDate=20050809a dsysetproperty.bat DSYIdflt DSYVRMSuffix=8 10. Execute the command --- dsysetproperty.bat DSYScheduledTasks com.ibm.db2ess.messagestores.utils.MsgDumpsPruneTask=3600 NOTE: 1. is the temporary directory where zip file has been extracted. 2. is the installation directory for IBM DB2 Everyplace. The default value is C:\Program Files\WebSphere\DB2Everyplace. 3. is the installation directory for IBM WebSphere Application Server. The default value is C:\Program Files\WebSphere\AppServer. 4. is the WebSphere node name. In a single server environment, the default value is the server hostname. For AIX: --------- To install the latest fix pack for IBM DB2 Everyplace version 8.1.4 on AIX systems: 1. Stop all DB2 Everyplace processes. For example, the DB2 Everyplace Mobile Devices Administration Center and ensure that all replication and synchronization processes are finished. 2. Login as the root user. 3. Stop the DB2 Everyplace Application Server in WAS. 4. Untar the file DB2eWEA5002IF7.tar in a temporary directory. 5. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from /DB2eWEA5002IF7/Server/lib to the /Server/lib directory. Ensure that the jar files have read permissions for everyone. 6. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from /DB2eWEA5002IF7/Server/lib to the /installedApps//db2everyplace.ear/IBM_DB2_Everyplace.war/WEB-INF/lib directory. Ensure that the jar files have read permissions for everyone. 7. Copy the ear file (IBM_DB2_Everyplace.ear) from /DB2eWEA5002IF7/config/template/was to the /config/template/was directory. 8. Copy the ear file (IBM_DB2_Everyplace.ear) from /DB2eWEA5002IF7/config/template/was to the $HOME/db2everyplace81/config/template/was directory. Set the owner of the file to the DB2 Everyplace Sync Server instance and ensure that the file has read permissions for everyone. 9. Login as the DB2 Everyplace Sync Server instance owner. 10. Open a shell and change directory to the $HOME/db2everyplace81/Server/bin directory. 11. Execute the commands --- ./dsysetproperty.sh DSYIdflt DSYBuildDate 20050809a ./dsysetproperty.sh DSYIdflt DSYVRMSuffix 8 12. Execute the command --- ./dsysetproperty.sh DSYScheduledTasks com.ibm.db2ess.messagestores.utils.MsgDumpsPruneTask 3600 NOTE: 1. is the temporary directory where the tar file has been untarred. 2. is the installation directory for IBM DB2 Everyplace. The default value is /usr/WebSphere/DB2Everyplace81. 3. is the installation directory for IBM WebSphere Application Server. The default value is /usr/WebSphere/AppServer. 4. is the WebSphere node name. In a single server environment, the default vlaue is the server hostname. 5. $HOME is the home directory of the DB2 Everyplace Sync Server instance. Server Backup Instructions =========================== For Windows: ------------- To backup the current IBM DB2 Everyplace version 8.1.4 on Windows Systems: 1. Copy the ear file (IBM_DB2_Everyplace.ear) from the \config\template\was directory to a backup directory. 2. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from the /Server/lib directory to a backup directory. 3. Open a DB2 command window and change directory to \Server\bin directory. 4. Execute the command dsysetproperty.bat DSYIdflt DSYBuildDate and record the returned DSYBuildDate value. 5. Execute the command dsysetproperty.bat DSYIdflt DSYVRMSuffix and record the returned DSYVRMSuffix value. NOTE: 1. is the installation directory for IBM DB2 Everyplace. The default value is C:\Program Files\WebSphere\DB2Everyplace. For AIX: --------- To backup the current IBM DB2 Everyplace version 8.1.4 on AIX Systems: 1. Copy the ear file (IBM_DB2_Everyplace.ear) from the /config/template/was directory to a backup directory. 2. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from the /Server/lib directory to a backup directory. 3. Login as the DB2 Everyplace Sync Server instance owner. 4. Open a shell and change directory to $HOME/db2everyplace81/Server/bin directory. 5. Execute the command ./dsysetproperty.sh DSYIdflt DSYBuildDate and record the returned DSYBuildDate value. 6. Execute the command ./dsysetproperty.sh DSYIdflt DSYVRMSuffix and record the returned DSYVRMSuffix value. NOTE: 1. is the installation directory for IBM DB2 Everyplace. The default value is /usr/WebSphere/DB2Everyplace81. 2. $HOME is the home directory of the DB2 Everyplace Sync Server instance. Server Uninstall Instructions ============================== For Windows: ------------- Server Uninstall requires that you followed the "Server backup instructions" prior to installing this fix pack. To uninstall this fix pack and restore the previous IBM DB2 Everyplace version 8.1.4 on Windows systems: 1. Stop all DB2 Everyplace processes For example, the DB2 Everyplace Mobile Devices Administration Center and ensure that all replication and synchronization processes are finished. 2. Login as the windows administrative user. 3. Stop the DB2 Everyplace Application Server in WAS. 4. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from your backup directory to the \Server\lib directory. 5. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from your backup directory to the \installedApps\\db2everyplace.ear\IBM_DB2_Everyplace.war\WEB-INF\lib directory. 6. Copy the ear file (IBM_DB2_Everyplace.ear) from your backup directory to the \config\template\was directory. 7. Open a DB2 command window and change directory to the \Server\bin directory. 8. Execute the commands --- dsysetproperty.bat DSYIdflt DSYBuildDate= dsysetproperty.bat DSYIdflt DSYVRMSuffix= NOTE: 1. is the installation directory for IBM DB2 Everyplace. The default value is C:\Program Files\WebSphere\DB2Everyplace. 2. is the installation directory for IBM WebSphere Application Server. The default value is C:\Program Files\WebSphere\AppServer. 3. is the WebSphere node name. In a single server environment, the default value is the server hostname. 4. is the DSYBuildDate value which you recorded during the backup procedure. 5. is the DSYVRMSuffix value which you recorded during the backup procedure. For AIX: --------- To uninstall this fix pack and restore the previous IBM DB2 Everyplace version 8.1.4 on AIX systems: 1. Stop all DB2 Everyplace processes. For example, the DB2 Everyplace Mobile Devices Administration Center and ensure that all replication and synchronization processes are finished. 2. Login as the root user. 3. Stop the DB2 Everyplace Application Server in WAS. 4. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from your backup directory to the /Server/lib directory. Ensure that the jar files have read permissions for everyone. 5. Copy the 4 jar files (dsymd.jar, dsyrepl.jar, dsysvr.jar, dsysync.jar) from your backup directory to the /installedApps//db2everyplace.ear/IBM_DB2_Everyplace.war/WEB-INF/lib directory. Ensure that the jar files have read permissions for everyone. 6. Copy the ear file (IBM_DB2_Everyplace.ear) from your backup directory to the /config/template/was directory. 7. Copy the ear file (IBM_DB2_Everyplace.ear) from your backup directory to the $HOME/db2everyplace81/config/template/was directory. Set the owner of the file to the DB2 Everyplace Sync Server instance and ensure that the file has read permissions for everyone. 8. Login as the DB2 Everyplace Sync Server instance owner. 9. Open a shell and change directory to the $HOME/db2everyplace81/Server/bin directory. 10. Execute the commands --- ./dsysetproperty.sh DSYIdflt DSYBuildDate ./dsysetproperty.sh DSYIdflt DSYVRMSuffix NOTE: 1. is the installation directory for IBM DB2 Everyplace. The default value is /usr/WebSphere/DB2Everyplace81. 2. is the installation directory for IBM WebSphere Application Server. The default value is /usr/WebSphere/AppServer. 3. is the WebSphere node name. In a single server environment, the default vlaue is the server hostname. 4. $HOME is the home directory of the DB2 Everyplace Sync Server instance. 5. is the DSYBuildDate value which you recorded during the backup procedure. 6. is the DSYVRMSuffix value which you recorded during the backup procedure. Trademarks =========== IBM, WebSphere, DB2, AIX, and Everyplace are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. Windows is a trademark of Microsoft Corporation in the United States, other countries, or both. Other company, product, and service names may be trademarks or service marks of others. (c) Copyright International Business Machines Corporation 1994, 2005. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.