Indexes Comprise
less than 20% of the raw data in a system,
yet it can cause 80% of all performance problems.
PROBLEMS WITH CURRENT INDEXING
Constant Interruptions due to deadlocks
and bottlenecks reduce productivity.
Manual maintenance
overwhelms DBAs with a repetitive, never-ending task.
Manual index sizing is inefficient and error-prone.
Indexes in databases are difficult to see.
How can you correct something if you can't see
it?
View/IX is
an intelligent agent which clearly reports on
and suggests corrections to your index environment.
PURPOSE
To provide a quick, easy to understand analysis of
the current condition of an index. This multi-faceted
program can be used in many ways to quickly solve
CA-IDMS indexing problems.
Analyzes and sizes up to 100 indexes
per pass
Can be utilized for initial index sizing to configure
index sets correctly from inception
Capable of performing
unattended, automatic rebuilds
FEATURES
Written in standard IBM Assembler
and COBOL
Supports Computer Associates CA-IDMS Release 10.0
through 17 databases
Uses a combination of its own and vendor provided
utilities to accomplish work
BENEFITS
Reduced CPU utilization for CA-IDMS
environments
Dramatic I/O reduction for all index processes,
batch and online
The nearly complete elimination of stalls and
deadlocks related to indexes
Reduced DASD usage and better spreads on remaining
DASD usage
Frequency of index rebuilding sharply reduced
The ability for DBAs and programmers to view
their indexing environment
END RESULT
Quick Insertion
Less Deadlocking
Decreased I/O
Recouped DASD space
Less CPU consumed
PRODUCT ENHANCEMENTS V6.2
View/IX now supports R10 through
R17 of CA-IDMS
Support for COBOL 74 has been dropped. Support
for the Language Environment (LE) version of COBOL
has
been added. That is, you now may choose between
COBOL II and COBOL for MVS.
User-owned index support has been added. View/IX
now includes a way to automatically rebuild
user-owned index sets without writing your own program
to "front-end" the
process.
A SYMBOLIC INDEX conversion feature
is included. If you want to convert all of your
older schema
based
Block Contains and Displacement declarations
over to symbolic notation, View/IX can do
all of the syntax
generation required.
The selector programs,
VIEWIX30 (system-owned) and VIEWIX40 (user-owned)
have been better
documented.
General improvements have been
made to the system-owned index rebuilding process.
Specifically,
if an
index appears undersized to VIEW/IX and
a rebuild run is
being done, VIEW/IX will pass through
the index for rebuild using whatever Block
Contains and
Displacement
declarations exist. It will force Page
Reserve to zero also.
