Removing Deleted Record on AS400 Physical File

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.

Pastikan tidak ada locking pada File yang akan di reorganize.

RGZPFM with Share Update, is used if the file to be reorganized has a continuous locks and requires downtime to release the locks.

Leave a Reply