Modern application development requirements require the ability to identify performance issues and ensure long-term maintainability from the design stage. The later in the development process that defects are found, the more difficult they are to fix. The sophistication of the DB2 environment may cause bad SQL to be written. Even if the Result Set is correct, it may be very inefficient or contain ”time bombs”, which result in future failures or major performance problems.
Defining standards and guidelines for developing DB2 applications is essential, but without Quality Assurance methods and procedures, the defined standards cannot be effectively enforced. In a production environment, where many thousands of SQL statements are executed, an automated Quality Assurance workflow is the only way of ensuring compliance with standards.