When you set a too small value to MAX_TEMP_SPACE of SAP IQ, the database can't operate.
ex: SET OPTION PUBLIC.MAX_TEMP_SPACE = 5120
After change to the too small value, this value can not be set back to 0(default).
As a result, the database can't operate.
$ dbisql -c "uid=dba;pwd=sql;eng=iqdemo" -nogui
()> select 1
Could not execute statement.
Temporary space limit exceeded
SQLCODE=-1000, ODBC 3 State="HY000"
Line 1, column 1
- SAP IQ 15.2 and later
- SAP IQ 16.0
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.