DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
The PRUNE LOGFILE command is deprecated and might be removed in a future release. The DB2PRUNE_ACTION_LOG value for the Action parameter of the db2PruneStruct data structure is also deprecated.
For databases with log retain enabled and archive logging is not enabled, you can issue the PRUNE LOGFILE command to remove log files from the active log path that are not needed for recovery purposes.
For databases with archive logging enabled, the database manager copies the log files to an archive location and removes them from the active log path as needed. You can use the PRUNE HISTORY command to remove log files from the archive location when they are no longer needed for recovery purposes.
Although you can use operating system commands to remove unnecessary log files, determining when it is safe to remove specific log files is not a trivial task. Instead, consider enabling your database for archive logging by setting database configuration parameter logarchmeth1 to USEREXIT, DISK, TSM, or VENDOR and use the PRUNE HISTORY command to remove log files from the archive location.