SAP Knowledge Base Article - Preview

2280631 - When MAX_TEMP_SPACE set too small, can't operate the database

Symptom

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.

ex:

$ 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
  select 1


Read more...

Environment

  • SAP IQ 15.2 and later
  • SAP IQ 16.x

Product

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

Keywords

IQ, MAX_TEMP_SPACE, 16.0, 16.1, "Temporary space limit exceeded", option , 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.