How to read ST03N datasets from DB

[AndreasVogel]

Have you ever asked the question "Who uses all these Z* reports? Are they used at all?" Well, ST03N could give you the answer, but sometimes you might get the result in a more condensed format. So you implement your own report to utilize the aggregated statictical records of ST03N calculating your own metrics and reports.

With NetWeaver 2004s (SAP_BASIS 700) a new API is available. The function SWNC_COLLECTOR_GET_AGGREGATES provides all the tables used by ST03N. Implementing a small program you can read the data, and extract whatever you are interested in. The code snippet shows you the basic steps.

Let's have a short look at the interface of the function module. Before you can use this function you need to know the parameters. And you might read the documentation provided with the function in the ABAP workbench.

FUNCTION swnc_collector_get_aggregates .*"----------------------------------------------------------------------*"*"Lokale Schnittstelle:*"  IMPORTING*"     VALUE(COMPONENT)    TYPE  SWNCHOSTNAME*"     VALUE(ASSIGNDSYS)   TYPE  SWNCSYSID DEFAULT SY-SYSID*"     VALUE(PERIODTYPE)   TYPE  SWNCPERITYPE*"     VALUE(PERIODSTRT)   TYPE  SWNCDATUM*"     VALUE(SUMMARY_ONLY) TYPE  SWNC_CFLAG DEFAULT SPACE*"     VALUE(FACTOR)       TYPE  SWNCDIVFACTOR DEFAULT 1000*"  TABLES*"      TASKTYPE STRUCTURE  SWNCAGGTASKTYPE OPTIONAL*"      TASKTIMES STRUCTURE  SWNCAGGTASKTIMES OPTIONAL*"      TIMES STRUCTURE  SWNCAGGTIMES OPTIONAL*"      DBPROCS STRUCTURE  SWNCAGGDBPROCS OPTIONAL*"      EXTSYSTEM STRUCTURE  SWNCAGGEXTSYSTEM OPTIONAL*"      TCDET STRUCTURE  SWNCAGGTCDET OPTIONAL*"      FRONTEND STRUCTURE  SWNCAGGFRONTEND OPTIONAL*"      MEMORY STRUCTURE  SWNCAGGMEMORY OPTIONAL*"      SPOOLACT STRUCTURE  SWNCAGGSPOOLACT OPTIONAL*"      TABLEREC STRUCTURE  SWNCAGGTABLEREC OPTIONAL*"      USERTCODE STRUCTURE  SWNCAGGUSERTCODE OPTIONAL*"      USERWORKLOAD STRUCTURE  SWNCAGGUSERWORKLOAD OPTIONAL*"      RFCCLNT STRUCTURE  SWNCAGGRFCCLNT OPTIONAL*"      RFCCLNTDEST STRUCTURE  SWNCAGGRFCCLNTDEST OPTIONAL*"      RFCSRVR STRUCTURE  SWNCAGGRFCSRVR OPTIONAL*"      RFCSRVRDEST STRUCTURE  SWNCAGGRFCSRVRDEST OPTIONAL*"      SPOOL STRUCTURE  SWNCAGGSPOOL OPTIONAL*"      HITLIST_DATABASE STRUCTURE  SWNCHITLIST OPTIONAL*"      HITLIST_RESPTIME STRUCTURE  SWNCHITLIST OPTIONAL*"      ASTAT STRUCTURE  SWNCAGGAPPSTAT OPTIONAL*"      ASHITL_DATABASE STRUCTURE  SWNCHITLISTAPPL OPTIONAL*"      ASHITL_RESPTIME STRUCTURE  SWNCHITLISTAPPL OPTIONAL*"      COMP_HIERARCHY STRUCTURE  SWNCAGGCOMPHIER OPTIONAL*"      ORG_UNITS STRUCTURE  SWNCAGGORGUNIT OPTIONAL*"      DBCON STRUCTURE  SWNCAGGDBC OPTIONAL*"      VMC STRUCTURE  SWNCAGGVMC OPTIONAL*"      WEBSD STRUCTURE  SWNCAGGWEBDEST OPTIONAL*"      WEBCD STRUCTURE  SWNCAGGWEBDEST OPTIONAL*"      WEBS STRUCTURE  SWNCAGGWEBCLNT OPTIONAL*"      WEBC STRUCTURE  SWNCAGGWEBCLNT OPTIONAL*"      ESI STRUCTURE  SWNCAGGESI OPTIONAL*"      ESISUM STRUCTURE  SWNCAGGESISUM OPTIONAL*"  EXCEPTIONS*"      NO_DATA_FOUND

The parameter COMPONENT is used to specify the application server. Use the name TOTAL if you want to get the data of all application servers.

The Parameter ASSIGNDSYS is optional. Leave it empty, or specify the SYSID of your system.

PERIODTYPE specifies the type of the period you want to analyze. Valid values are D for days, W for weeks, and M for months.

PERIODSTRT is a date. Specify the day you are interested in.

The parameter SUMMARY_ONLY is optional. Specify an X if you just want to read the table TASKTYPE.

Parameter FACTOR is optional. The default value is 1000. This is used to scale all time metrics from microseconds to milliseconds. Leave it as it is.

Table USERTCODE

This table has four key fields: TASKTYPE, ACCOUNT, MANDT, and ENTRY_ID. TASKTYPE is a byte which can be decoded using CL_SWNC_COLLECTOR_INFO=>TRANSLATE_TASKTYPE, and ENTRY_ID contains the transaction code or a report name. The code snippet shows how this can be decoded. As data fields the table contains metrics like response time, cpu time and many others.

Authorization

The ST03N data contains user names. You will need the profile S_TOOLS_EX to see all the user names, otherwise the user names will be encrypted.

Related Weblogs

[1]Code snippet: Which Z* reports are used?

[2] Statistical Records Part 1: Inside STAD

[3] Statistical Records Part 2: RFC Statistics

[4] NW2004s Workload Statistics Collector: Implementing a BAdI as user exit