2448121 - Failed to resize the dbfile in IQ. | SAP Knowledge Base Article

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

Search for additional results

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