Cleaning up the LOB directory using the special process *LOBCLNUP

Date:10 August 2011
Product/Release:LANSA for the Web - RDMLX only
Abstract:Use special process *LOBCLNUP to clear the LOB directory.
Submitted By:LANSA Technical Support
Updated:24 January 2018

When using BLOBs and CLOBs, temporary files are created in the LOB directory on the IBM i IFS. It's usage over time can build up to a large size.

  • In pre-V13, the LOB directory is typically located in /LANSA_dc@pgmlib/x_lansa/lobuser/[username]/ 
  • In V13 SP2, the LOB directory is typically located in /LANSA_dc@pgmlib/x_lansa/tmp/lobuser/[username]/ 
  • In V14, the *LOBCLNUP is generally no longer required as a cleanup is automatically performed when exiting LANSA. However, the cleanup will not be performed if there is an application failure or crash.  The *LOBCLNUP process can be run periodically to ensure that the temporary files left over do not keep accumulating.

To clear the temporary directory and reclaim space, execute the special process called *LOBCLNUP.

This can be called from the command line:

LANSA REQUEST(X_RUN) X_RUNADPRM('PROC=*LOBCLNUP')

The process needs to be run by a user with sufficient authority to remove files that may have been created by other users.

Consider using this special process as part of scheduled system maintenance.