How to Set Sybase ASE Error Log Path

1. Navigate to the following directory ($SYBASE/$SYBASE_ASE/install/RUN_server_name). Below directory is the example of Sybase ASE with SAP installed on Windows environment. Right click on RUN_SID.bat and select Edit.

Sybase - RUN_SID - Error Log Path

2. You will notice the following entries. Now, to change the default path location, just edit the entry (E:\sybase\SID\ASE-16_0\install\SID.log) and change to a new location.

OLD

rem
rem SAP Adaptive Server Enterprise Information:
rem name: SID
rem master device: E:\sybase\SID\sybsystem\master.dat
rem server page size: 16384
rem master device size: 400
rem errorlog: E:\OLD-LOCATION\SID.log
rem configuration file: E:\sybase\SID\SID.cfg
rem license properties file: E:\sybase\SID\ASE-16_0\sysam\SID.properties
rem interfaces: E:\sybase\SID\ini
rem shared memory file location: E:\sybase\SID\ASE-16_0
rem
“E:\sybase\SID\ASE-16_0\bin\sqlsrvr.exe” -d”E:\sybase\SID\sybsystem\master.dat” -sSID -e”E:\OLD-LOCATION\SID.log” -c”E:\sybase\SID\SID.cfg” -N”E:\sybase\SID\ASE-16_0\sysam\SID.properties” -i”E:\sybase\SID\ini” -M”E:\sybase\SID\ASE-16_0″

NEW

rem
rem SAP Adaptive Server Enterprise Information:
rem name: SID
rem master device: E:\sybase\SID\sybsystem\master.dat
rem server page size: 16384
rem master device size: 400
rem errorlog: E:\NEW-LOCATION\SID.log
rem configuration file: E:\sybase\SID\SID.cfg
rem license properties file: E:\sybase\SID\ASE-16_0\sysam\SID.properties
rem interfaces: E:\sybase\SID\ini
rem shared memory file location: E:\sybase\SID\ASE-16_0
rem
“E:\sybase\SID\ASE-16_0\bin\sqlsrvr.exe” -d”E:\sybase\SID\sybsystem\master.dat” -sSID -e”E:\NEW-LOCATION\SID.log” -c”E:\sybase\SID\SID.cfg” -N”E:\sybase\SID\ASE-16_0\sysam\SID.properties” -i”E:\sybase\SID\ini” -M”E:\sybase\SID\ASE-16_0″

Note

You can dynamically change the path of the error log as below,

Syntax

sp_errorlog “change log“, “new_path“ [,{“jslog true“ | “jslog false“}]
sp_errorlog “help”, “change log”

Parameters
new_path: New path of the error log. Maximum length of new_path is 255 characters.

jslog true: The default option. If the Job Scheduler is running, change log attempts to change the Job Scheduler Agent log to the directory where the new Adaptive Server error log will reside. Both logs will indicate error messages, if any.

jslog false: Do not change the location of the Job Scheduler Agent log.

Do visit the official Sybase documentation for further information.

You May Also Like

Leave a Reply?