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' ) |
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. ...but you can adjust the min to be higher than it currently is [snork]
(06 May '22, 16:49)
Breck Carter
Replies hidden
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.
(06 May '22, 17:51)
John Smirnios
|