SAP Knowledge Base Article - Preview

2871739 - In versions other than IQ16.0 SP08 to SP08PL24, wide column VARCHAR columns require a large number of IQ_SYSTEM_TEMP

Symptom

When a VARCHAR (10000) column is used for the JOIN key, the optimizer will request a TEMP over 35TB.
As a result, the UPDATE statement fails.


dbisql -c "uid=dba;pwd=sql" -nogui update.sql
Could not execute statement.
You have run out of space in IQ_SYSTEM_TEMP DBSpace.
--
(slib/s_blockmap.cxx 5951)
SQLCODE=-1009170, ODBC 3 State="HY000"
File: "update.sql" on line 8, column 1
UPDATE table2 m
SET
column22 = coalesce(tmp.column22,0)
, column24 = coalesce(tmp.column24,0)
FROM (
...

#9 Root of an UPDATE
Child Node 1 #10
Estimated Result Rows xxx,xxx,xxx
Query_Name QUERY_PLAN
User Name usr1 (SA connHandle: 123 SA connID: 10)
Est. Temp Space Used (Mb) 36730876.0


Read more...

Environment

  •  All versions except SAP IQ16.0 SP08 to SP08PL24

Product

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

Keywords

IQ, SP08, VARCHAR, IQ_SYSTEM_TEMP, width minimization optimization,  1009170, UPDATE, JOIN, wide colmun , 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 ONE Support launchpad (Login required).

Search for additional results

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