RE:[sap-basis] Reorganize EDI40
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by D. Caddick (SAP NetWeaver/BASIS Consultant) on Mar 5 at 6:12 AM |  Mark as helpful |
Hi Della,
If you are sure you do not need them you can delete the files. I would backup the files to tape or another file system.
Regards
---------------Original Message---------------
From: SAP-Della
Sent: Thursday, March 04, 2010 4:34 AM
Subject: Reorganize EDI40
> Hi all
>
> After going live HR Module, SAP Support suggest to do reorganize table EDI40
> I do the reorganize using brtools but the table size on DB02 still the same.
> I'm googling and found that EDI40 is IDOCS table, and I have to archive it
> I run tcode SARA and choose write, after that our SAPMNT/<SID> full.. 100%, so I increase the file system size, adding 2 more GB now the filesystem is 72% used
>
> Then I run SARA again and choose Delete and now I'm running WE11 and SA38 report RSEXARCD
>
> But the filesystem size (sapmnt/<sid>) still increasing
>
> Can anybody help me how to remove idocs from database? and how to minimize the size of sapmnt/<sid>?
> I've found on sapmnt/<SID>/global there is huge archive file, like this
>
> -rw-rw---- 1 cayadm sapsys 104564761 Mar 03 15:46 BC_IDOC_20100303_153901_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 103990487 Mar 03 15:54 BC_IDOC_20100303_154517_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 103990489 Mar 03 15:55 BC_IDOC_20100303_154655_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 104692588 Mar 03 16:02 BC_IDOC_20100303_155400_0.ARCHIVE
>
> Thanks
__.____._ If you are sure you do not need them you can delete the files. I would backup the files to tape or another file system.
Regards
---------------Original Message---------------
From: SAP-Della
Sent: Thursday, March 04, 2010 4:34 AM
Subject: Reorganize EDI40
> Hi all
>
> After going live HR Module, SAP Support suggest to do reorganize table EDI40
> I do the reorganize using brtools but the table size on DB02 still the same.
> I'm googling and found that EDI40 is IDOCS table, and I have to archive it
> I run tcode SARA and choose write, after that our SAPMNT/<SID> full.. 100%, so I increase the file system size, adding 2 more GB now the filesystem is 72% used
>
> Then I run SARA again and choose Delete and now I'm running WE11 and SA38 report RSEXARCD
>
> But the filesystem size (sapmnt/<sid>) still increasing
>
> Can anybody help me how to remove idocs from database? and how to minimize the size of sapmnt/<sid>?
> I've found on sapmnt/<SID>/global there is huge archive file, like this
>
> -rw-rw---- 1 cayadm sapsys 104564761 Mar 03 15:46 BC_IDOC_20100303_153901_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 103990487 Mar 03 15:54 BC_IDOC_20100303_154517_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 103990489 Mar 03 15:55 BC_IDOC_20100303_154655_0.ARCHIVE
> -rw-rw---- 1 cayadm sapsys 104692588 Mar 03 16:02 BC_IDOC_20100303_155400_0.ARCHIVE
>
> Thanks
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. CaddickSAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
