SAP Knowledge Base Article - Preview

2098650 - How to prevent running out of IQ_SYSTEM_MAIN during running excessive DDL under SAP IQ Multiplex environment

Symptom

  • Running excessive DDL could cause running out of IQ_SYSTEM_MAIN in Multiplex.
  • It also makes coordinator to crash required restarting in Multiplex single-node mode.

   [Sample iqmsg when IQ crashed because of running out of IQ_SYSTEM_MAIN]

   I. 11/20 18:05:22. 0000000130 Allocation failed. Dbspace IQ_SYSTEM_MAIN is  OUT OF SPACE
   I. 11/20 18:05:23. 0000000130 Failure on privileged blockmap ; _blockmap @ 600000001f50f728
   I. 11/20 18:05:23. 0000000130 Blockmap Member Variables for 600000001f50f728
   I. 11/20 18:05:23. 0000000130 From stcxtlib/st_txncb.cxx:5587
   I. 11/20 18:05:23. 0000000130   _nextPartitionForHelperFlush = 0
   ............
   
   I. 11/20 18:05:23. 0000000130                        _psuAll = 0
   I. 11/20 18:05:23. 0000000130 [s_blockmap_identity]
   I. 11/20 18:05:23. 0000000130 _UniqueId: 375241
   I. 11/20 18:05:23. 0000000130 _RootBlockId: 0
   I. 11/20 18:05:23. 0000000130 _NEntries: 0
   I. 11/20 18:05:23. 0000000130 _LastWriterTxnId: 0
   I. 11/20 18:05:23. 0000000130 _LastWriterSavePoint: 0
   I. 11/20 18:05:23. 0000000130 _FanOutAndFlags2: 0x0
   I. 11/20 18:05:23. 0000000130 _Flags: 0x35
   I. 11/20 18:05:23. 0000000130 _Version: 1
   I. 11/20 18:05:23. 0000000130 _NLinks: 0
   I. 11/20 18:05:23. 0000000130 _EntriesPerLink: 0
   I. 11/20 18:05:23. 0000000130 _FirstAvailLink: 0
   I. 11/20 18:05:23. 0000000130 _MaxLink: 0
   I. 11/20 18:05:23. 0000000130 _ModNum: 2
   I. 11/20 18:05:23. 0000000130 _RootModNum: 1
   I. 11/20 18:05:23. 0000000130 [end s_blockmap_identity]
   I. 11/20 18:05:24. 0000000130
   I. 11/20 18:05:24. 0000000130
   I. 11/20 18:05:24. 0000000130 **************************************************
   I. 11/20 18:05:24. 0000000130 ***   SAP IQ Abort:
   I. 11/20 18:05:24. 0000000130 ***      From:  slib/s_blockmap.cxx:5166
   I. 11/20 18:05:24. 0000000130 ***      PID: 23994
   I. 11/20 18:05:24. 0000000130 ***      Exception Location: 0x9fffffff652b26b0
   I. 11/20 18:05:24. 0000000130 ***      Error ID: 2096,  Exception Type: s_nodbspaceexception
   I. 11/20 18:05:24. 0000000130 ***      Thread: 112  (TID: 5, Original TID: 5)
   I. 11/20 18:05:24. 0000000130 ***      Error #: 0,  O/S Error #: 0
   I. 11/20 18:05:24. 0000000130 **************************************************
   I. 11/20 18:05:24. 0000000130
   ............
   
   I. 11/20 18:06:34. 0000000133     **  While handling one abort, caught signal 11, program abort on thread 109 (TID 8)


Read more...

Environment

  • SAP IQ 16.0 Multiplex

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This 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.