Traceflags on Windows ASE Services

1. Windows Registry Method

The dataserver parameters for ASE run as a Windows Service are stored in the registry.

To add a boot-time traceflag, use the Windows regedit utility to add an argument containing  the desired traceflag. 

For instance, to add traceflag 11222 you would do something like this: 

Go to the registry key for the server:
HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\Server\{servername}\Parameters
Edit > New > String Value
name the new string value "Arg5"  > hit enter.
Right click on Arg5, > modify
In the Value field > -T11222  > click OK
Exit registry.  

2. Windows Services Console Method

If you start ASE as a service, i.e. Start>Run: services.msc>Sybase SQLServer_[ASE-SERVER]>start, then:

-- double-click on Sybase SQLServer_[ASE-SERVER]
-- A properties window will come up, at bottom field named "Start Parameters," you may enter:

-T<flag_number1> -T<flag_number2> <<=== You may enter multiple traceflags separated by spaces.

3. RUN_SERVER file method

1. Go to $SYBASE/ASE-15_0/install/

2. Make a copy of the file prior to modification.

i.e. RUN_SERVER.bat as 'RUN_SERVER.ORIGINAL' and store it in a safe location.

3. Open RUN_SERVER.bat in your editor of choice

4. Modify accordingly (in bold).

*** BEFORE ****

rem
rem Adaptive Server Information:
rem name: syb157
rem master device: C:\Sybase\data\master.dat
rem server page size: 4096
rem master device size: 60
rem errorlog: C:\Sybase\ASE-15_0\install\syb157.log
rem interfaces: C:\Sybase\ini
rem
"C:\Sybase\ASE-15_0\bin\sqlsrvr.exe" -d"C:\Sybase\data\master.dat" -ssyb157 -e"C:\Sybase\ASE-15_0\install\syb157.log" -i"C:\Sybase\ini" -M"C:\Sybase\ASE-15_0"

*** AFTER ***

rem
rem Adaptive Server Information:
rem name: syb157
rem master device: C:\Sybase\data\master.dat
rem server page size: 4096
rem master device size: 60
rem errorlog: C:\Sybase\ASE-15_0\install\syb157.log
rem interfaces: C:\Sybase\ini
rem
"C:\Sybase\ASE-15_0\bin\sqlsrvr.exe" -d"C:\Sybase\data\master.dat" -ssyb157 -e"C:\Sybase\ASE-15_0\install\syb157.log" -i"C:\Sybase\ini" -M"C:\Sybase\ASE-15_0" -T3604 -T3605