2276484 - Dbisql -nogui batches do no terminate and causes resources overload - SAP IQ

Execute consecutive dbisql -nogui batches.

At some point, they reach resources limit and cannot be executed anymore!

Errors below may be displayed:

Supplemental message: [Sybase][ODBC Driver][SQL Anywhere]Connection error: Insufficient system resources - failed to allocate a SYSV semaphore [sdbsrc:290]

09/29/2015 22:21:50.165 (15004) [E] [PROCESS] [SMS Base] Select PROCESS_RUN_ABORT: CODE 11518: Database connection error [sprocrun:801]

09/29/2015 22:21:50.166 (15004) [N] [MACRO FUNC] [SMS Base] ParseTree::ComputeInternal(): CODE 790: * Error. [parstree:2362]

 Or

/opt/sybase_client/IQ-16_0/bin64/dbisql -c "uid=$1;pwd=$2;eng=xxxx;links=tcpip(host=xxxxxx)" -nogui

> <(><<)>thread> <(><<)>time> <(><<)>id> <(><<)>description>

> 139869793175296 0.00 0x00000004 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/runtime/thread.cpp:5423):

VMCOs::init failed

> 139869793175296 0.00 0x00000003 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/jvmEnv.cpp:133):

VMCOs::init: Initialization of the control area failed

> 139869793175296 0.00 0x00000002 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/controls.cpp:382):

Controls::init: Could not initialize instance control area

> 139869793175296 0.00 0x00000001 ERROR occured

(/bas/sapjvm/71_REL/src/6/hotspot/src/share/vm/sap/os_unix.inline.hpp:727

): os::create_event: semget failed (key=5593300) (28: No space left on device)

> Error: Could not create the Java Virtual Machine.

> Error: A fatal exception has occurred. Program will exit.

sybase, dbisql ; On_Error ; Onerror ; -Onerror ; Prompt ; Exit; Exception ; catch ; failed to allocate a SYSV semaphore ; Could not create the Java Virtual Machine ; VM ; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem