Description
This program displays all tables that contain deleted records. It can beused to decide which tables to reorganize to free disk space.
The following information is displayed:

• Name: The name of the table.


• Rows: The number of rows that currently exist in the table.


• Deleted rows: The number of rows currently marked as deleted.


• %deleted: The percentage of deleted rows.


• Row length: Length of a record in bytes.


• Deleted bytes: The total disk space in bytes that is used by the
deleted records. This amount of space could be freed by reorganizing.

Further information
The SQL-DELETE operation only marks rows as deleted (They are notphysically removed by the DELETE statement). As a result, a lot of spacemight be wasted. To eliminate deleted rows, use the Reorganize PhysicalFile Member (RGZPFM) CL command to eliminate deleted rows.

Precondition
This program is only used in SAP systems running on IBM iSeries.

Technical-info
With the exception of the record length, this data is collected from thetable DBSTATTDB4. It is collected using EXEC SQL from the tablesystables, since there is no SAP table which contains the record length.The table DBSTATTDB4 is filled by the report 'RSDB4090'
.