In Version 12, what's the difference between the two server properties MultiProgrammingLevel and CurrentMultiProgrammingLevel?
In my testing, they appear to be the same .... executing the command in dbisql:
CALL sa_server_option ( 'CurrentMultiProgrammingLevel', 25 );
changed the value of both properties to 25.
I'm using SA 18.104.22.16852
asked 03 Mar '11, 20:08
Note, this is just a guess:
IMHO, they should have the same value.
MultiProgrammingLevel is an older server property, introduced with V10, and comes from the time when the multiprogramming level was statically fixed at server start time (dbsrxX -gn).
CurrentMultiProgrammingLevel is one of those new properties to check the automatic tuning of the database server multiprogramming level introduced with V12. Others are AutoMultiProgrammingLevel, MaxMultiProgrammingLevel and MinMultiProgrammingLevel.
One might think that for V12, MultiProgrammingLevel could have been omitted (as it seems to have the same meaning as CurrentMultiProgrammingLevel) but was left for reasons of backward compatibility (which would sound reasonable, of course!).