SAP Knowledge Base Article - Preview

2087784 - ALTER DBSPACE .. DROP FILE SQL statement is not allow Multiple File clause for SYSTEM dbspace -- SAP IQ

Symptom

If you run ALTER DBSPACE .. DROP FILE SQL statement that drops the multiple file in IQ_SYSTEM_MAIN , IQ_SYSTEM_TEMP or IQ_SHARED_TEMP dbspace, it will fail with an error.

Example

ALTER DBSPACE IQ_SHARED_TEMP
DROP FILE IQ_SHARED_TEMP3, FILE IQ_SHARED_TEMP4

Error message

Multiple FILE clauses are not allowed for this command.
-- ( db_createdb.cxx 3029 )
SQLCODE= -1009181 、ODBC 3 Status= "HY000"
Line 1, Column 1


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

Multiple FILE, Alter DBspace, drop file, 'db_createdb.cxx' , , KBA , BC-SYB-IQ , Sybase IQ , How To

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.