Turboimage Database Tools

Flexibase has the same capacity management features as the other two products; they are executed
by the Flexibase program. It can also accept quite complex calculations to determine the new
capacity of a dataset, based upon the capacities of other datasets.
All three can set up batch jobs that will automatically manage dataset capacities when streamed on a
regular basis.
Reporting
All three products provide some level of reporting. They can all list details of the structure of the
database, and recreate the database schema.
In addition, they all include further reporting features:
Both the DBGeneral
Section 2
package and Flexibase provide database analysis.
They will examine the whole database for capacity information, blocking factors, and
path, chain and sortitem efficiency within master and detail datasets. Then they make
recommendations such as '
reduce dataset capacity'
or '
repack dataset'
. DBGeneral
will
also make recommendations on structural damage and inefficient synonym chains in
master sets.
Adager
lite
includes
howmessy
from Robelle, which reports information about
datasets.
DBGeneral
Intro
will store dataset capacity information spanning up to six years for
trend analysis.
Flexibase will analyze log files in order to report database access information (as will
DBGeneral's DBAudit option). Some trend analysis of this information is planned for
future releases.
Fixing structural damage
All three products can detect broken chains. This feature is included in all the
lite
and
full
packages
described in the introduction; in DBGeneral's case it is included in the
Section 2
module.
Adager allows you to choose which dataset and path you wish to check at high speed.
DBGeneral provides menu options to examine specific datasets, paths or the whole
database for errors, at high speed.
Flexibase provides a separate utility that examines the whole database.
All three products can repair or rebuild broken chains/paths and datasets.
Adager can also replace 'lost' dataset files (but not the data within).
Database restructuring
All three products can list the database structure and modify it to add, delete, modify and rename
dataitems, datasets, paths, and sortitems. They all allow you to modify the security on datasets and
dataitems, and rebuild the database schema file. DBGeneral and Flexibase can restructure a
database either directly from a schema file or from individually specified changes. Adager is
introducing the restructure from schema feature.
As described earlier
,
both Adager and DBGeneral supply versions that do not do structural changes.
The references below are to the
full
functionality packages, which do.
Page
2
of
5
Third
-
Party MPE/iX Database Tools
7/18/2008
http://www.hp.com/cgi
-
bin/pf
-
new.cgi?IN=http://jazz.external.hp.com/papers/dbtools.html