Video Screencast Help

Changes in database maintenance options do not take effect immediately

Created: 05 Jun 2009 • 5 comments
Kedar Mohile's picture
+1 1 Vote
Login to vote

After you configure database maintenance options, the new options are applied at midnight, and not immediately.

To configure the database options:

  1. In the console, click Admin > Servers, and then select a site.
  2. Under Tasks, click Edit Site Properties, and then click the Database tab.

To configure the management server to apply the database maintenance options immediately, you can configure the conf.properties file.

To configure the config.properties file:

  1. Open the conf.properties file, located in the C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc directory by default.
  2. Change the following parameters:
  • Change scm.object.idletime=3600000 (in milliseconds) to a smaller number. The default setting is 1 month.
  • Change scm.timer.objectsweep=900 (in seconds) to a smaller number.The default setting is once per day.
     
  1. Save the config.properties file and restart the Symantec Endpoint Protection Manager.

Comments 5 CommentsJump to latest comment

Abhishek Pradhan's picture

Right on.

A good way to refresh the DB and logs right away. It works like magic!

Good work mate, keep it up.

Abhishek Pradhan, PMP, MCT
Blog: http://blog.abhishekpradhan.net | SIG Lead - Pune IT Pro (Microsoft Pune User Group) | http://www.puneusergroup.org

0
Login to vote
Nel Ramos's picture

thanks for the advice..
by the way, how come they take effect at midnight..
could we force it to update at the time we want it to be applied.
thanks..

Nel Ramos

0
Login to vote
Kedar Mohile's picture

"the new options are applied at midnight" as: Every database perform a "sweep" function as a part of its maintainance activity and The defult time here is at 0000hrs assuming minimum activity
I would try to find if there is a way to change the time of the maintainance activity

Thanks :)


0
Login to vote
Nourbakhsh's picture

Thank's a lot Dear Kedar, for nice Tricks by changing some settings. As i mention before, for best performance & efficiency, good configuration and known about how to change the settings, are Very Important .

Best Regards

0
Login to vote