SQL Language Guide > SQL Language Guide > SQL Statements > CALL X100 > CLEANUP_UNUSED_FILES Command
Was this helpful?
CLEANUP_UNUSED_FILES Command
The CLEANUP_UNUSED_FILES command scans all locations recursively to find files that do not belong to any tables. It renames such files by adding "unused_" prefix. This system command can be executed on a working system.
You should remove these unused files only after making sure that the system is running correctly.
This command has the following format:
CALL X100(CLEANUP_UNUSED_FILES)
Note:  CLEANUP_UNUSED_FILES is designed to be used in cases where files are not deleted due to a crash or bug. It does not mark unreleased files that may still be needed by a transaction. So using this system call may not help you to free space if there are long-running or hanging transactions in the system.
Last modified date: 11/09/2022