SAP Knowledge Base Article - Preview

3431341 - Performance slow down and unresponsiveness - SAP IQ

Symptom

IQ server runs longer then it gets slower, and only a restart of the instance and node will help performance return. The logs (IQ and OS) do not report any errors.

This a SIMPLEX environment.

In the pstacks,  we can see some threads with stack functions about memory allocation functions like these:

=====

Thread 1111
__lll_lock_wait
_L_lock_883
pthread_mutex_lock
hos_memmgr::AllocHosMem
.....
.....
Thread 2222
__lll_lock_wait
_L_lock_883
pthread_mutex_lock
hos_memmgr::AllocHosMem
s_subPartitionRangeWorkAllocator::s_subPartitionRangeWorkAllocator
vpp::ExecuteParallelFind
vpp_Compares::ExecuteOpus
vpp::Execute
....
....

=======


Read more...

Environment

SAP IQ 16.1 SP04 PL12

Keywords

__lll_lock_wait _L_lock_883 pthread_mutex_lock hos_memmgr::AllocHosMem performance slow down unresponsiveness 829080 CR 829080 CR829080 CR#829080 , 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.