|
EZ-Impact Analyzer for DB2 on z/OS
A DBA tool that allows DBA to model effect
of environmental changes in safe environment.
Solution Description
See the effect of Application and/or
System changes on your Static and Dynamic SQL Statements. Highlight
changes in Access Path, Cost and SQL Alerts resulting from environmental
changes such as REORG/RUNSTATS, Application Migration, New Indexes,
Database changes, New DB2 Releases, New APARS, etc.
Business Opportunity
Before performing DB2 release migration,
or making database changes, upgrading machine, etc. DBA can see
potential detrimental changes to applications / programs/ SQL.
- Avoid unforeseen negative effect on
systems resulting from changes.
- Allows DBA to take pre-emptive action
to prevent undesirable changes
- Keep systems running smoothly after
migrations and other changes
- Without Impact Analyzer, site may experience
worse performance and greater resource consumption after making
environmental changes
ROI
- Avoid degraded performance resulting
from environmental changes or application changes
- Improved business productivity
- Better utilization of valuable DBA resource
Detailed Solution Description
When Performing environmental changes
like Reorg or Runstats, or database changes such as new or modified
indexes, Impact Analyzer allows you to
- PREDICT the Impact on Access Paths BEFORE
Re-Bind
- CHECK the Impact on Access Paths AFTER Re-Bind
When MIGRATING applications between DB2
subsystems (e.g QA to Production) Impact Analyzer allows you to:-
- Compare QA Access Paths with Current Production
Access Paths.
- PREDICT how QA Access Paths will change when
migrating to Production.
- PREDICT how PRODUCTION Access Paths will change
when migrating to Production.
When MIGRATING to a New DB2 Release (e.g. DB2
V7 to DB2 V8) Impact Analyzer allows you to PREDICT the Impact
on Access Paths of Vnext
When used in conjunction with EZ-Cache
which captures Dynamic SQL, EZ-Impact Analyzer may be used against
ERP applications(such as SAP® and PeopleSoft®) and other
applications that use Dynamic SQL:-
- Only way to safely perform RUNSTATS
where Dynamic SQL is used without fear of unexpected access
path changes.
Competitive Advantage
When used in conjunction with EZ-Cache:-
- Only product of its type that supports Dynamic
SQL
- Takes into account execution frequencies and
shows access path changes sequenced by total cost difference
Online interactive job submission and analysis
or job streams may be saved and re-used for integration with existing
batch procedures.
Includes Batch and Online Interactive Reporting modes.
Integration with EZ-DB2 Index components
allows easy analysis of the Impact of new or modified indexes
on the Dynamic or Static SQL workload.
The best way to appreciate the rich
functionality and value of EZ-Impact Analyzer is to experience
it yourself, by way of a FREE no-obligation trial. For instant
gratification please contact your local
EZ-DB2 representative.
|
