When we delete a record using SQL, the record does not actually disappear immediately from the table / file. There are several ways to delete a deleted record in a file, including:
Using the RGZPFM command, with exclusive lock. This command is suitable for processing files that are not locked continuously.
RGZPFM with Share Update, is used if the file to be reorganized has a continuous locks and requires downtime to release the locks.