Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Re-use deleted records in a file

I've got a problem in re-using the deleted records in a file. In order to get rid of the need to re-organize a physical file and keep the file size under control, I set the REUSEDLT parameter to *YES. However, I find that new records are still appended at the end of the physical file regardless of the existence of a large number of deleted records in the file. Thus the file size cannot be kept under control.

I have, for a long time, used "re-use". I have not had problems with it and deleted records space has been re-used. Maybe you should first reorganize your files before starting your job. There are circumstances where "re-use" would appear not to work. For instance, if an application creates thousands or temporary records and deletes all but a few, at the end of the file, it will look as if re-use did not work.


Search400's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.