cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a dependent MaxMultiprogrammingLevel-variable from the -gn & -gnl dbsrv12 server options?

1,668

a) If I run the SQL Anywhere Network Server Version 12.0.1.3967 with -gn option, then MaxMultiprogrammingLevel > 100:

a1) -cs -cl 3G -gns -gna 1 -gn 100 ==>

Minimum cache size: 3145728K, maximum cache size: 3149704K
Multiprogramming level: minimum:4, current:100, maximum:400


a2) -cs -cl 3G -gns -gna 1 -gn 70 ==>

Minimum cache size: 3145728K, maximum cache size: 3272584K
Multiprogramming level: minimum:4, current:70, maximum:280


a3) -cs -cl 3G -gns -gna 1 -gn 80 ==>

Minimum cache size: 3145728K, maximum cache size: 3231624K
Multiprogramming level: minimum:4, current:80, maximum:320


b) But if I run the SQL Anywhere Network Server Version 12.0.1.3967 with -gnl option, then MaxMultiprogrammingLevel = 80:

b1.1) -cs -cl 3G -gns -gna 1 -gnl 100 ==>

Minimum cache size: 3145728K, maximum cache size: 3477384K
Multiprogramming level: minimum:100, current:80, maximum:80


b1.2) -cs -cl 2G -gns -gna 1 -gnl 100 ==>

Minimum cache size: 2097152K, maximum cache size: 3477384K
Multiprogramming level: minimum:100, current:80, maximum:80


b2.1) -cs -cl 3G -gns -gna 1 -gnl 70 ==>

Minimum cache size: 3145728K, maximum cache size: 3477384K
Multiprogramming level: minimum:70, current:75, maximum:80


b2.2) -cs -cl 2G -gns -gna 1 -gnl 70 ==>

Minimum cache size: 2097152K, maximum cache size: 3477384K
Multiprogramming level: minimum:70, current:75, maximum:80


Is this correct behavior -gnl option?

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

In my understanding, this is documented behaviour when you do not specify the -gnh option. Then the maximum multiprogramming level has the following

Default
Four times the -gn database server option value

  • In case you set the -gn option, the maximum value is four times that value, as your test series (a) shows.
  • In case you set the -gnl option but not the -gn option, the latter has its default (20), so the maximum value is still four times that default, aka 80, as the other tests reveal.
0 Kudos

Thanks!...

Answers (0)