Establish and Maintain DB2 for z/OS SQL Coding Standards
DB/IQ QA allows DB2 Database Administrators (DBAs) to establish SQL coding standards so that only high quality SQL is allowed into production.
DB/IQ QA is a complete DB2 SQL explain solution that is so simple and powerful to use, not only can DB/IQ QA provide understandable explanations as to how DB2 is accessing data for each SQL statement, it can also provide insightful recommendations on improving DB2 performance.
DB/IQ QA Expert Performance Recommendations:
- Over 200 expert recommendations on improving performance for each SQL statement
- Establish and enforce DB2 performance limits such as the number of DB2 tables joined, sorts, unions, sub-selects, etc.
DB/IQ QA Quality Control System:
- Detect and eliminate poor SQL coding practices such as: SELECT, DELETE or UPDATE statements without WHERE clauses and SQL containing predicates with non-matching host variable attributes
- Establish DBA developed rules for acceptable SQL coding practices and quickly deploy organization wide enforcement of these standards
- Dramatically improve the overall quality of all production SQL executing in your organization
- Receive alerts when production DB2 SQL access paths change over time
DB/IQ QA Enhanced Explain Facility:
- Clear, understandable explanations of access paths for DB2 SQL statements being executed anywhere within your organization
- Easy-to-use ISPF workbench that lists all relevant DB2 access path and performance information in one place
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
|
