cancel
Showing results for 
Search instead for 
Did you mean: 

Why does CALL sa_server_option ( 'MaxMultiProgrammingLevel', '20' ); fail?

Breck_Carter
Participant
0 Kudos
718

dbsrv17 -gnh 20 works, but CALL sa_server_option ( 'MaxMultiProgrammingLevel', '20' ); doesn't work for any value less than 80...

Could not execute statement.
Invalid setting for option 'MaxMultiProgrammingLevel'
SQLCODE=-201, ODBC 3 State="42000"
Line 4, column 1

CALL sa_server_option ( 'MaxMultiProgrammingLevel',     '20' )

Accepted Solutions (1)

Accepted Solutions (1)

johnsmirnios
Advisor
Advisor

If you started the server without -gnh, then the default will be 80. You cannot adjust the max to be lower than it currently is.

Breck_Carter
Participant
0 Kudos

...but you can adjust the min to be higher than it currently is [snork]

johnsmirnios
Advisor
Advisor
0 Kudos

Looking at the code, when we increase the max we create new threads. Decreasing the max would probably require getting those threads to [eventually) terminate. It looks like that was never done.

Answers (0)