SAP Knowledge Base Article - Preview

2576496 - "Main IQ Blocks Used" on sp_iqstatus - SAP IQ

Symptom

What does "Main IQ Blocks Used" mean on sp_iqstatus?

For example, we have the following dbspaces:

======

DBSpaceName
DBSpaceType Writable Online Usage TotalSize Reserve NumFiles
NumRWFiles StripingON StripeSize
BlkTypes
OkToDrop
--------------------------------------------------------------------------------------------------------------------------------
------------ -------- ------ ----- --------- ------- -----------
----------- ---------- ----------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------
IQ_SYSTEM_MAIN
MAIN T T 21 1.55T 0B 7
7 T 1K
7H,41620416F,32D,128M,8571B
N

IQ_SYSTEM_TEMP
TEMPORARY T T 1 785G 0B 52
52 T 8K
52H,4448F,62258A
N

iq_main
MAIN T T 95 4.6T 0B 541
541 T 8K
541H,583449884A
N

==========

We have run into out of space:

==========

I. 10/30 07:15:19. 0000036578 Txn 1742033845 0 1742033845
I. 10/30 07:15:19. 0000036578 Cmt 1742033846
I. 10/30 07:15:19. 0000036578 PostCmt 0
I. 10/30 07:15:19. 0000035735 Exception Thrown from s_blockmap.cxx:4497, Err# 0, tid 2141 origtid 2141
I. 10/30 07:15:19. 0000035735 O/S Err#: 0, ErrID: 2096 (s_nodbspaceexception); SQLCode: -1009170, SQLState: 'QSB66', Severity: 14
I. 10/30 07:15:19. 0000035735 [20223]: You have run out of space in iq_main DBSpace.
-- (s_blockmap.cxx 4497)

=========

The procedure sp_iqstatus was reporting 78%:

=========

Main IQ Blocks Used: 646814875 of 826261725, 78%=4934Gb, Max Block#: 1219370619

==========


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

sp_iqstatus You have run out of space in iq_main DBSpace IQ_SYSTEM_MAIN Main IQ Blocks Used , 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.