SAP Knowledge Base Article - Preview

1929979 - Dbspace IQ_SYSTEM_MAIN is OUT OF SPACE - SAP IQ

Symptom

  • 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
    • ***      PID: 2211
    • ***      Exception Location: 0x0x50943800
    • ***      Error ID: 2096,  Exception Type: s_nodbspaceexception
    • ***      Thread: 1351911744  (TID: 48, Original TID: 48)
    • ***      Error #: 0,  O/S Error #: 0
    • **************************************************

 

  • Attempting to restart the server gives the following error in the iqmsg log:
    • OpenDatabase Completed
    • IQ cmd line srv opts: -iqgovern 140 -iqmc 40603 -iqtc 27068 -iqmsgsz 100 -iqmsgnum 5
    • IQ full cmd line: -n netview_c -x tcpip{port=2988} -cl 1536m -ch 4096m -iqgovern 140 -gc 20 -gd all -gl all -gm 200 -gp 16384 -iqmc 40603 -iqtc 27068 -iqmsgsz 100 -iqmsgnum 5 -n netview_c -x tcpip{port=2988} /srv/smartcare/netview/netview.db -ti 4400 -gn 205 -o /opt/sybase/IQ-15_4/logfiles/netview_c.0016.srvlog -hn 5
    • DB: r/w, Main 3585MB Buffs=323599, Temp 2389MB Buffs=215727, Pgsz=131072/8192blksz/16bpc, BP=4
    • DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
    • DB: Versn: 15.4.0.3019/120816/P/ESD 2/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2012-08-16 10:48:47
    • DB: Name:  /srv/smartcare/netview/netview.db
    • DB: Txn ID Seq: 39542295
    • DB: DBID Blk: 5120050
    • DB: Multiplex Coordinator Server netview_c, PID 344, LOGIN netvie
    • DB: Database encryption is OFF.
    •     Mem: 68126mb/M68126
    • Main      Blks: U448576554/73%, Buffers: U29533/L2
    • Temporary Blks: U6405/0%, Buffers: U396/L0
    • Main      I: L84093/P28513 O: C1020/D1020/P0 D:0 C:31.1
    • Temporary I: L5214/P0 O: C396/D396/P0 D:0 C: 0.0
    • Allocation failed. Dbspace IQ_SYSTEM_MAIN is  OUT OF SPACE
    • Failure on privileged blockmap ; _blockmap @ 0x81c5698

Read more...

Environment

SAP Sybase IQ 15.x

Product

SAP Sybase IQ 15.4

Keywords

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

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.