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.0

Product

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

Keywords

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.