SAP Knowledge Base Article - Preview

2705567 - Several MPX nodes hang for hours, huge number of versions seen -SAP IQ

Symptom

  • Coordinator unresponsive
  • Several or all secondary servers unresponsive
  • sp_iqversionuse shows tens of  thousands of versions
  • High user dbspace usage due to the huge number of versions
  • pstacks taken on the unresponsive servers show lots of st_txnMgr::WaitForTLVReplay

One of these client software are used to run queries on SAP IQ.

  • WinSQL 
  • SAS program 


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

WinSQL, SAS, SAS_MM, Multiplex, coordinator, secondary, nodes, unresponsive, st_txnMgr::WaitForTLVReplay, TLV, Replay, version, transaction, ID, sp_iqversionuse, sp_iqcontext, sp_iqtransaction , 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.