In non-clustered versions of Adaptive Server, the default value for runnable process search count is 2000. For the Cluster Edition, the default value for runnable process search count is 3. The change from 2000 to 3 ensures that Adaptive Server does not overuse the CPU during system idle times.
runnable process search count controls the number of times an Adaptive Server engine loops while looking for a runnable task before releasing the CPU to the operating system. A low value for runnable process search count is useful when other applications (for example, Adaptive Server clients, operating system kernel threads, or non–Adaptive Server applications) run on the same machine as Adaptive Server.
With a runnable process search count value of 3, the Cluster Edition can better share the system CPU with other processes running on the same machine. However, if runnable process search count is 3 and Adaptive Server is running as a stand-alone process, users may experience delays in server response times. In this case, reset runnable process search count to 2000.
