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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.