Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

dbsrv17.exe "E:\demo.db" -n 2011n -x tcpip -c 512m -gm 10 -xs http(port=80;maxrequestsize=70m;LOPT=ALL,HEADERS;LOG=D:\WEB.LOG) -zoc clientinfo.txt -qn

Why does this parameter affect web services with limited access!(-gm) Why is the API data of other systems provided by WEP services also affected by this GM restriction? What should I use to solve this problem!

asked 30 Oct '21, 00:22

mfkpie8's gravatar image

mfkpie8
273667075
accept rate: 12%


The -gm is intended to limit concurrent connections both standard and http based. Please review the MaxConnections protocol option or Reserved_Connections option if you need to limit HTTP based connections only.

permanent link

answered 30 Oct '21, 10:48

Chris%20Keating's gravatar image

Chris Keating
7.8k49128
accept rate: 32%

I don't limit http. I need to limit the number of 2638 port connections. Using GM parameters will affect all of them. Can't I limit port 2638 alone?

(03 Nov '21, 00:08) mfkpie8
Replies hidden

I guess you can use a custom login_procedure to limit the number of regular connections.

I guess you would probably need to do some calculation over the number of current licensed connections (via rows in sa_conn_info() with number < 100000000) and properties HttpNumConnections resp. HttpsNumConnections. If the difference (aka non-web connections) is higher than desired, and the new connection is not a web connection, you would reject it. Compare the (simpler) sample in the cited doc topic.

(I have no database with web connections in use currently, so can't check that approach myself...)

(03 Nov '21, 05:55) 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:

×246

question asked: 30 Oct '21, 00:22

question was seen: 3,390 times

last updated: 03 Nov '21, 05:57