Troubleshooting Guide

Chapter 5. Troubleshooting Applications

Applications are the means by which most users work with DB2 database data. When things go wrong with applications, many people are affected and your business may suffer.

Testing and debugging applications should be done in a test environment before the application is promoted and propagated to your production environment. Information on how to design, develop, compile, link, test, and debug applications is found in the following documents:

• The Application Development with DB2 Universal Database web site at http://www-4.ibm.com/software/data/db2/udb/ad/ provides updated information on developing applications for DB2. This web site includes the latest information on developing applications for DB2 Universal Database using the embedded SQL, Java, or CLI/ODBC APIs.
• The Application Development Guide and http://www-4.ibm.com/software/data/db2/java/ provide information on how to design and code application programs that use embedded SQL (Structured Query Language) statements or SQLJ (Embedded SQL for Java) to access DB2 databases in supported languages. The book and the web site provides details on how to code user-defined functions and stored procedures (including stored procedures using Java).
• The Administrative API Reference provides information on the use of application programming interfaces (APIs) to execute DB2 administrative functions.
• The CLI Guide and Reference provides information on coding with Call Level Interface (CLI), including stored procedures using CLI. CLI is a callable SQL interface based on the X/Open CLI specification, compatible with Microsoft Corporation's ODBC.
• The Administration Guide: Implementation provides information on authorization and the Administration Guide: Performance has information on tuning application performance.
• The Application Building Guide provides environment setup information and step-by-step instructions on how to compile, link, and run DB2 applications.