runnable process search count

[Former Member]

I m upgrading ASE to

Adaptive Server Enterprise/15.7/EBF 23823 Cluster Edition SP132 /P/RS6000/AIX 61/ase157sp131x/3919/64-bit/FBO/Tue Jan 20 07:36:36 2015

I need to modify config parameter:

1> sp_configure 'runnable process search count',2500

2> go

but getting the error below

Msg 15940, Level 16, State 3:

Server 'tv_production_st2', Procedure 'sp_configure', Line 1824:

This command is not supported in threaded mode. To achieve the same result in

threaded mode, use the 'alter thread pool' command to change 'idle timeout'.

Msg 5849, Level 16, State 1:

Server 'tv_production_st2', Procedure 'sp_configure', Line 1824:

Verification failed for parameter 'runnable process search count'.

(return status = 1)

[former_member89972 · Accepted solution]

Milan

You are running the ASE server in new default 'threaded kernel' mode.

You can verify this by following command

exec sp_configure ' kernel mode'

go

And it will show the current value. It is a static parameter i.e. needs a reboot if you change it.

As the error message clearly says "runnable process search count" is useful only when you run ASE in 'process kernel mode'  where each engine is separate Unix process.

You can find more details in the two volumes of ASE System Administration Guides.

HTH

Avinash

[former_member209935]

Others have already commented on the fact that ASE's threaded kernel uses a different model than the process kernel.  Thread pools have an idle timeout defined in microseconds.  Rarely would you need to change this.

Out of curiosity, why were you thinking you needed to change "runnable process search count"?

Peter

[former_member142598]

Hello Milan,

I move this to SAP ASE custom applications as the ASE version is cluster edition. Please post future questions there.

10Q!

- Gek