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

SAP Knowledge Base Article - Preview

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.


Read more...

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-ME , Replication Server Messaging Edition (RSME) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

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.