Symptom
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".
Read more...
Environment
IQ 16 SP 8 Any platform.
It used to work fine on IQ 15.
Product
Keywords
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 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.