SAP Knowledge Base Article - Preview

2643865 - Many retry in DQP work units and slow performance case - SAP IQ

Symptom

Customer saw a DQP query processing was slow with many retries in work-units.
Below copy is part of customer's HTML Plan.

#181 Order By
Generated Result Rows	85
Estimated Result Rows	14,440,014
Fragment ID	2
Optimization Note	Parallel sort load
Work Units - nodexx1	53 (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)
Work Units - nodexx3	32/30 (1, 1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 0)
Max. Possible Parallel Arms	96
Max. Active Parallel Threads	85
Parallel Sink Work Units	85
First Worker Work Unit	29

Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

"Retry work unit" ; "Retry workunit" ;"Retry work-unit" ;"DQP retry" ; , KBA , BC-SYB-IQ , Sybase IQ , How To

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.