000018292 - How to delete or truncate the log database file sdlog.db

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

Article Content

Article Number000018292
Applies ToRSA ACE/Server 4.1 (no longer supported as of 2-1-2004)
RSA ACE/Server 4.x (no longer supported as of 2-1-2004)
sdserv.db
IssueHow to delete or truncate the log database file sdlog.db
The log database file located in the /ace/data, unix, or \ace\data, NT, directory as sdlog.db can increase in size dramatically over time. RSA Security recommends that you choose one of the following procedures when deleting or truncating the log database.

UNIX :
To delete the log database do the following:
        cd /ace/prog
        ./aceserver stop
        ./sdconnect shutdown
        ./sdnewdb
        log

To truncate the size of the log database by date do the following:
        cd /ace/prog
        ./sdadmin
        log
        Delete Before a Date
        <enter date>
        OK

To truncate the size of the log database by percentage do the following:
        cd /ace/prog
        ./sdadmin
        log
        Delete By Percentage
        <enter percentage>
        OK

Windows NT :
To delete the log database do the following:
go to:
        start
        settings
        control panel
         ACE/Server
        Stop
        OK to both the ACE/Server and ACE/Broker stopped.
go to:
        start
        run
        browse to \ace\prog and chose sdnewdb.exe
        OK
        chose Log database
        OK
        OK to continue and new log database created dialogue boxes

To truncate the size of the log database by date do the following:
go to:
        start
        programs
        ACE Server
        Database Administration - Host Mode
        log
        Delete Before a Date
        <enter date>
        OK

To truncate the size of the log database by percentage do the following:
go to:
        start
        programs
        ACE Server
        Database Administration - Host Mode
        log
        Delete By Percentage
        <enter percentage>
        OK
        


See also How to Configure  ACE/Server Automated Log Maintenance
Legacy Article ID6.0.2984076.2885350

Attachments

    Outcomes