Skip to Content
author's profile photo Former Member
Former Member

buffer and sql trace increasing space of tracefile??

hello all,

under ST05 you can switch on buffer and sql trace.

The tracefile in my system has nearly 16MB space only, which means that in large systems with many users, the trace file gets filled in a few minutes or seconds. This results from the activity of hundreds of users.

For sure you can also define a special user group or exlude tables from the trace, which makes it possible to trace some more seconds. For me, this is not enough.

Is it right, that the SAP must be restarted if I would like to increase the size of a tracefile or rather adjust the corresponding parameter?

Is there any other chance to trace as many queries and changes as possible on another way?

do you have any ideas?

thanks in advance,

holger

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2005 at 02:48 PM

    Hi Holger,

    To increase the tracefile size parameter rstr/max_diskspace you will have to stop and restart your SAP instance. Check OSS 25099.

    As an alternative see this

    "If you need to create a large trace file for a customer and if immediate

    evaluation is not possible or does not make sense, you can use operating

    system tools to save the trace file for subsequent analysis."

    in OSS 671714.

    Cheers.

    Sanjay

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Holger,

      Yes I agree. In a production system you will not be able to increase tracefile size unless you can find a window to stop and start the SAP system.

      Even if you copy the trace file ( by a script at OS level ) to another file at regular interval and then refresh the existing trace file , the problem is how would you analyze these individual files as ST05 will only b able to analyze TRACE00 file. So even if you have backup of old files you will have to manually copy them to TRACE00.

      So the best option is to restrict the filter intutively by selecting the most culprit tables / transactions.

      Cheers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.