DB/IQ QA
QA analyzes and performs standardization checks on
any SQL code; whether in source form, a view, or part
of a DBRM resulting from the DB2 pre-processor or as
an application bound in the DB2 Catalog. All checks
include explaining how DB2 processes this statement
and which access paths will be taken. Performing QA
on SQL code produced by the DB2 pre-processor before
applications are compiled or bound, guarantees conformity
to site standards. This is an important step, as violations
can lead to the flushing of subsequent compile steps.
QA's interactive facility allows quality control
and full explain functionality for all SQL statements
at source statement level. The QA Explain facility is
a complete explain tool integrated into the Quality
Assurance. It provides the SQL developer with a detailed
explain analysis together with all relevant optimizer
values.
QA's Explain History holds all explained statements
checked by QA. This facility offers a user-friendly
ISPF interface to query the statements, cost factors,
and all explained access paths and optimizer information.
This feature allows both DBAs and developers to compare
different versions of the "same" SQL. Batch
utilities include a compare feature, which can even
compare an application's SQL across collections for
different clients.
Any detected violations can optionally be kept in DB/IQ's
History Database. The included Audit functions evaluate
the situation in your shop, draw up a balance sheet and
report on frequently violated rules and the applications
violating most. This facility enables improvement or deterioration
to be easily recognized over a set period of time, whether
for just a single module or all DB2 applications.
|
|
|
News |
|
|
|
 |
|
Partners |
|
|
|
|
|
|
|
|
|
|
|
