2461259 - TEMP Space Not Freed -SAP IQ

• 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;

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

select TempTableSpaceKB, TempWorkSpaceKB from sp_iqconnection()
go

TempTableSpaceKB     TempWorkSpaceKB

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

            19200                      0

SAP IQ 16.0.

TempTableSpace, space, not released. space not released , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed