Deleted Space from [email protected] currently not being reused

Date: 16 September, 2005
Product/Release: LANSA for the Web
Abstract: You must change the file [email protected] so that it's deleted space is not wasted
Submitted By: LANSA Technical Support
LAst Review: December 2010

LANSA for the WEB uses a file located in QGPL called [email protected] That file was created with the parameter Reuse deleted records (REUSEDLT) set to *NO. This means that when [email protected] records are deleted, the space those records were using will not be made available for other records to be inserted. Records in [email protected] are created and deleted many times.

Customers should change [email protected] so that it it reuses it's deleted space. To do this you can execute the following AS/400 command:

CHGPF FILE(QGPL/[email protected]) REUSEDLT(*YES)

The next time you run a LANSA reorg the deleted space will be reclaimed. Alternatively you may choose to execute the AS/400 command RGZPFM to reorganize [email protected] If so, please remember before executing either the LANSA reorg or the RGZPFM command to:

  1. Run a LANSA cleanup of the system
  2. Stop the Web server