Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

runnable process search count

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 Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question