topic Re: How to archive Workload analysis data in Application Development and Automation Discussions

How to archive Workload analysis data

Former Member — Thu, 02 Apr 2009 10:53:17 GMT

Dear all my friends,

I need to check the workload data(who execute which t-code on when) in R/3 system.

as i know, there are only 3 months historical data is archived.

so, i want to copy workload data into Ztable for archived purpose.

currently, i only know table MONI, but i don't where the workload data is stored ?

please help to show me the table name.

thanks !

Re: How to archive Workload analysis data

Former Member — Thu, 02 Apr 2009 13:14:20 GMT

hi,

I can't the get the exact requirement of yours,

but check the tcodes SARA and FILE for archiving purposes.

Regards,

R K.

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 02:40:25 GMT

Hi,

What do you mean be Workload data?

My understanding with your question, Archiving of data is happening regularly considering 3 months of residence time.

1. Now you want to keep all the data that are archived into custom table and then tell the archiving team to archive the data from the custom table not from the standard tables?

2. You will copy a data that are archived into custom table and tell your business team to work on custom table?

In Question no1. You can't do it, all the archiving object that are in the progress are very well tested with the all standard tables that are been archived.

If you force them to do archiving by custom table not from standard table then they have to come with Custom archiving object.. More over there will be no point in archiving of data. Because Data Archiving is implemented to take care of your database and to reduce the cost of new hardware, and to maintain performance.

In this scenario, basic principle of archiving will be failed.

Question no2. From the business side, it requires lot of development of programs so it is also not advisable.

To overcome this type of situation SAP has provided Archiving Information system

This helps in retrieving archived data from your archive server. Talk to your archiving team to fetch all the required data when ever it is required. This archive data can be displayed only but not changeable.

Let me know, if it answers your question.

-Thanks,

Ajay

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 03:28:55 GMT

Dear Ajay and R.K

your answer is very helpfull for me.

from my point of view "workload data" mean : the log data of which user id, execute which t-code, on when ?

i can see the data by t-code ST03 -> database peformance

my concern is : my current system only allow me to view last 3 months data only.

but i want to see the data from last 2 years --> can we make any configuration to change ?

if not, i plan to create Ztable to archive data by 3 months.

please help to show me to right way !

thanks !

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 05:00:06 GMT

hi,

Have u checked the tcodes ,

in SARA tcodes u can archive the data from table also by using the pushbutton database tables,

in tcode st03 check from which tables data is coming,

(or) then write a zprogram to display the reqired

data form the tables and insert the data zdbtable or schedule it .

Regards,

R K.

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 06:00:09 GMT

Dear my friend,

The most important thing i need you to help me is :

i don't know where the workload data is stored !

example of workload data :

my userid : Luc, today 03-Apr-2009, i have executed t-code SE38.

i think, there is a table store this log data. i call it workload data.

so, please help to show me the table name or how system store workload data.

thanks !

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 06:28:42 GMT

Dear,

Please follow the step were you can mention 24 months

Goto- ST03 >>Collector and Performance database >> Performance Database >>Monitor database >> Reorganization

In this place if you mention retention period as 24 months then after 2 years your Workload data will be deleted from the database.

Hope this has answered your question.

-Thanks,

Ajay

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 07:16:35 GMT

Dear Ajay,

thank you so much for your sharing !

it's right,

I am now using R/3 4.6C version, so i can not find the path as you talk.

do you have document on this section, please share me.

addition on this, our end user need to copy workload data into Ztable because they afraid that standard data can be deleted by other team who they can not control them.

so, i need to find out which table do i need to copy data from too.

may thanks !

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 09:28:18 GMT

hi,

execute st03,

system --->status

in that u can see program name try to find out from which tables the data is coming.

Regards,

R K.

Re: How to archive Workload analysis data

Former Member — Fri, 03 Apr 2009 11:08:02 GMT

Hi,

Sorry, In 4.6c version i don't have idea, belive that it should be easy to identify.

I don't have tables information related to this program or transaction.

There are many ways to check the related tables, however Tracer will provide you better information of the related tables.

1. Please run Tracer, when you execute the ST03 transaction and try to identify the related table that are being affected.

2. Then check all the table entries to know major or main information sits

3. Cross check with user is that table information is sufficient or they want to have more information from different tables

4. For those tables you can think of Creating custom tables of all the relevant tables

5. Create custom archiving object to archive these information.

As you know there are many way to check the tables related to a proram so i prefer you to go with new posting of asking specific question to trace tables, then you may get lot of useful & helpful answers for our forum mates. Then plan custom table and custom archiving objects.

Thank You!

With Regards,

Ajay

Edited by: Ajay Kumar on Apr 3, 2009 1:25 PM

Re: How to archive Workload analysis data

Former Member — Fri, 08 May 2009 05:44:16 GMT

Hi,

Steps to follow in a 4.6 system...

ST03 -> Performance Database -> Choose server name will pop up -> Choose the period you want -> Choose the profiles you want, in this case transaction profile.

Regards, Jatin