Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Understanding the DB flush feature in Officescan (OSCE) to address database corruption

    • Updated:
    • 26 Sep 2016
    • Product/Version:
    • OfficeScan 10.6
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Enterprise 64-bit
    • Windows 2003 Standard
    • Windows 2003 Standard 64-bit
    • Windows 2008 Enterprise
    • Windows 2008 Server Core
    • Windows 2008 Standard
    • Windows 2012 Enterprise
    • Windows 2012 Web Server Edition
Summary

You can fix a database corruption by frequently flushing data in memory to the disk. It is available on the following versions of OfficeScan:

  • OfficeScan 10 SP1 Patch 4 or above
  • OfficeScan 10.5 Patch 4
  • OfficeScan 10.6 SP1
Details
Public

To schedule and configure a database flush task, do the following:

  1. Open the ofcscan.ini file in the ...\PCCSRV\ folder of the OfficeScan server.
  2. Under the INI_DBFILE_SECTION section, locate the following keys and assign the appropriate values:

    [INI_DBFILE_SECTION]
    DB_IDLE_PERIOD={x} (Default value:900)
    DB_ENFORCE_DBFLUSH_PERIOD={y} (Default value:7200)

    Where:

    "x" is a value from 300 to 86400 seconds, it is the amount of time after the database process becomes idle when the flush task should run. By default, the flush task will run when the database process has been idle for 15 minutes.
    "y" is a value from 300 to 86400 seconds, it is the frequency of the flush process. By default, the database process runs the flush task every two hours after the latest flush.

  3. Save the changes made to the ofcscan.ini file and close the it.
  4. Restart the OfficeScan Master Service.

You can also enable the database service to trigger the database backup task as the service starts:

  1. Open the ofcscan.ini file in the ...\PCCSRV\ folder of the OfficeScan server.
  2. Under the INI_DBFILE_SECTION section, locate the following key and set an appropriate value:

    [INI_DBFILE_SECTION]
    DB_BACKUP_PRE_TASK=0

    ( =0 - database backup task will not be triggered (Default), =1 - database backup task will be triggered )

     
    The database backup file is saved in the ...\DBBackup\ folder of the OfficeScan server and is named using the Backup_YYYYMMDDHHMMSS format.
  3. Save the changes and close the file.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot
Solution Id:
1095256
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.