SQL/MP / Statement                            see System Quirks

 

 

The SQL/MP / Statement screen presents the MEASURE SQL Statement entity on a process(es) accessing data via SQL/MP statements.

 

The SQL Statement entity describes the cost in terms of CPU and I/O associated with the SQL statements in a process.

 

Note: In order to use this screen, it is necessary to obtain an SQLMAP listing from the SQL compile of the program being examined.  This map provides a reference to the Run Unit name and Index.  This information is necessary so that the SQL statements in the program can be identified.