cancel
Showing results for 
Search instead for 
Did you mean: 

Tables used by ST02, ST04, ST06 and ST07

Former Member
0 Kudos

Hi Everyone,

Anyone knows the tables used by ST02, ST04, ST06 and ST07 which similar to ST03N, I can get to query them directly for performance statistics?

( Debasis, any advice on this?)

Thank you.

Regards

Hwee Seong

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

the tables are:

ST02: MONI

ST04: MONI

ST06: OSMON (for last 30 days), MONI (for the hour values of the last 30 days)

ST07: MONI

ST03: MONI (until release 6x), SWNCMONI (since release 7x)

But you will not be able to extract the data directly from the MONI table as the values are stored in a long raw field. Each kind of data has its own structure and only the reports and function modules of the mentioned transactions will be able to read the data and convert it to the correct structure.

Exception: the workload data (st03) can be accessed as described in the [note 1053634|http://service.sap.com/sap/support/notes/1053634].

Regards, Michael

Former Member
0 Kudos

Thanks guys! Appreciate all the response. Btw, are there anyway to convert the long raw field to something readable? Any hints that I can do a further research on it?

Thanks!

Regards

Hwee Seong

debasissahoo
Active Contributor
0 Kudos

Hi Hwee Seong

you might find this blog useful.

Debasis.

Answers (3)

Answers (3)

former_member66264
Contributor
0 Kudos

Hi,

An intermediated solution might be to setup the EWA in solman and transfer the data to BW.

You can add CPH data if you need specific things

There you have a bit more options.

What exactly are you looking for?

former_member183872
Participant
0 Kudos

Hi Hwee Seong

Program for ST02 : RSTUNE50

It uses the below tables:

TABLES: TUNEHD, "statistic about SAP buffers

TUNEHD64, "statistic about SAP buffers

DBSTATITEM, "statistic about buffered tables

SAPBUFQUAL, "SAP buffer qualities

RFCDES. "RFC destinations

I am also looking for the tables used for other statistical data.

If you got the information, could you please share with us.

Thank you.

Regards,

Anuj Nigam

debasissahoo
Active Contributor
0 Kudos

Hi Hwee Seong,

These tcodes reads the data as collected by the SAPOSCOL.

For more details about this, follow the link

http://help.sap.com/saphelp_nw70/helpdata/EN/c4/3a6bff505211d189550000e829fbbd/frameset.htm

Regards,

Debasis.

Former Member
0 Kudos

Thanks for replying. From what the resources, it seemed to be reading from MONI table for ST06 and OS07.

Any ideas for ST02, ST04 and ST07?

Regards

Hwee Seong

debasissahoo
Active Contributor
0 Kudos

ST06/OS06 - directly takes from SAPOSCOL. for this no data from MONI table. MONI stores the statistical data.

As you might be knowing..OS07 is similar to OS06, but its for global os monitoring.

I just checked for ST07.. it runs the report SAPMS07A. may be you can investigate a little more..

Regards,

Debasis.