GENERATING A NEW LOG FILE FOR THE HRPLUSV4 DATABASE

When the log file for the database grows too large, the following are possible side effects:

·               it uses too much server space

·               the application runs slowly

·               "internal database error" message appears

The large log file must be removed and a new one generated.

In order to do this, we must use the -f database switch to force the database to start without a log file, and then generate the newer, smaller log file.

Instructions:

1          Stop Omnis Studio

2          Stop the database (either via its Sybase Central service or via the Control Panel services area - there, the service is called Adaptive Server Anywhere)

3          Back up the database (including the log file)

4          Delete the hrplusv4.log  file.

5          To force start the database without a log file: Create a shortcut on the desktop with the following parameters: 

C:\Program Files\Sybase\SQL Anywhere 8\win32\dbsrv8.exe" -f c:\sb_databases\hrplusv4.db

NB:  The example used above is an Hrplusv4.db file located on C:\sb_databases with Sybase SQL Anywhere installed in the C:\Program Files area.

6          Run the shortcut - the database will start up, then shut down immediately afterwards.

7          To generate the new log file:

Remove the shortcut and start the databases in the usual way (eg. via the Sybase Services or Control Panel services).

You should now see a newer, smaller logfile for hrplusv4.

8          Restart Omnis Studio