2573545 - How to avoid crash when IQ_SYSTEM_MAIN or IQ_SYSTEM_TEMP or user dbspaces are full - SAP IQ

• When a dbspace is full, SAP IQ is prone to crash.
• Error log may show information such as:
•  Allocation failed. Dbspace DB_SPACE1 is  OUT OF SPACE

• Exception Thrown from slib/s_blockmap.cxx:15246, Err# 0, tid 791 origtid 478
  O/S Err#: 0, ErrID: 2096 (s_nodbspaceexception); SQLCode: -1009170, SQLState: 'QSB66', Severity: 14
  You have run out of space in DB_SPACE1 DBSpace. Current DBSpace size is XXXMB.

• Warning, out of dbspace on DB_SPACE1 while writing dirty s_buf=0x7f25275b3bf0 errinfo=4 getCleanOnly=0 dbspaceToAvoid=16389

• Warning: s_blockmap is throwing while user locked. bmp:0x7f28c8054918 lockRefCount:2 created from:slib/s_dpidx.cxx:623 locked from:slib/s_barray.cxx:2861

  STACKTRACE containing:
  Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
  at slib/s_blockmap.cxx:13527 on thread 139798561879808 (TID 818)

  s_blockmap::ThrowError(s_bufman_errorInfo, char const*, int)
  s_ROBlockmapCursor::Find(unsigned long long, short, int, s_bufmanCallerStats*)
  s_bArrayCursor::Find(unsigned long long, unsigned int, unsigned int)
  s_bArrayLocater::LoadBlock(unsigned long long&)
  s_bArrayLocater::LoadPage(unsigned long long)
  s_bArrayLocater::LocateTokenRecord(unsigned long long)
  hs_dpfetch::ColumnScan3_ByteArr(unsigned char const*, s_bmFastROCursor&,l_dtors_aux_fini_array_entry
  workAllocator::DoWork(unsigned int)
  hos_lwtask::Start(hos_lwtask*)
  IQWorkerStarter(void*)
  run_task_body
  UnixTask::pre_body(void*)
  __do_global_dtors_aux_fini_array_entry

• SAP IQ 15.4
• SAP IQ16.0
• SAP IQ 16.1

RESERVE ; RESERVED ; space ; dbspace ; MAIN_RESERVED_DBSPACE ; TEMP_RESERVED_DBSPACE_MB ; IQ_SYSTEM_MAIN_RECOVERY_THRESHOLD ; IQ_SYSTEM_MAIN_ALLOCATION_RATIO ; , KBA , BC-SYB-IQ , Sybase IQ , How To