Solution : https://service.sap.com/sap/support/notes/84081 (SAP Service marketplace login required)
Summary :
After archiving data or deleting a client in SAP environments, database tables may not show a reduction in size despite the deletion, particularly in tables containing BLOB, CLOB, or DBCLOB types. This occurs because space from deleted records is marked for reuse rather than immediately freed. Reorganization of these tables can be executed using the RGZPFM command, which supports both online and offline modes. Online reorganization allows live table usage during the process, which may lead to potential data inconsistencies, while offline mode requires system downtime but ensures data integrity and supports reorganization of frequently used tables. Note that some system restrictions apply, particularly with older OS versions and specific data types.
Key words :
offline reorganization general information, online reorganization general information, reorganize physical file member, archived larger amounts, transaction db02 shows, undergo frequent record, release-specific restrictions, longer required immediately, inaccuracy strongly depend, error message mch3 203
Related Notes :
| 814189 | iSeries: COMPUTE_BCD_OVERFLOW in RSDB4DLT |
| 750208 | iSeries: Short dump SUM_OVERFLOW in GET_DB4_DELETED_RECORDS |
| 534036 | SAP LT: System settings for conversions |
| 173993 | Cluster: System settings during Euro LC changeover |
| 121245 | System settings for local currency changeover to euro |