see System Quirks
The SQL/MP / Statement screen provides a way to drill-down further within a process that uses SQL to see the level of activity performed by individual SQL statements. This information is obtained from MEASURE via the SQLSTMT entity.
The SQL Statement entity describes the cost in terms of time and I/O associated with individual SQL statements in a process. The statements are identified by an Index (0,1,2,3, etc...) obtained from a listing during SQL compilation (specify the SQLMAP option to SQLCOMP).
To use this screen, find a busy SQL application process on your system, perhaps from the Overview screen. Enter the process name (or CPU,PIN) in the Process Name field and push request. After 30 seconds or so, if the process is active and using SQL/MP statements, the results are displayed. The screen continues to update with progressively longer update intervals.
Generally, in order to interpret the output for this screen, you need to work with your DBA and/or application developer as the SQL Statement index is obtained during program compilation. Even with the statement index, usually only the application developer and/or DBA could determine if the SQL statement is executing as intended (knowledge of the data layout, meaning of the data and accesses available into the data really help).
If you are dealing with SQL/MX, things get a little strange as SQL/MX has the requirement that an SQL Statement measurement must be in place prior to starting the program. This is really backward (and does not make much sense to us) but in theory allows reduced measurement overhead. SQL/MX really did things differently from a historical NonStop perspective. Unfortunately, it may be better to a) run MEASURE manually to collect the data OR b) manually start an external measurement and then go into this screen within MOMI. In the latter case, the measurement that MOMI launches is internally "latching into" an existing measurement which allows data to be obtained.
This screen is disabled by default. See the CONFMOMI keyword DISABLE-MEAS-SQLSTMT for additional information.