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
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.