on 02-26-2016 7:29 AM
Hi
I'm looking to cleanup our current MaxDB database to reduce the size, Current DB size is 970 GB.
SAP System is ABAP - SAP ECC 6.0 (EHP5).
These are the tables > 10 GB:
Table Name | GB | Description | |
CDCLS | 193 | ||
CDHDR | 105 | Change document header | |
N2PCDOC | 56 | IS-H*MED: Content of Word6 for Windows documents (DMS) | |
COEP | 46 | CO Object: Line Items (by Period) | |
GLPCA | 27 | EC-PCA: Actual Line Items | |
ACCTIT | 24 | Compressed Data from FI/CO Document | |
NTSP | 20 | IS-H: Columns in Service Catalog | |
VBRP | 17 | Billing Document: Item Data | |
MSEG | 16 | Document Segment: Material | |
NLEI | 16 | IS-H: Services Performed | |
DYNPSOURCE | 14 | Contains Screen Source Information (Compressed) |
I have not done a clean up previously. Can this be cleaned from BASIS side? Please assist with step/documentation on how (and if) I can cleanup these large tables.
Best Regards
Willem
Hi
Thanks for the responses.
To confirm, it seems like we will have to recommend a Data Archiving Solution to reduce the size of this database?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Willem,
Following Notes may also be helpful:
1591251 - CD: Archiving change documents
1257133 - CD: Archiving options for CDCLS
Regards,
Raquel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use Archiving Workbench for data archiving to ensure data consistency of objects. Refer also The Data Archiving Process (Archiving Workbench) - Overview of the Archiving Workbench - SAP Library
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.