Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    18

    Unanswered: How to set Trace Flag in ASE 15.0.3 Win 2003

    I need to set a Trace Flag -T328 in my Sybase ASE 15.0.3 Server, Windows Server 2003.
    How or where should I start to do so ?
    sp_traceon only works for the current session.
    Add -T328 into the file : C:\sybase\ASE-15_0\install\RUN_HKTTDBZU03.bat doesn't work as I found the command executed by Control Panel Sybase SQLServer Service is :
    Path to executable
    C:\sybase\ASE-15_0\bin\sqlsrvr.exe -s<my server name> -C

    I don't know how to modify and add -T328 to it.

    Do you know how to add -T328 to Sybase permanently ?

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hey,
    You almost got it, in the path "C:\Sybase\ASE-15_0\install" you have that ".bat" you said.
    This calls that sqlsrv.exe.

    In that line where the executable is called you have some parameters rigt?
    like -d -s -e ... and so on.

    All you have to do is at the end add the -T328

    1-So shutdown the server.
    2-Backup first and then change the bat.
    3-Then start the server.

    After that i think it will probably appear in the log, but you can also connect to the server and run the following:
    Code:
    dbcc traceon(3604)
    
    dbcc traceflags
    
    dbcc traceoff(3604)
    Hope it helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •