SAP on MaxDB - cleanup tables

[Former Member]

Hi

I'm looking to cleanup our current MaxDB database to reduce the size, Current DB size is 970 GB.

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 someone kindly assist with step/documentation on how (and if) I can cleanup these tables.

Best Regards

Willem

[JamesZ · Accepted solution]

Hi Willem,

Maxdb uses B*tree to store data, which does not need reorganize to clean any table.
The only way to clean a table is from application perspective. You have to discuss with your application colleagues to consult which table entries can be cleaned or if there is any application report can do this.

Best regards,
James

[CLOEFFLER]

Hi Willem,

check out note 706478 which will give you hints how to reorganize

SAP "Basis Tables" from an application point of view.

http://service.sap.com/sap/support/notes/706478

Kind Regards,

Carsten