----------------------------------------------------------------------

ELOQUENCE B.08.10 - patch PE81-1801260

----------------------------------------------------------------------

This patch adds enhancements or fixes defects of the dbutil
utility as released with Eloquence B.08.10. This patch will be
integrated in the Eloquence B.08.10 release.

Eloquence B.08.10 must be installed before applying this patch.

Severity:
 PE81-1801260: BUG FIX

Superseded patches:
 PE81-1711160: BUG FIX
 PE81-1602050: BUG FIX
 PE81-1602010: BUG FIX


Patch PE81-1801260
------------------

Platforms: All

* Fixed a problem where changing the item size could also change the 
  length of index segments referring to this item. Any length specified 
  for an index segment could be replaced by the item size. If an offset 
  was specified for the index segment, the index definition could become
  inconsistent as it exceeds the item.

  As a consequence the index will no longer hold the expected
  information and dbutil will output a warning message the next time
  the database is modified.

  If a database is affected by this problem, a message as below is 
  output by dbutil when changing the database structure.

     WARNING: INDEX-NAME (0/0/0):
     Inconsistent index segment offset, reset

  This message indicates that the segment offset and size were found 
  to be inconsistent with the item size, the item offset was set to 
  zero. The index item definition then needs to be changed to the 
  correct specification as both the offset and length was set to the 
  default.

     CHANGE IITEM index-name = item[:[ofs.]size], ...;

  This will then re-establish the correct definition and rebuild the
  affected indexes.

* Improved index item consistency checks to detect inconsistent
  index segment definitions before uploading the schema changes.


Patch PE81-1711160
------------------

Platforms: All

* Work around a potential inconsistency in the database catalog.


Patch PE81-1602050
------------------

Platforms: All

* Fixed a problem where database restructuring could lead to
  inconsistent item access rules.

  When deleting or inserting data sets, set specific data access
  rules were not properly updated in some cases. As a consequence,
  set specific item access rules could become inconsistent.
  This results in a warning message to the server message log.

  dbutil was fixed to properly update the item access rules and
  detect inconsistent item access rules.

* Fixed a problem where special characters in the input file might
  be considered an EOF condition instead of a syntax error (#3659).

* This patch adds a new statement to delete all item access rules
  with a single command.

  DELETE ALL ITEM ACCESS;


Installation:
-------------

Please download the patch archive that corresponds with the installed
release.  The patch files follow the conventions below:

   PE81-1801260-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.1
gzip -dc /path/to/PE81-1801260-hpux.tar.gz | tar xf -

Files:

   bin/dbutil
   share/doc/PE81-1801260-README


Linux:

In order to install this patch, you need to unpack it with tar.
Installation requires root privileges.

cd /opt/eloquence/8.1
tar xzf /path/to/PE81-1801260-linux.tar.gz

Files:

   bin/dbutil
   share/doc/PE81-1801260-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 PE81-1801260-win32.exe. Before installation, please consider
closing all applications, 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 PE81-1801260-win32.zip and unpack its contents. Then perform
the following steps:

* Please copy the dbutil.exe file into the Eloquence bin directory.
  (Default location: C:\Program Files\Eloquence\8.1\bin)

* Please copy the PE81-1801260-README.txt file into the Eloquence
  share\doc directory.
  (Default location: C:\Program Files\Eloquence\8.1\share\doc)

Files:

   dbutil.exe
   PE81-1801260-README.txt