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
- Ensure that you have available free drive space equal to 1.5 to two times the size of the database.
- Stop the following services:
- Symantec Endpoint Protection Manager
- Symantec Embedded Database
- 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
- Start the service Symantec Embedded Database.
- 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]