        
|
|
|
DB/IQ QA FROM INSOFT
Home > Solutions > DB2 Batch Health Care > DB/IQ QA From Insoft
DB/IQ QA (QUALITY ASSURANCE) FROM INSOFT
SQL Explain & Quality Assurance Tool
DB/IQ QA is a complete DB2 SQL explain solution that is so simple and powerful that it can be used by nearly anyone in an IT organization - even Application Developers. 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 how to improve DB2 performance.
DB/IQ QA also allows DB2 Database Administrators (DBAs) to establish SQL coding standards so that only high quality SQL statements are allowed into DB2 production applications. DB/IQ QA provides the following valuable benefits for your company or organization:
--- DB/IQ QA Enhanced Explain Facility:
- Clear, understandable explanations of access paths for DB2 SQL statements being executed anywhere within your shop
- Easy-to-use ISPF workbench that lists all relevant DB2 access path and performance information in one place
--- DB/IQ QA Expert Performance Recommendations:
- Over 200 expert recommendations on how to improve 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 and 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 shop-wide enforcement of these standards
- Dramatically improve overall quality of all production SQL executing in your company or organization
- Recieve alerts when production DB2 SQL access paths change over time
DB/IQ QA ADD ON PRODUCTS FROM INSOFT:
- DB/IQ IA+ (INDEX ADMINISTRATOR) FROM INSOFT
DB/IQ IA+ assists DBAs to design and implement index schemes for entire DB2 production applications. DB/IQ IA+ generates a unique SQL repository which captures SQL executions and logs how each DB2 table column is being used
DB/IQ IA+ also identifies candidate indexes for DB2 applications and then provides an easy-to-use ISPF workbench to allow DBAs to build and examine potential indexing schemes
Click here for additional information 
- DB/IQ MA+ (MIGRATION AID) FROM INSOFT
DB/IQ MA+ assists DBAs to administer DB2 and to run the necessary database maintenance utilities that ensure optimal production application performance. DB/IQ MA+ provides a variety of tools that enable DBAs to find and fix DB2 space problems and fragmentation, to run RUNSTATS and STOSPACE utilities to ensure proper SQL access paths are selected, and to free invalid Plans & Packages which might be cluttering up the DB2 catalog. DB/IQ MA+ ensures that DB2 is in the best shape possible with the least amount of effort expended.
Click here for additional information
For more information, or a web demonstration of DB/IQ QA from InSoft, please Click Here.
About | Solutions | Products | News | Partners | Support | Contact
Downloads | Customer Login | Site Map
|
|
|
   "The Batch Analyzer Attach Option has solved our problems created by TSO. Our system is more productive in so many ways: we can run more jobs, use less memory and space, and even play "what-if" scenarios when an abend occurs.
- Todd Smith, Director of DB2 Database Administration, State of North Carolina
|
|
|
