1) A Complete
Database Analysis in Less Than 10 Minutes
2)
Optimization of DMSII databases from 30 up to 95%
1) Analysis: More information than the one provided by
DBANALYZER:
Static:
-
population
-
length
of records/entries
-
records
per
block,
entries
per
table,
etc.
Dynamic:
-
Actual
population
-
Degree
of
saturation
-
Wasted space
-
Actual
loadfactor
-
BIAS,
etc.
... And
besides:
Certifies
structures:
-
checks
invalid
duplicity
of
accesses *
-
validates
keydata
in
sets
and
subsets *
-
2.5
times faster than
DBCERTIFICATION
consuming
7 times
less
I/O
(*
DBCERTIFICATION doesn’t do it)
-
possible interrelation with other programs for monitoring
purposes
-
additional BIAS
Provides Information About:
-
Methods of duplicated accesses, or manageable into a
less cost form
-
Unused accesses
-
Structures close to saturation
-
Better way to define accesses
2) INTOP/DB
Optimizes databases from 30 up to 95%
Optimizes DMSII®
databases from 30 up to 95% by generating and executing software to reorganize
them. Based on the Statistics created by DMSII®,
it reorders the databases as the applications need them. At the end, it
generates a WFL to run the reorganization automatically.
FASTDUMP also optimizes DMSII databases, but
up to 60 times faster than
the standard DMSII approach.
