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

• 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)

• SAP IQ 16.0 Multiplex

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