---------------------------------------------------------------------- ELOQUENCE B.08.20 - patch PE82-1609260 ---------------------------------------------------------------------- This patch enhances or fixes defects of the dbrepack utility as released with Eloquence B.08.20. This patch will be integrated in the Eloquence B.08.20 release. Eloquence B.08.20 must be installed before applying this patch. Severity: PE82-1609260: BUG FIX Superseded patches: PE82-1609230: ENHANCEMEMT PE82-1609220: ENHANCEMEMT PE82-1609190: ENHANCEMEMT PE82-1609120: BUG FIX PE82-1502090: BUG FIX PE82-1501280: BUG FIX PE82-1410150: BUG FIX Patch PE82-1609260 ------------------ Platforms: All * If the memory limit is too low to process master sets and FTS data in a single pass, the necessary -m setting is now suggested. * The default memory limit is now set according to the estimated available process memory. * Fixed various message output issues. * Fixed a problem introduced with patch PE82-1609190. Under certain conditions dbrepack could abort with a message like below: D0: panic: Fatal problem detected in qfg_map_recno D0: Assertion failed: recno <= qfp->rp.last_recno_used D0: panic: Aborting on internal failure, file quick_fill_gap.c, line 738 Patch PE82-1609230 ------------------ Platforms: All * The new command line option -vv outputs detailed internal progress information along with timing information. The output is intended to help analyzing dbrepack performance. * Improved performance of the dbrepack analysis phase. The dbrepack analysis verified the deleted records in a data set. Depending on the size of the data set and the number of deleted records this could result in a noticeable performance impact. dbrepack was changed to use a quick estimation whether disk space is reclaimable or the set is to be skipped. A detailed analysis is only performed if the data set is repacked. Patch PE82-1609190 ------------------ Platforms: All * Improved i/o performance, avoid random i/o whenever possible. Patch PE82-1609120 ------------------ Platforms: All * Improved the dbrepack scalability when repacking a large number of records. The new implementation uses the available memory to speed up the record number mapping. On 64-bit systems where a 64-bit dbrepack binary is installed the default memory limit is 4 GB. Please note that on 64-bit Windows the separate dbrepack64.exe is installed. On 32-bit systems where a 32-bit dbrepack binary is installed the default memory limit is 1 GB. The -m command line option may be used to adjust this limit. Running dbrepack in read-only mode checks whether the current memory limit is sufficient to repack all records. If necessary it suggests how the -m option should be set. Running dbrepack in read/write mode repacks as many records as possible, given the current memory limit. If the limit is too low to repack all records, dbrepack may be repeatedly run to repack the remaining records. It suggests how the -m option should be set so that all remaining records can be repacked. Patch PE82-1502090 ------------------ Platforms: All * Fixed a performance issue when used in readonly mode and the server process was in on-line backup mode. In read-only mode dbrepack periodically verifies the volume if the eloqdb process is still in on-line backup mode. This check was happening too often and could affect performance. Patch PE82-1501280 ------------------ Platforms: All * Fixed a numeric overflow in a verbose message. The summary message indicating the total amount of reclaimed disk space was limited to 32 bit (4 GB). Any larger values were truncated, caused by an intermediate overflow when calculating the summary value. This did not effect on the correct function. Patch PE82-1410150 ------------------ Platforms: All * Fixed a defect that could result in dbrepack aborting with the message below (#4195): Assertion failed: new_recno != 0 panic: Aborting on internal failure, file quick_fill_gap.c, line 878 Depending on the number of records and deleted records one entry of the internal record map could become corrupted, resulting in a failed consistency test. * Improved dbrepack scalability on large databases. The dbrepack algorithm was refined to improve performance with large data sets. Platforms: Windows * A separate 64-bit build of the dbrepack64 utility is installed on 64-bit Windows systems. The 64-bit dbrepack64 utility is required to repack data sets that exceed 1.5 billion records. The 32-bit dbrepack utility may fail due to address space limitations. Platforms: HP-UX, Linux * The dbrepack utility is installed as a 64-bit binary on 64-bit systems. This allows repacking data sets that exceed 1.5 billion records. The 32-bit dbrepack utility may fail due to address space limitations. Installation: ------------- Please download the patch archive that corresponds with the installed release. The patch files follow the conventions below: PE82-1609260-hpux-ia64.tar.gz ^ ^ ^ | | Architecture / OS specific build | Operating system Patch ID HP-UX: In order to install this patch, you need to unpack it with gzip and tar. Gzip is included with HP-UX. Installation requires root privileges. cd /opt/eloquence/8.2 gzip -dc /path/to/PE82-1609260-hpux.tar.gz | tar xf - Files: bin/dbrepack share/doc/PE82-1609260-README Linux: In order to install this patch, you need to unpack it with tar. Installation requires root privileges. cd /opt/eloquence/8.2 tar xzf /path/to/PE82-1609260-linux.tar.gz Files: bin/dbrepack share/doc/PE82-1609260-README Windows: Two options are available for patch installation. The patch is available as self extracting archive for automatic installation and as a zip archive for manual installation. Both patches are equivalent. Installation requires administrative capabilities. For automatic installation of this patch, please download the patch file PE82-1609260-win32.exe. Before installation, please consider stopping the database server, then execute the patch installation program. Installation does not require a reboot unless the patched files were active. For a manual installation of the patch, please download the patch file PE82-1609260-win32.zip and unpack its contents. Then perform the following steps: * Please copy the dbrepack.exe file into the Eloquence bin directory. (Default location: C:\Program Files\Eloquence\8.2\bin) * Please copy the dbrepack64.exe file into the Eloquence bin64 directory. (Default location: C:\Program Files\Eloquence\8.2\bin64) * Please copy the PE82-1609260-README.txt file into the Eloquence share\doc directory. (Default location: C:\Program Files\Eloquence\8.2\share\doc) Files: dbrepack.exe dbrepack64.exe PE82-1609260-README.txt