2539362 - How to enable HTML Query Plan for maintenance user in Replicate IQ Database? -SAP IQ and SRS

Symptom

To diagnose transaction performance in IQ Database as a replicate database, it is important to know how to generate RELEVANT Query Plans.

Query plans help diagnostics from IQ perspective. For example, it allows to display query texts, indexes used, join alogorithms used, etc.

Environment

SAP Replication Server (SRS) 16.0
SAP Replication Server (SRS) 15.7.1
SAP Replication Server Real Time Loading (RTL) 15.7.1
SAP Replication Server Heterogeneous Edition 15.7.1
SAP IQ 16.x.
SAP IQ 15.x

Product

SAP IQ 16.0 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for IBM DB2 ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; SAP Sybase Replication Server 15.7, option for Oracle ; SAP Sybase Replication Server 15.7, real-time loading edition

Keywords

IQ maintenance user, RTL, performance, query plan, queryplan, Query_Timing, Query_Detail, Dml_Options10, replication serevr, SRS , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , 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.