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.

It sounds impossible, but I just had a sequence of dbping executions that ran the connection number up beyond 400,000 on a SQL Anywhere 16 database. It only takes a few milliseconds for a connect/disconnect so exhausting the INTEGER range is not out of the question.

If the connection number wraps to 1, do new connection numbers step over small assigned values that are still in use?

Do new connection numbers "step over" high-valued connection numbers (events, services, backups, exchanges, etc)?

asked 27 Feb '15, 15:08

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

The range of user connection numbers is from 1 to 999,999,999. If you did have more than a billion connections and disconnections, the connection numbers would start from 1 again, but they would not reuse any connection numbers already in use.

So the ranges for user and temporary connection numbers are never violated, and even if you use more than a billion connection numbers, there can never be two connections with the same number.

permanent link

answered 27 Feb '15, 15:13

Ian%20McHardy's gravatar image

Ian McHardy
accept rate: 40%

See also this question: When will SQLA reuse the connection id

permanent link

answered 02 Mar '15, 03:21

Martin's gravatar image

accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 27 Feb '15, 15:08

question was seen: 1,636 times

last updated: 02 Mar '15, 03:21