2813484 - SP_IQMPXINFO show nothing on start with -iqmpx_sn 1 -iqmpx_ov 1 after restore - SAP IQ

Symptom

During the restore of a dump taken from a multiplex server and assuming you follow the steps from the online documentation at the link below:

https://help.sap.com/viewer/a893f37e84f210158511c41edb6a6367/16.0.11.12/en-US/a4d5737584f210158859803145b70072.html?q=Restoring%20IQ%20Store%20Data%20When%20Restoring%20Database%20in%20a%20Different%20Location

When you have done step "4" (Start the restored database with single-node and override flags -iqmpx_sn 1 -iqmpx_ov 1) the output from SP_IQMPXINFO returns nothing.

Environment

SAP IQ 16.0.XX
SAP IQ 16.1.XX

Keywords

SP_IQMPXINFO, secondary nodes, SYSIQMPXSERVER, restore, multiplex , KBA , BC-SYB-IQ , Sybase IQ , 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.