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.
MORE INFORMATION ON THIS TOPIC
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)
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.