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 /[email protected]/x_lansa/lobuser/[username]/
- In V13 SP2, the LOB directory is typically located in /[email protected]/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.