Error related logs from Sybase

[HarshPatel1]

I'm currently working with Sybase Adaptive Server Enterprise (ASE) and need to locate the database error logs for troubleshooting purposes. Specifically, I need to understand the default location of these logs and how to verify or change this location if necessary.

[Mark_A_Parsons]

Find the current name and location of the errorlog:

select @@errorlog

Default location when ASE is initially built:

${SYBASE}/${SYBASE_ASE}/install/<ase_instance_name>.log

Default location when ASE is started will be defined in the runserver file, default name and location:

${SYBASE}/${SYBASE_ASE}/install/RUN_<ase_instance_name>

To change the location of the errorlog while ASE is up and running:

sp_errorlog 'change log', '/new/path/to/ASE/errorlog'

To change the location of the errorlog while ASE is shutdown - edit the runserver file to point to a new location.