3469261 - The msg "IQ_SYSTEM_TEMP dbspace does not have dbfiles for this server" raises on a secondary node of IQ multiplex

Symptom

Run 'sp_iqdbspace' or other store procedure on secondary node in multiplex environment gets error:

(dba)> sp_iqdbspace
Could not execute statement.
The IQ_SYSTEM_TEMP dbspace does not have dbfiles for this server.
--
(slib/s_blockmap.cxx 6041)
SQLCODE=-1009128, ODBC 3 State="HY000"

Line 1, column 1
sp_iqdbspace

(Continuing after error)

Environment

SAP IQ

Product

SAP IQ 16.1

Keywords

IQ_SYSTEM_TEMP, dbfile, dbspace does not have dbfiles for this server, multiplex, dbfiles , 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.