Kontakt

Ansicht
Dokumentation

05189 - DBMON / ST04 Data - Where is it and what contr ols it?

05189 - DBMON / ST04 Data - Where is it and what contr ols it?

PERFORM Short Reference   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

DBMON / ST04 Data - Where is it and what contr ols it?

Hi Blake,

1) the data is stored mostly in the following tables:
SQHVAR_DB4
SQTEXT_DB4
SQ1000_DB4
SQ1000_RST
SQ3000_DB4
SQ3001_DB4
SQ3002_DB4
SQ3003_DB4
SQ3004_DB4
SQ3007_DB4
SQ3008_DB4

2) The DB-Monitor settings collects the data, if active ( as4/dmon/enable=1
) and fills up the above described tables.

3) It becomes deleted after each IPL of the DB-Server automatically (at
least if the DB-monitor is on then). This is necessary, because after an IPL
the keys could become duplicate.

Regards

Volker

> -----Original Message-----
> From: bfbray [mailto:blakebrayZp...]
> Sent: Montag, 25. Februar 2002 15:56
> To: DoNotReply@consolut.eu
> Subject: DBMON / ST04 Data - Where is it and what
> controls it?
>
>
> Where is the data which is accumulated under DMBON? The data is
> displayed with ST04. My ST04 is very slow, when I reset the
> statistics it takes 30 minutes and dislaying the data since the last
> reset is also very slow. I'm trying to run with the DBMON turned off
> to see if it helps overall system performance. I'm curious as to the
> whereabouts of the data collected by DBMON. Can someone answer the
> following questions:
>
> 1. What tables is this data stored in?
> 2. What controls this data? Does this data get summerized or deleted?
> If so, how?
> 3. Are there archive definitions in place to get rid of the old data?
>
>
>
> ------------------------ consolut Sponsor
> ---------------------~-->
> Sponsored by VeriSign - The Value of Trust
> Pinpoint the right security solution for your company - FREE
> Guide from industry leader VeriSign gives you all the facts.
> http://us.click.consolut.net/lWSNbC/WdiDAA/yigFAA/dkFolB/TM
> --------------------------------------------------------------
> -------~->
>
> Have a look to our homepage at: http://www.consolut.net
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to
http://www.consolut.net


 Durban Tours - Südafrika Safari

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 3175 Date: 20240427 Time: 045401     sap01-206 ( 2 ms )