SAP Knowledge Base Article - Preview

2448121 - Failed to resize the dbfile in IQ.

Symptom

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

> alter dbspace main_dbspace alter file main_file01 size 10GB;

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


Read more...

Environment

  • SAP IQ16.0
  • SAP IQ15.4

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

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.