Ansicht
Dokumentation

00736 - DBSTATDB4

00736 - DBSTATDB4

General Material Data   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

DBSTATDB4



You need to schedule a job to execute program RSDB409C with variant.
Weekly is suggested.

The file names to check afterwards for number of deleted records are
DBSTATHDB4 and
DBSTAIHDB4 in R3<SID>DATA.

Reorg will get you the wasted space back. If you cant reorg (due to need to
stop SAP first) the file is managable if you run the above ABAP regularly
(eg. a Production system running SAP for one year without any reorgs has
DBSTATHDB4 of 162 MB with 506,000 records, 185,000 deleted records.)

Regards,

Michael Power
SAP Basis Consultant (iSeries400)
Data#3 Limited

EMail: Michael_PowerZd...





H Chan <hchan28Zy...> on 09/02/2001 05:15:45 AM

To: sap400Zm...
cc:

Subject: DBSTATDB4


The table DBSTATDB4 is taking up 7% of our R/3 data
library. Can I safely clear this table, or is there a
cleanup program I can run to do this.
Is there a way to stop this table using up so much
space again?

__________________________________________________
Do You consolut?
Get personalized email addresses from consolut Mail - only $35
a year! http://personal.mail.consolut.net/





Durban Tours - Südafrika Safari

General Data in Customer Master   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 2036 Date: 20240426 Time: 061245     sap01-206 ( 3 ms )