Make a backup copy of your runserver file, and then edit the copy of the file to include the desired trace flag. The sample modified RUN_server file below includes trace flag 3605 for an Adaptive Server named PRODUCTION:
!dcl ! ! Adaptive Server Information: ! name: PRODUCTION ! master device: SYBASE_SYSTEM:[DEVICES]PRODUCTION_MASTER.DAT ! master device size: 10240 ! errorlog: SYBASE_SYSTEM:[SYBASE.INSTALL]PRODUCTION.ERR ! interfaces: SYBASE_SYSTEM:[SYBASE] ! $ define sybase_system SYBASE1150_SYSTEM: $ define sybase sybase_system:[sybase] $ define syb_devcreate sybase_system:[sybase.bin]devcreate.exe $ define dslisten "PRODUCTION" $ server :== $SYBASE_SYSTEM:[SYBASE.bin]dataserver.exe $ server - /DEVICE=(SYBASE_SYSTEM:[DEVICES]PRODUCTION_MASTER.DAT) - /ERRORFILE=SYBASE_SYSTEM:[SYBASE.INSTALL]PRODUCTION.ERR - /INTERFACES=SYBASE_SYSTEM:[SYBASE] - /TRACE=3605
To set more than one trace flag, modify the last line, as in the following example:
$ server - /DEVICE=(SYBASE_SYSTEM:[DEVICES]PRODUCTION_MASTER.DAT) - /ERRORFILE=SYBASE_SYSTEM:[SYBASE.INSTALL]PRODUCTION.ERR - /INTERFACES=SYBASE_SYSTEM:[SYBASE] - /TRACE=(3605,3608)
Use the startserver command to start Adaptive Server with the modified runserver file:
$ startserver /server=production
Change the name of the modified runserver file to store it as a backup should you need to run Adaptive Server with this trace flag again. Then restore the backup copy of the original runserver file you made in step 1 to its original name.
After you have completed corrections, restart Adaptive Server with your normal runserver file.
WARNING! Do not attempt a normal shutdown after using trace flags 3607 or 3608. Always use shutdown with nowait in these cases.
