DB2 Database cleanup

Source: Internet
Author: User
Tags db2 connect db2 connect to
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.