 |
» |
|
|
|
by Bharati Desai
Commercial
Systems Division Overview | |
This is an overview of the enhancements to IMAGE/SQL and TurboIMAGE/XL
that have been implemented since the release MPE/iX 5.5 (C.55.00).
For additional information, refer to the following articles in Chapter
10, "Technical Articles": IMAGE/SQL with TurboIMAGE/XL Enhancements TurboIMAGE/XL Dynamic Detail Dataset Expansion (DDX)
Problem IMAGE/SQL Dynamic Dataset Expansion for Master Datasets
(MDX) New Features in ALLBASE/SQL Version G3
The highlights of this release of IMAGE/SQL, version B.G2.07,
and TurboIMAGE/XL, version C.07.14 are the following: B-Tree indices enhancement ODBCLink/SE, 16-bit and 32-bit ODBC driver, bundled
with IMAGE/SQL Support for third-party composite indices IMAGE/SQL Dynamic Dataset Expansion for Master Datasets
(MDX) Additional manuals bundled with IMAGE/SQL Manuals available on HP Instant Information CD-ROM: HP IMAGE/SQL Administration
Guide TurboIMAGE/XL Database Management System
Reference Manual
Updating from an Earlier Release | |
If you are updating from an earlier release of IMAGE/SQL,
you must DETACH
databases which are ATTACHed
to one or more DBEnvironments and ATTACH
again in order to benefit from the enhancements. For performance
improvement, issue the UPDATE STATISTICS
command of ISQL for each of the tables you access frequently. If
you have created SQL data using an earlier release of IMAGE/SQL,
perform the ALLBASE/SQL migration to migrate your DBEnvironment
to the current G3 format. For more information, refer to the ALLBASE/SQL
Database Administration Guide. TurboIMAGE/XL is enhanced to increase the concurrency of modification
intrinsics, DBPUT,
DBDELETE, and
DBUPDATE (Critical
Item Update feature ON).
To use this enhancement, your database must be activated to use
the Dependency Semaphore. To achieve this, the ENABLE
and DISABLE commands
of DBUTIL introduce
a new option, DSEM.
The default for DSEM
is DISABLED. The default for Critical Item Update option is now changed
from DISALLOWED
to ALLOWED. A jumbo data set cannot be enabled for dynamic expansion. If you have third-party indexing (TPI) enabled for
the database and want to create B-Tree indices, obtain the correct
version of the third-party software which recognizes this coexistence.
Otherwise, you will get run-time errors returned by third-party
software for new modes of DBFIND,
DBINFO, and other
utility commands.
ODBCLink/SE | |
IMAGE/SQL is bundled with ODBCLink/SE, which is a replacement
for HP PC API. ODBCLink/SE is an implementation of Microsoft's Open
Database Connectivity (ODBC) interface that enables Microsoft Windows
based applications and tools to access TurboIMAGE/XL data on the
HP 3000 in a client/server environment. HP PC API will no longer be distributed with IMAGE/SQL software.
It can co-exist with ODBCLink/SE but will no longer be enhanced.
For more information, refer to the article, "Introducing ODBCLink/SE,"
in this Communicator 3000 and the manual,
ODBCLink/SE Reference Manual, which is bundled
with IMAGE/SQL. |
