Symptom
A query with "... LIKE '%...' " pattern matching encounters a session hang or goes to defunct mode. Finally IQ must be killed, because 'stop_iq' doesn't work.
While problem session is in pending mode, stack dump shows like this,
===== Thread Number ... =====
..
.. <unknown>
.. hos_basic_mbtext<unsigned char*, int, int>::regexp_match( ..
.. hos_basic_mbtext<unsigned char*, int, int>::Like( ..
.. s_dpNBitFetch::Find( ..
.. hs_dp::ConstructLookupFind( ..
.. vpp::ExecuteParallelFind( ..
.. vpp_Like::ExecutePartialMatch( ..
.. vpp_Like::ExecuteOpus( ..
..
Read more...
Environment
SAP IQ16.1 SP05 PL06
Product
Keywords
Like , defunct, unresponsive, zombie , , 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.