Kontakt

Ansicht
Dokumentation

ST04_DB4_GET_STATISTICS - AS/400: Get Database statistics for ST04 Main Screen

ST04_DB4_GET_STATISTICS - AS/400: Get Database statistics for ST04 Main Screen

PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

The function module collects the data to be displayed on the initial screen of transaction ST04 in mySAP ERP on IBM iseries:

  • DATE and TIME of analysis: timestamp of current execution of this function module
  • structure DB_STATS comprises counts of executed SQL statements (such as number of selects or inserts) and counts about how these statements were executed (such as number of table scans or index creates performed).
  • WAIT_STATS_DATE and WAIT_STATS_TIME; timestamp of wait statistic analysis
  • SUM_WAITS, SUM_WAIT_TIMES, WAIT_STATS_SUMMARY: wait statistic information (summarized about all instances currently running) as computed by the function module DB4_GET_WAIT_STATISTICS.
  • DBMON_HEADER_INFO: information about DB Monitor activity as shown in the list header of ST04.

Example

An example on how to use this function module is found in RSDB400X (main program for transaction ST04 for mySAP ERP on IBM iSeries).

Notes

The database statistics are computed from the mySAP ERP performance tables, this data is collected by the IBM iSeries OS/400 memory based database monitor.

The wait statistics are cumputed in the function module DB4_GET_WAIT_STATISTICS.

Further information





Parameters

DATE
DBHOST
DBMON_HEADER_INFO
DB_STATS
RESETFLAG
SCHEMANAME
SUM_WAITS
SUM_WAIT_TIMES
SYSTEM_ID
TIME
WAIT_STATS_DATE
WAIT_STATS_SUMMARY
WAIT_STATS_TIME
WAIT_STAT_SUBRC

Exceptions

NO_DB_STATS_AND_WAIT_STATS_ERR
NO_DB_STATS_FOUND
WAIT_STATS_ERROR

Function Group

STU4_TCC

Vendor Master (General Section)   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 2245 Date: 20240523 Time: 101502     sap01-206 ( 43 ms )