Contents:

• dbbexp
• dbcfix
• dblogreset
• dbrecover
• dbrepl
• dbstore
• dbutil
• dbvolchange
• dbvolextend
• fwaudit
• fwutil
• prschema
• query3k
• schema

Overview

Summary of database utility changes/enhancements:

• dbrecover, dblogreset, dbstore, dbbexp, dbcfix were changed to no longer use the cache size configured in the server config file. A new command line option may be used to specify a custom buffer cache size, if desired.

• dbrecover was enhanced to support incremental recovery
• dbrecover was enhanced to support a -T option to specify a "point in time"

• dblogreset was enhanced to retain forward-log functionality after an abnormal server termination

• dbrepl utility introduced for database server replication

• dbutil, schema, prschema add support for case-insensitive indexes
• dbutil syntax for "delete path" has been simplified

• fwaudit allows more complex filter expressions
• fwaudit enhanced for optional dbbegin/dbend, dbmemo output
• added "id" and "conntime" criteria to fwaudit filter expressions

• fwutil library introduced to access the forward-log files.

• query3k defaults to /var/tmp instead of /tmp for temp files
• query3k no longer displays max capacity in FORM SETS
• query3k enhanced where Eloquence limits exceed TurboIMAGE limits

dbbexp

• The dbbexp utility was modified to use a default cache size of 5 MB. Previously, the cache size configured in the database configuration file was used.

• Added a new command line option -b <size> to specify the buffer cache size (in MB).

dbcfix

• The displayed number of processed records was changed to cover up to 9 digits.

• The dbcfix utility was modified to use a default cache size of 64 MB. Previously, the cache size configured in the database configuration file was used.

• Added a new command line option -b <size> to specify the buffer cache size (in MB).

• A problem comparing P and Z item types was fixed. This fixes a problem where dbcfix might dignose a non-matching search item in some cases and would trigger repair of this chain unnecessarily.

  The P and Z item types may use a different binary representation for the same numeric value. Eloquence compares P and Z items based on their numeric value, even if different binary encoding is used (eg. unsigned and positive values are considered the same).

  However, dbcfix used a binary comparison on P and Z item values in some consistency check and considered positive and unsigned values different, even though they represented the same value.

dblogreset

• The dblogreset utility was modified to use a default cache size of 5 MB. Previously, the cache size configured in the database configuration file was used.

• Added a new command line option -b <size> to specify the buffer cache size (in MB).

• The dblogreset utility was changed to create a recovery forward-log "bridge segment", if necessary.

  If the server process terminates abnormally, a subsequent server start or use of the dblogreset utility performs a startup recovery that re-applies any recently committed transactions.

  The database server startup recovery and the dblogreset utility have been enhanced to continue the forward-log after a server crash. Any changes applied during startup recovery may now be captured in a special recovery forward-log segment. Previously, an existing forward-log was disabled in this case so a new backup was required to regain the ability of using dbrecover.

  Please note that audit information are not retained for any recovered transactions. The fwaudit utility outputs a warning note when it discovers this situation.

• The dblogreset utility was enhanced to support a new configuration option to enable read access on forward-log files for the group (GID) specified in the database server configuration file.

  By default the dblogreset utility creates any forward-log files with restrictive permissions that only allow the configured user (and the superuser) to access the forward-log files.

  The [forwardlog] GroupReadAccess configuration option may be used to specify read access for the configured group to the forward-log files.

  [forwardlog]
  GroupReadAccess = 0|1
  

  If set to a nonzero value, forward-log files are created with a permission that allows group read access (configured with the [Server] GID option). If set to zero, forward log files are created with a permission to restrict access to the owner (configured with the [Server] UID option).

  The default value is 0 to permit owner access only.

dbrecover

• The dbrecover utility was modified to use a default cache size of 5 MB. Previously, the cache size configured in the database configuration file was used.

• Added a new command line option -b <size> to specify the buffer cache size (in MB).

• The dbrecover utility was enhanced to support incremental recovery. If aborted prematurely, the dbrecover utility may be restarted and should be able to continue from the previous point.
  The original dbrecover utility required starting from the previous backup.

  Please note: When using incremental recovery the server process MUST NOT not be started between dbrecover runs when the server is configured in a MASTER or STANDALONE (default) role. The server may be started when configured to function in a SLAVE role as this will not change the data volumes.

• The dbrecover utility was enhanced to support recovery up to a specified point in time.

  The new -T option may be used to specify a point-in-time up to which dbrecover applies changes. Once this point is passed, dbrecover will exit. Incomplete transactions are not applied.

  The following syntax is supported to specify a timestamp:

  YYYY-MM-DD [HH:MM[:SS]]
  MM/DD/YYYY [HH:MM[:SS]]
  DD.MM.YYYY [HH:MM[:SS]]
  

  Any character may be used to separate date and time. Specifying the time is optional, it defaults to 00:00:00 if not present.

  For example:

  dbrecover -T "2007-02-22 16:53" ...
  

  This specifies to apply transactions committed up to Feb 22, 2007, 16:53:00.

dbrepl

• The new dbrepl utility is used to replicate database transactions to other database environments.

dbstore

• The dbstore utility was modified to use a default cache size of 5 MB. Previously, the cache size configured in the database configuration file was used.

• Added a new command line option -b <size> to specify the buffer cache size (in MB).

dbutil

• Added support for case insensitive index option.

• On recent Windows versions the dbutil utility could fail to start.

  During dbutil startup, a temporary file was created in the current root directory, typically C:\.

  However, on Windows Vista, C:\ is write-protected by default, causing dbutil to fail.

  The dbutil utility was changed to use the system-defined temporary directory.

• The DELETE PATH syntax was simplified and no longer requires specification of a master set. The new syntax is as below:

  DELETE PATH item-name;
  

  The previous syntax is still accepted but the specified set name is not verified.

  DELETE PATH item-name(set-name);
  

  Deleting a path from a set does not require specifying a master set as this information is available from the database schema.

• The dbutil utility enforced a minimum record size (media size) of 4 bytes. This limitation could affect compatibility of stand-alone manual master and detail sets. An error message like below was output by dbutil:

  SET-NAME: Data set below min. entry length (4)
  

  The minimum record size limitation was removed from Eloquence B.07.10 (and recent B.07.00 patch levels) but was still enforced by dbutil.

dbvolchange

• The dbvolchange utility was changed to retain additional status information in the volume files that is used by replication and incremental recovery.

  Older dbvolchange versions did reset this information and therefore could cause a problem when used with replication.

dbvolextend

• The dbvolextend utility was changed to retain additional status information in the volume files that is used by replication and incremental recovery.

  Older dbvolextend versions did reset this information and therefore could cause a problem when used with replication.

fwaudit

• The internal "expression stack" limit was increased. An overflow of the internal expression stack causes the fwaudit utility to abort with a message like below:

  Error in filter expression: expression too complex
  

  Originally, the capacity of the message stack was 100 elements. This has been increased to 1000 elements to allow more complex filter expressions.

• The fwaudit utility was enhanced to support information passed by the TurboIMAGE DBMEMO, DBBEGIN and DBEND calls.

  Please note that the HP3K_API_COMPAT database property must be set appropriately for the TurboIMAGE DBMEMO, DBBEGIN and DBEND calls to have any effect.

• The fwaudit utility was enhanced to support filtering by TurboIMAGE DBMEMO, DBBEGIN and DBEND information.

• The new -m command line option was added to output TurboIMAGE DBMEMO and DBBEGIN/DBEND records. The -m option may be combined with the -r option (print clear text report).

  Information passed by the TurboIMAGE DBMEMO, DBBEGIN and DBEND calls is output as text. Any non-printable characters are printed as octal escape sequences (the same way item values are output). The -x command line option may be used to select output in hex dump format.

• The "conntime" session item was added to allow filtering by the session connection timestamp.

• The "id" session item was added to allow filtering by a specific session identifier.

• fwaudit could fail with an error message like below, if the same item name was present in different databases, using different item types.

  item requires a string filter argument
  item requires a numeric filter argument
  

fwutil

• The new fwutil library enables access to the Eloquence database forward-log files that holds the archived committed transactions.

For more information, please refer to the Eloquence fwutil documentation.

prschema

• Added support for case insensitive index option.

query3k

• QUERY3K was changed to use the /var/tmp directory as a default location to create temporary files. Previous QUERY3K versions used the /tmp directory by default.

• The FORM SETS command was changed to suppress outputting the MAXIMUM CAPACITY if the output would be the Eloquence default. As all Eloquence data sets are considered to have a dynamic "capacity" this would otherwise clutter the output without providing any additional information.

• QUERY3K was enhanced to improve support of the Eloquence database limits that exceed the previous TurboIMAGE limits.

  QUERY3K should now support the following limits

  • a record size of up to 5120 bytes
  • 2048 items per database
  • 500 data sets
  • 1024 items per set.
  • The item type 'B' (binary) is now mapped to 'X'.

  String items with more than 255 bytes per subitem are not yet fully supported and may result in undefined behavior.

• A REDO command could result in a stack corruption and/or QUERY3K crash if the command line exceeded 255 characters and the command was edited.

• A problem with the MATCHING clause ("Generic Search") was fixed. A dot (".") in a search condition using the MATCHING clause was not considered literally but instead matched arbitrary characters.

  For example:

    MATCHING "d.dd" should match the value "2.50" but not "4444".
  

schema

• Added support for case insensitive index option.

• An item of type B (binary) may be specified with a partial size in an index definition.

• The schema processor enforced a minimum record size (media size) of 4 bytes. This limitation could affect compatibility of stand-alone manual master and detail sets. An error message like below was output by the schema processor:

    *** (ERROR) Record size below minimum
  

  The minimum record size limitation was removed from Eloquence B.07.10 (and recent B.07.00 patch levels) but was still enforced by the schema processor.