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.