When an error occurs in a UAP, the troubleshooting functions can be used to investigate the cause of the error. The troubleshooting functions are as follows:

• SQL tracing
• Error logging
• Facility for output of extended SQL error information
• UAP statistical report facility
• Command trace facility
• SQL trace dynamic acquisition facility
• Reconnect trace facility
• Access path information file for HiRDB SQL Tuning Advisor

Organization of this section

10.1.1 SQL tracing

10.1.2 Error logging

10.1.3 Facility for output of extended SQL error information

10.1.4 UAP statistical report facility

10.1.5 Command trace facility

10.1.6 SQL trace dynamic acquisition facility

10.1.7 Reconnect trace facility

10.1.8 HiRDB SQL Tuning Advisor access path information file