Create a global or local temporary table and insert rows in it.
Disconnect should release all the temp blocks used by this temp table.
Reconnect and run sp_iqstatus, you will see that not all the temp blocks previously used are released.
If you use many temp tables, you could get the error "You have run out space in IQ_SYSTEM_TEMP dbspace".
IQ 16 SP 8 Any platform.
It used to work fine on IQ 15.
CR# 765824, 765824, CR# 780365, 780365, global, local, temp, temporary, table, block, leak, run out space, IQ_SYSTEM_TEMP, dbspace , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.