SAP Knowledge Base Article - Preview

2243336 - "You have run out of space in IQ_SYSTEM_TEMP DBSpace" during sp_iqcheckdb - SAP IQ

Symptom

sp_iqcheckdb reports "Unknown Exceptions" as follows:

I. 11/13 16:14:44. 0000000023 DBCC Check Mode Report:
I. 11/13 16:14:44. 0000000023 ** DBCC Status: Leaked block checking skipped due to errors  ******
I. 11/13 16:14:44. 0000000023 ** DBCC Status: Errors Detected  ******
I. 11/13 16:14:44. 0000000023 ** DBCC Unknown Exceptions: 2  ******...

The following messages also appear in the iqmsg:

I. 11/13 16:14:47. 0000000023 [20223]: You have run out of space in IQ_SYSTEM_TEMP DBSpace.
-- (slib/s_blockmap.cxx 5172)
I. 11/13 16:14:47. 0000000023 DBCC: Statistics check detected exception from INDEX { DBA.y2.ASIQ_IDX_T1007_C1_FP }
I. 11/13 16:14:47. 0000000023 [20223]: You have run out of space in IQ_SYSTEM_TEMP DBSpace.
-- (slib/s_blockmap.cxx 5098)


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.