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

Search for additional results

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