SAP Knowledge Base Article - Preview

2840371 - alter dbsapce is returning error - Logical file 'IQ_SYSTEM_MSG' is not part of dbspace 'IQ_SYSTEM_MSG' - SAP IQ

Symptom

  • On a secondary (writer) node when trying to alter the IQ_SYSTEM_MSG file:

alter dbspace IQ_SYSTEM_MSG alter file IQ_SYSTEM_MSG rename path '/full/path/myiq_W.iqmsg'
Could not execute statement.
  Logical file  'IQ_SYSTEM_MSG' is not part of dbspace 'IQ_SYSTEM_MSG'
  SQLCODE=-1249, ODBC 3 State="HY000"
  Line 1, column 1
  alter dbspace IQ_SYSTEM_MSG alter file IQ_SYSTEM_MSG rename path '/full/path/myiq_W.iqmsg'
Press ENTER to continue...

  • This command works fine when running on the Coordinator node and on a simplex system.


Read more...

Environment

  • SAP IQ 15.X
  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

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.