Disabling dirty reads for query

The Sybase agent enables dirty reads for its query execution by default to prevent locking.
The variable COLL_USE_NOLOCK is used to enable or disable the query dirty reads.
When dirty reads is enabled, query is executed with isolation level zero to avoid locking.
If you wish to disable the dirty reads for agent query, you can set the variable COLL_USE_NOLOCK to zero.

Before you begin

To disable dirty reads for agent query, ensure that the agent is installed.

About this task

The Sybase agent enables dirty reads by default. To disable the dirty reads for the agent query, complete the following steps.

1. Stop the agent.
2. Set the variable COLL_USE_NOLOCK to zero.
   • UNIX
     1. Add COLL_USE_NOLOCK=0 in CANDLEHOME/config/.oy.environment file.
     2. Save and close the file.
   • Windows
     1. Locate the agent instance file CANDLEHOME\TMAITM6_x64\KOYENV_INSTANCENAME.
     2. Add the following line in the file.

        COLL_USE_NOLOCK=0

     3. Save and close the file.

   The CANDLEHOME is the agent installation directory.
   The INSTANCENAME is the agent instance name.

3. Start the agent.