How to shrink the embedded database for the SEPM using the Dbunload tool

Article:TECH104278  |  Created: 2008-01-26  |  Updated: 2014-04-02  |  Article URL http://www.symantec.com/docs/TECH104278
Article Type
Technical Solution


Issue



The embedded database for the Symantec Endpoint Protection Manager (SEPM) grows overly large. Use the Dbunload.exe tool to shrink it.


Solution



Please note that this utility does not work with Symantec Endpoint Protection (SEP) 12.1 and above. Please contact support and reference article TECH185177 for more information on the utility that is appropriate for that version of SEP.

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, use the Dbunload tool.

To use the Dbunload tool on 32-bit Operating Systems

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

Note:
If the following results are seen:

 ***** SQL error: Specified database file already in use

Stop the Symantec Embedded Database Service and run the command again.

Note:
If the following results are seen:

***** SQL error: Database server not found

Run the following command :

dbunload -c "dbf=C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db;start=dbsrv9;uid=dba;pwd=password_set_during_install" -ar

To use the Dbunload tool on 64-bit Operating Systems

On 64-bit Operating systems, the path should be changed accordingly, and only the dbunload command that specifies the full path to the sem5.db database will work. The procedure and commands will like this:

1 Stop the following services:

    Symantec Endpoint Protection Manager
    Symantec Embedded Database




2. Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:
cd \Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\ASA\win32
dbunload -c "dbf=C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\db\sem5.db;start=dbsrv9;uid=dba;pwd=password_set_during_install" -ar

Note:
If the following results are seen:

***** SQL error: Specified database file already in use or
 

***** Too many connections to database being replaced
Stop the Symantec Embedded Database Service and run the command again


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 supplied while installing Symantec Endpoint Protection Manager initially.

Once the dbunload process has finished, you can:

  1. Restart the service Symantec Embedded Database.
  2. Start the service Symantec Endpoint Protection Manager.




References
"Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.0" at:

http://www.symantec.com/docs/TECH104585

 



Legacy ID



2008022616103648


Article URL http://www.symantec.com/docs/TECH104278


Terms of use for this information are found in Legal Notices