DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide

Debugging Application Programs

Many sites have guidelines regarding what to do if your program abends. The following suggestions are some common ones.

Debugging Programs in TSO

Documenting the errors returned from testing helps you investigate and correct problems in the program. The following information can be useful:

• The application plan name of the program

• The input data being processed

• The failing SQL statement and its function

• The contents of the SQLCA (SQL communication area) and, if your program accepts dynamic SQL statements, the SQLDA (SQL descriptor area)

• The date and time of day

• The abend code and any error messages

When your program encounters an error that does not result in an abend, it can pass all the required error information to ...