Performing Deleted Records Analysis (IBM DB2 for i) 
When rows (or records) are deleted from a database table, the occupied space on disk is not actually freed but only marked as deleted. This space is then reused when adding rows later to the table. However, if many rows are deleted and few rows are inserted, the amount of space that is occupied by these deleted records can be significant.
To display information on deleted records, call transaction DBACOCKPIT.
In the navigation frame choose
Space 
State on Disk 
.Choose Deleted Rows.
The result is a list of tables that contain deleted records ordered by the number of deleted rows in descending order. The list also shows the total number of rows in the table, the row length, the total amount and the percentage of the space that is occupied by deleted rows.
Note
You should consider reorganizing tables that show a high number of deleted rows. Reorganizing the tables removes the deleted rows and saves disk space.
To reorganize a table you can use the operating system command RGZPFM (Reorganize Physical File Member).
Note
When used with the default parameters the command RGZPFM requires an exclusive lock on the table. You may not be able to reorganize a table while it is in use by an SAP system, and you may not be able to use a table from within an SAP system while it is being reorganized. To avoid locking conflicts, it is recommended to stop your SAP system prior to reorganizing a table.