WelcomeProducts & ServicesSecurity ResponseSupportSolutions & IndustriesLicensingTrainingStore
Enterprise
Symantec.com > Enterprise > Support > Knowledge Base


How to shrink the embedded database using the Dbunload tool

Question/Issue:
You notice that the embedded database grows overly large. You want to use the Dbunload.exe tool to shrink it.


Solution:
The Dbunload tool is provided with Symantec Endpoint Protection 11.0.2 (Maintenance Release 2). To obtain Maintenance Release 2, read the document Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.

Note: The problem that causes the embedded database to grow overly large is solved in Maintenance Release 2, but migrating to Maintenance Release 2 does not shrink the database automatically. To shrink the database, you must use the Dbunload tool.

To use the Dbunload tool

  1. Ensure that you have available free drive space equal to 1.5 to two times the size of the database.
  2. Stop the following services:
    • Symantec Endpoint Protection Manager
    • Symantec Embedded Database
  3. Using the Database Back Up and Restore wizard, make a backup copy of the following file:

    \Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
  4. Start the service Symantec Embedded Database.
  5. Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:

    cd \Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32
    dbunload -c "uid=dba;
    pwd=password_set_during_install" -ar

    Can also start from ASA\win32 and type
-c "dbf=C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db;start=dbsrv9;uid=dba;pwd=XXXXXXXX" -ar

The time to reduce the size of the database will depend on several factors, including, but not limited to: available drive space, amount of memory, speed of the processor, size of the database, and other server and background functions running on the target system at the time of dbunload being used.

Note:
"password_set_during_install" is the password you supplied while installing Symantec Endpoint Protection Manager initially.

5. Restart the service Symantec Embedded Database.
6. Start the service Symantec Endpoint Protection Manager.



References:
"Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.0" at:
http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008040315215348


Document ID: 2008022616103648
Last Modified: 05/14/2009
Date Created: 02/26/2008
Product(s): Endpoint Protection 11, Network Access Control 11
Release(s): Endpoint Protection 11 [All Releases], Network Access Control 11 [All Releases]


Site Index · Legal Notices · Privacy Policy · · Contact Us · Global Sites · License Agreements
©1995 - 2009 Symantec Corporation