Ansicht
Dokumentation

04778 - Reorganizing SAP tables

04778 - Reorganizing SAP tables

CL_GUI_FRONTEND_SERVICES - Frontend Services   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Reorganizing SAP tables

Hi Chris,

APQD is as I know of the table for the batch-inputs. This table should grow
each day or weak to its peak and should then stay there if you always delete
the old batch-inputs , as the new ones reuse the records.

So, you only "win" the space for about a day or perhaps a week, as you
already mentioned.

Regards

Volker

> -----Original Message-----
> From: Sugg, Chris [mailto:cgcsuggZn...]
> Sent: Freitag, 25. Januar 2002 14:49
> To: 'DoNotReply@consolut.eu'; 'mdmsystemsZe...'
> Cc: sap400Zm...
> Subject: RE: Reorganizing SAP tables
>
>
> Hello Volker.
>
> We have a re-org job for all 3 databases. The problem that we
> have is with
> table APQD. With the enormous amount of interfaces that we
> process daily
> and SM35 jobs, the file gets populated quickly. We have the
> SAP job to
> delete records and do the reorg from within SAP but the file
> always has an
> object lock on it. With this lock, the deleted records space
> was never
> being reclaimed. Since the reorg job, the file has gotten better.
>
> Reguards,
> Chris
>
> -----Original Message-----
> From: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
> Sent: Friday, January 25, 2002 1:10 AM
> To: 'mdmsystemsZe...'
> Cc: sap400Zm...
> Subject: RE: Reorganizing SAP tables
>
>
> Hi Matt,
>
> dod you really think, that you "win" a lot space with this
> weekly schedule,
> especially if you tell that the 10-20 "top" tablesare always
> the same ?
> I think, these are just the tables, that get new records and then get
> deleted complete because they are e.g. interface-tables. I
> think, it would
> be very interesting, what happens, if you get rid of RGZPFM
> one week and
> have a look, if after 2 weeks, the deleted stuff got doubled
> or was nearly
> the same.
>
> If it was nearly the same, this would indicate, that this is
> just normal
> systembehaviour and nothing is increasing here.
>
> Please keep in mind, that we are using REUSEDLTRCD(*YES).
> That means, that
> at least most of the records should become reused instead of
> staying around
> for weeks and increasing the amount of deleted records.
>
> What are the tables and how do they behave in 1 week and in 2 weeks ?
>
> Thanks
>
> Volker
>
>
> DoNotReply@consolut.eu
>
> Your use of consolut is subject to
http://www.consolut.net



DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net


Durban Tours - Südafrika Safari

BAL_S_LOG - Application Log: Log header data   General Material Data  
This documentation is copyright by SAP AG.

Length: 4544 Date: 20240621 Time: 073856     sap01-206 ( 3 ms )