on 09-17-2015 3:28 PM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Milan,
I move this to SAP ASE custom applications as the ASE version is cluster edition. Please post future questions there.
10Q!
- Gek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.