============================================================= Problem: ============================================================= DB2 query returns wrong result on decimal data using SUM function within Federation Server. ============================================================= Description of Problem: ============================================================= DB2 query returns wrong result on decimal data using SUM function within Federation Server. ============================================================= Prerequisite software: ============================================================= Data Management Server 2.3 (2.3) ============================================================= To install the patch [UNIX]: 1. Change directory to the root directory of the Data Management Server installation. This is the directory named 'dmserver' created during installation. For example, if you installed DMS in /opt/dataflux, run this command: cd /opt/dataflux/dmserver 2. Stop the server if it is running. Run the command: ./bin/dmsadmin stop 3. (AIX only) Run this command: ./bin/uncache_libs or ask your sysadmin to run the slibclean command on the system. 4. Run this command: gzip -d -c PATH_TO/dmserver-fix19454-PLATFORM.tar.gz | tar xvf - replacing PATH_TO with the correct path to the patch file and PLATFORM with the the platform name (linux, sol64, etc.). 5. If you stopped the server in step one, restart it. Run the command: ./bin/dmsadmin start To install the patch [Windows]: 1. If you have multiple instances of the server installed on the machine, determine the name of server instance you will be patching. This was chosen during the initial installation, and defaults to 'server1'. 2. Stop the DataFlux Data Management Server service for the instance if it is running. You can check the status of the service using the Services applet on the Windows Control Panel (may be found under Administrative Tools). The instance name is included the display name in the applet, for example: DataFlux Data Management Server (server1) 3. Unzip the archive dmserver-fix19454-win32.zip (32-bit DMS) or dmserver-fix19454-win64.zip (64-bit DMS) into the root directory of your Data Management Server instance. This is typically: C:\Program Files\DataFlux\DMServer\server1 If the instance name is not 'server1' or you installed to a different location, adjust the path accordingly. 4. If you stopped the Data Management Server service in step one, restart it. The following files will be installed or updated by this patch: [aix64] lib/tkts/tkdecnm.so lib/tkts/tketsb.so