Application Development Guide

Running, Testing and Debugging Your Programs

The Application Building Guide tells you how to run your program in your environment. You can do the following to help you during the testing and debugging of your code:

• Use the same techniques discussed in Prototyping Your SQL Statements. These include using the command line processor, the Explain facility, analyzing the system catalog views for information about the tables and databases your program is manipulating, and updating certain system catalog statistics to simulate production conditions.
• Use the database system monitor to capture certain optimizing information for analysis. See the System Monitor Guide and Reference.
• Use the flagger facility to check the syntax of SQL statements in applications being developed for DB2 Universal Database for OS/390, or for conformance to the SQL92 Entry Level standard. This facility is invoked during precompilation. For information about how to do this, see Precompiling, towards the end of the section.
• Make full use of the error-handling APIs. For example, you can use error-handling APIs to print all messages during the testing phase. For more information about error-handling APIs, see the Administrative API Reference.