1929979 - Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE and Server start fail in IQ Multiplex - SAP IQ

• SAP IQ crashes during the normal workload and showes the following error in the iqmsg file:

.. [20896]: Insert for '#tb_Temp' completed in 9 seconds. 0 rows inserted.
.. Allocation failed. Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE
.. Failure on privileged blockmap ; _blockmap @ 0x2abc902927e8
.. Blockmap Member Variables for 0x2abc902927e8
.. From st_txncb.cxx:4816
.. **************************************************
.. *** Sybase IQ Abort:
.. *** From: s_blockmap.cxx:6768
..
.. *** Error #: 0, O/S Error #: 0
.. **************************************************

• Attempting to restart the server gives the following error in the iqmsg log and failed to start :

.. OpenDatabase Completed
.. IQ cmd line srv opts: -iqgovern 20 -iqmc 40603 -iqtc 40603 -iqmsgsz 100 -iqmsgnum 5
.. IQ full cmd line: -n test_c -x tcpip{port=2988} -cl 1536m -ch 4096m -iqgovern 20 -gc 20 ...
..
.. DB: Multiplex Coordinator Server test_c, PID 344, LOGIN test
.. DB: Database encryption is OFF.
.. Mem: 68126mb/M68126
..
.. Allocation failed. Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE
.. Failure on privileged blockmap ; _blockmap @ 0x81c5698

• SAP Sybase IQ 15.4
• SAP IQ 16.1

DBSPAWN, -80, fail, full, exceed, space, crash , KBA , BC-SYB-IQ , Sybase IQ , Problem