2461259 - TEMP Space Not Freed -SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2461259 - TEMP Space Not Freed -SAP IQ

Symptom

  • When using temp tables, the TempTableSpaceKB is NOT cleared between jobs. Instead, it is only cleared when the connection is closed.

  • For example:

    1. Run the following stored procedure:

create or replace procedure LastDailyUpdate ()
begin
     declare local temporary table #datefile (
          prefix varchar(64) not null
     ) on commit preserve rows;
end;

    1. Next, check TempTableSpaceKB, and the following will be displayed:

select TempTableSpaceKB, TempWorkSpaceKB from sp_iqconnection()
go

TempTableSpaceKB     TempWorkSpaceKB

----------------------          -------------------------------

            19200                      0


Read more...

Environment

SAP IQ 16.0.

Product

SAP IQ 16.0

Keywords

TempTableSpace, space, not released. space not released , 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.