- DBISQL always allocates a semaphore at the starting timing in AIX, HP-UX and Linux platforms.
- The semaphore is used only for the same-computer SHMEM communications.
- If dbisql exits by SIGKILL or aborting from some triggers, the allocated semaphore can be left.
- As the result, when OS can run out of semaphore, the new dbisql connection will receive the following error message:
Could not connect to the database.
Connection error: Insufficient system resources - failed to allocate a SYSV semaphore
SQLCODE=-832, ODBC 3 State="08001"
- SAP IQ 15.x
- SAP IQ 16.0
- SAP SQL Anywhere 12.0
- SAP SQL Anywhere 16.0
- SAP SQL Anywhere 17.0
abort, ipcrm -s <smid> , KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.