Error Information report The Error Information report provides information about any SQL statement error messages and warnings that were captured by the monitor as shown in Figure 5-35. Figure 5-35 Error Information report If you receive an error message from your application, the error information report provides SQLSTATE and SQLCODE. From these messages, you can analyze and correct errors. Start and End Monitor Information report The Start and End Monitor Information report provides information about any start and end Database Monitor operations. This option is available only when you use a detailed SQL Performance Monitor. 5.3 Modifying a predefined query report The SQL Performance Monitor also lets you retrieve the SQL statements of any of these reports to use as a starting point for creating your own analysis reports. Although the predefined queries can be materialized and customized, at first glance, they can be very intimidating. Even power SQL users might be somewhat reluctant to make changes to these statements. This section explains how you can modify predefined queries and make your own reports. Notice that the original query used by iSeries Navigator is not changed. You go step-by-step through the process to customize a predefined query in iSeries Navigator. Chapter 5. Analyzing database performance data using iSeries Navigator 119