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 for Me (Login required).

Search for additional results

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