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 12.0.1.3152

Thanks!

Margaret

asked 03 Mar '11, 20:08

Margaret%20Kammermayer's gravatar image

Margaret Kam...
3316819
accept rate: 50%


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!).

permanent link

answered 04 Mar '11, 08:16

Volker%20Barth's gravatar image

Volker Barth
30.0k294448654
accept rate: 32%

edited 04 Mar '11, 17:22

Volker is correct - I checked the code and both return the same value. MultiProgrammingLevel has been retained for backward compatibility and has been replaced with the newer CurrentMultiProgrammingLevel as a result of the automatic tuning of MPL which was added in 12.

(04 Mar '11, 18:08) Mark Culp

Wow, so I did some kind of code review without having the code available? - That can only work since "Watcom does the things the way they should be done.":)

(05 Mar '11, 16:17) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×20

question asked: 03 Mar '11, 20:08

question was seen: 1,072 times

last updated: 04 Mar '11, 17:22