SAP Knowledge Base Article - Preview

2448121 - Failed to resize the dbfile in IQ.


Failed to resize the dbfile after deleting the data on dbfile.

> alter dbspace main_dbspace alter file main_file01 size 10GB;

"Cannot resize segment /IQ/dbspace/ since the truncated region is in use. --(s_db.cxx 2911) SQLCode=-1009158, ODBC 3 status="HY000"".



  • SAP IQ16.0
  • SAP IQ15.4


SAP IQ 16.0 ; SAP Sybase IQ 15.4


IQ, SYBASE, resize, dbfile, dbspace, segment, s_db.cxx, truncated, in us, reduce, alter dbspace, alter , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.