Ansicht
Dokumentation

RSDB4SQR - iSeries: SQL Requests

CL_GUI_FRONTEND_SERVICES - Frontend Services   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Description

This program displays the following information about SQL statements:

• The 50 slowest statements recorded by the memory-based SQL database monitor (program parameter TOP50 = 'Y')

• All statements recorded by the memory-based SQL database monitor corresponding to the selection set specified by the user (program parameter TOP50 = 'N')
  The list is sorted in descending order by the maximum execution time of the statement.

The data displayed is collected by the function module ST04_DB4_GET_SQR_INFO.

Use

RSDB4IDA is used in transaction ST04, Detail analysis.

Requirements

This program is only used in SAP systems running on IBM iSeries.

Output

This program displays information about SQL requests of the 50 slowest statements or alternatively all statements corresponding to a user-specified selection set.

Database Files Accessed

SQ1000_DB4

PERFORM Short Reference   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 1195 Date: 20240520 Time: 122922     sap01-206 ( 19 ms )