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

Very slow access to tabel RSBATCHDATA

Hi guru's, I have a problem with a BW system. I see in SM66 that accessing the table RSBATCHDATA takes a very long time and involves sequential reads. With transaction SM50 I can see that the table is queried with the following command:

SELECT
  "BATCH_ID" , "TIMESTA
FROM
  "RSBATCHDATA"
WHERE
  "RELID" = :A0#

The funny thing is that this table has the following key:

RELID
BATCH_ID
BATCH_PROCESS
METHOD
TIMESTAMP
SRTF2

Therefore I would expect that access to this table should be very fast. Nevertheless, the system that I work with shows me 1205 seconds (and still counting while I write this) and "Sequential read".

Can someone explain this to me? Furthermore: is there a whitepaper about the detailed screen that you see when you double-click a line in SM50.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 11, 2011 at 02:40 PM

    Jans,

    I am not sure but this might be worth a try...

    Check the size of the table and see if it can be archived - an index scan on a 1 GB ( for example ) table will still take time...!!!!

    Check if there is any archiving that can be done for this table

    Check the number of entries in this table - if the table is too large - then you might have to archive this

    Check post : Database growing rapidly

    Also this table is related to data load monitor tables - see if you can implement request archiving if you are on BW7.0 and above

    Add a comment
    10|10000 characters needed characters exceeded

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.