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.