SAP Knowledge Base Article - Preview

3776359 - Understanding the Difference Between MDA Table BatchID and show_plan() BatchID - SAP ASE

Symptom

  • The BatchID reported for a running statement differs between MDA tables and the internal function show_plan().
  • show_plan() returns a value approximately twice as large as the MDA tables BatchID.


Read more...

Environment

SAP Adaptive Server Enterprise 16.1 and later

Product

SAP Adaptive Server Enterprise 16.1

Keywords

BatchID mismatch, MDA tables, show_plan function, SQL Text structure, SPID BatchID, Adaptive Server Enterprise, ASE 16.1, database monitoring, query execution, statement processing, memory pool reuse, SQL parser, running statement, monitoring tools, database issue, troubleshooting , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.