DB2 log Processing: requires that you must use the DB2 command prune for cleanup, and the RM command is not recommended for deletion. View the current log file directory and the first activity log file , use the DB2 get DB CFG |grep log command to view the file directory parameters, determine the current log file directory used by the database, and view the first activity log file parameters. The log files before the corresponding log files for this parameter are archived logs and can be deleted if the confirmation is not used. For example fist active log file=s0015913. Log, which indicates that the current first activity log file is S0015913. LOG. Delete Archive log to apply user login, execute: 1.DB2 connect to dbname 2.db2 Prune logfile prior to S0015913. LOG. This command removes all archive log files before the current first active log file.
DB2 Database cleanup