ASP full

[Former Member]

My sap system ERP DEV have 93 % used in ASP, I delete a client that no used. But the ASP up at 95 %, My question is, Then that deleted a client or data, Should I perform the database?? If yes, How I can perform in Iseries V6R1M0?, and How I have that the ASP down??

Regards

William Neira

[christian_bartels · Accepted solution]

If you delete a client, the rows in the tables are only marked as deleted (for later reuse), but the allocated space is not actually freed. To free up space, you may consider reorganizing tables as described in SAP Note 84081. Please note that the offline reorganization can free more space than the online reorganization.

Kind regards,

Christian Bartels.

[Former Member · Accepted solution]

but I must reorganizated the table one per one?? what tables should reorganizate then deleted client??

thanks

William Neira

[christian_bartels · Accepted solution]

You can use transaction DB02 (order by deleted rows / wasted space) to identify the tables where reorganization returns the most space. SAP Note 84081 also has the source of a CL program attached that can be used to reorganize all tables with more than a certain number of deleted rows in a nightly batch run.

Kind regards,

Christian Bartels.

[Former Member · Accepted solution]

Many thanks The Question is answered.