Get rid of deleted records and improve performance

Get rid of deleted records and improve performance By John Kohan, Search400 expert

Run the command with the following parameters: "DSPFD FILE(FILELIB/*ALL) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(YOURLIB/YOURFILE)".

You can now query the data by running "RUNQRY *N YOURLIB/YOURFILE". Press F20 a few times, and you will see a column heading of "Deleted Records". This field will display the number of deleted records in each file. To calculate the approximate amount of space you will recover, take the number of deleted records and multiply that by the Maximum Record Length also found in the outfile.

Now that you have identified the files that are wasting space, the next step is to reclaim that DASD. IBM again provides a command to do that. The command is "Reorganize Physical File Member" (RGZPFM). This command will remove the deleted records, which will reduce the size of your Physical file. RGZPFM FILE(FILELIB/FILE).

[report a broken link by clicking here]