SAP Knowledge Base Article - Preview

2440342 - IQ_SHARED_TEMP used blocks not cleaned fast enough if DQP query aborts -- SAP IQ

Symptom

User aborts DQP query in progress and terminates connection. "sp_iqsharedtempdistrib()" show ACTIVE versions whereas "sp_iqversionuse()" do not show any of these versions on any of the multiplex nodes.

 >> Monitoring ;

      After couple of minutes of aborting DQP query. Version 1620669 stays there for long time.

      sp_iqsharedtempdistrib ;


              Server_id DBSpace_name           Unit_type           VersionID       NBlocks
            ----------------------------------------------------------------------------------
                2 IQ_SHARED_TEMP                  ACTIVE             1620669          6400


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

dqp , IQ_SHARED_TEMP , sp_iqsharedtempdistrib, "run out of space" , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.