Using a Different Database Log Path

SAP recommends that you always use the default database log path location for SAP Mobile Platform databases. However, the database log path can be changed.

Note: This information is useful if you want database and log files on separate IO channels for better performance, or other reasons, after installation.
  1. Change directories to SMP_HOME\Servers\SQLAnywhereXX\BINXX.
  2. To move a log from its default location to a new drive, use a command similar to this one:
    dblog -t <New Log File Name> -m <Mirror Log File Name> 
    <Database file Name>

    For example:

    dblog -t D:\databaseLog\default.log -m E:\databaseLog\default_mirror.log 
    C:\databases\default.db
    
    This example, moves default.log from its default location of C:\databases, to the D:\ drive, and sets up a mirrored copy on the E:\ drive. SAP recommends naming the log files specified by -t and -m options differently.
  3. You can use this same syntax for other databases, like monitoring database, simply by changing the log and database file names appropriately.