| |
This document provides a list of enhancements and user visible changes
in Eloquence B.08.00, relative to the original B.07.10 release.
Contents:
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
Please notice that most of these changes were also released as patches
for B.07.10.
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.
For more information, please refer to the
Eloquence Database replication documentation.
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
dbvolextend
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
For more information, please refer to the
Eloquence Database auditing documentation.
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
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
|
|
