Troubleshooting Guide

Chapter 5. Troubleshooting Applications

Applications are the means by which most users will 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:

• For updated information on developing applications for DB2, refer to the Application Development with DB2 Universal Database website at http://www.software.ibm.com/data/db2/udb/ad . This web site includes the latest information on developing applications for DB2 Universal Database using the embedded SQL, Java, or CLI/ODBC APIs.
• Application Development Guide and http://www.software.ibm.com/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).
• Administrative API Reference provides information on the use of application programming interfaces (APIs) to execute DB2 administrative functions.
• CLI Guide and Referenceprovides 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.
• Administration Guide, Design and Implementation provides information on authorization and Administration Guide, Performance has information on tuning application performance.
• Application Building Guide provides environment setup information and step-by-step instructions on how to compile, link, and run DB2 applications.

[ DB2 List of Books | Search the DB2 Books ]