000020320 - ACE/Server database size doubles after sdload

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000020320
Applies ToRSA ACE/Server 5.0.x (no longer supported as of 8-15-2004)
RSA ACE/Server 5.1 (no longer supported as of 7-14-2006)
Microsoft Windows NT 4.0
Microsoft Windows 2000
IssueACE/Server database size doubles after sdload
The size of the "sdserv.db" file after loading the dump (sdserv.dmp) file into a new install of ACE/Server 5.0.3 on another machine (different to original Primary and Replica machines) is effectively doubled
A subsequent run of "sdcompress" on that database does not reduce the size of the database
CauseThis behavior is due to the fact that when you have large databases and you load the database in "merge" mode, delta records are created for each replica record in the database which causes the database size to almost double. For more information on Delta Records, see the solution titled What are Delta Records?
ResolutionUsing the Compress utility again, perform the following steps:

1. Navigate to RSA ACE/Server -> DataBase Tools -> Compress -> Compress Server Database

2. Check the box "Do not load delta records"

3. Click "yes" to the warning

You should then be able to compress your database.
Legacy Article IDa16026