Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A



How can i check in system (ERP2005) when needs to be done a table reorganization.



Former Member
Former Member replied


first off all you need to now the table usage. Please see notes 554031 & 821687 to gather table and indexes statistics.

If you run the statistics as it is documented in note 554031, indexes will be locked and you cannot update/insert into tables because of "validate structure".

If you want to now the table usage you can run the following command:

brconnect -u / -c -f stats -t all --f allsel,collect,method,space -p 15

this will collect the statistics only for tables and you can run it during the day.

After that you can see the brconnect log to know the tables and you can also check tables DBSTATTORA DBSTATIORA.

you can also see tables statistics via DB02 or DB02OLD (detail analysis).

Usually tables with a "Total free space %" value of 15%-20% could be reorganized, and with more that 20% should be reorganized.


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question