SAP Knowledge Base Article - Preview

2616593 - Error: There is insufficient reserve space to add -SAP IQ

Symptom

  • Extending IQ dbspace using command
    ALTER DBSPACE <dbspacename> ALTER FILE <filename> add <size>
  • Failed with error:

Could not execute statement.
There is insufficient reserve space to add XXX blocks to segment
/path/myiq_file1.iq. Only 0 blocks or less may be added.
-- (slib/s_db.cxx 4099)
SQLCODE=-1009157, ODBC 3 State="HY000"


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

sybase, SAP IQ, -1009157, 1009157, space, reserve, alter dbspace, alter file, insufficient reserve space, dbspace , KBA , BC-SYB-IQ , Sybase IQ , How To

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.