Symptom
What does "Main IQ Blocks Used" mean on sp_iqstatus?
For example, we have the following dbspaces:
======
DBSpaceName DBSpaceType ... Usage TotalSize ...
--------------------------------------------------------------------------
IQ_SYSTEM_MAIN MAIN ... 21 1.55T ...
IQ_SYSTEM_TEMP TEMPORARY ... 1 785G ...
iq_main MAIN ... 95 4.6T ...
...
==========
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% of 'IQ Blcoks Used' :
=========
Main IQ Blocks Used: 646814875 of 826261725, 78%=4934Gb, Max Block#: 121937061
==========
Read more...
Environment
- SAP IQ 15.X
- SAP IQ 16.X
Product
Keywords
sp_iqstatus, "out of space" , iq_main, DBSpace , IQ_SYSTEM_MAIN, sp_iqdbspace, sp_iqfile, , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.