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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.