G06.25 Release Version Update Compendium

G06.25 Release Version Update Compendium—529423-002
4-1
4
Database and Transaction
Processing Products
The G06.25 RVU contains new features for these database and transaction processing
products:
•
DP2
•
Enform Optimizer
•
NonStop SQL/MX
•
TS/MP PATHMON
DP2
DP2 has been enhanced with a new SETMODE function (function value 266), which
can be used to defer cache flushing when the file is closed by the last opener. If
param1 = 1, the file is closed without first flushing cache; flush occurs as a background
activity. Flushing is interrupted if the file is re-opened. This function can only be used
when the file is opened with syncdepth > 0; the file can be audited or non-audited.
Setting param1 = 0 reverts to standard default behavior, which is to flush all cache
when the last close occurs.
Executing the new SETMODE on a DP2 version which does not support the feature
will cause SETMODE to return CCL and error 2 (invalid operation). An application can
verify that the SETMODE has been accepted if SETMODE returns CCE. Applications
should tolerate a CCL return in order to continue functioning on old and new DP2
versions.
The new SETMODE is intended to improve file close performance in specific
instances. When this new feature is enabled, cache flushing occurs as a background
activity which allows the last close to occur without having to wait for cache flush. This
can be useful when a large amount of dirty cache is accumulated by an application,
and there is a need to close the file or terminate the application quickly. However, note
that in using this feature, the application does not know that all data has been flushed
when the last close occurs.
Enform Optimizer
Enform Optimizer is enhanced to:
•
Add support for Enform Plus
•
Add support for format 2 files
•
Leverage faster processes and larger memory sizes for improved performance