SAP Knowledge Base Article - Preview

3275680 - BCP OUT and IQ_SYSTEM_TEMP is OUT OF SPACE - SAP IQ

Symptom

BCP OUT on large tables is causing IQ_SYSTEM_TEMP is OUT OF SPACE.

======

Allocation failed. Dbspace IQ_SYSTEM_TEMP is OUT OF SPACE
.....
.....
** Command text: select * from "DBA"."tab01"
.....
.....
Query Plan:
#02: Root
Child Node 1: #03
Estimated Result Rows: 5,854,932,063
....
....
Est. Temp Space Used (Mb): 8920093.8
Cursor Name: __tds_cursor
Requested attributes: Scroll Read Only Hold Unchained

======


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

BCP OUT IQ_SYSTEM_TEMP  OUT OF SPACE Scroll Read Only Hold Unchained No Scroll __tds_cursor tds_cursor option FORCE_NO_SCROLL_CURSORS , 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.