SAP Knowledge Base Article - Preview

2747189 - Cannot drop empty dbspace even after IQ reboot - SAP IQ


Cannot drop an empty dbspace.

  • All the objects listed by sp_iqdbspaceobjectinfo '<dbspace_to_drop>' have been dropped.
  • sp_iqdbspace still shows active version in BlkType

(DBA)> sp_iqdbspace <dbspace_to_drop>
DBSpaceName           DBSpaceType Writable Online Usage TotalSize Reserve NumFiles NumRWFiles Stripingon StripeSize   BlkTypes   OkToDrop   lsname
<dbspace_to_drop>   MAIN                     T            T          1         36G      0B           3               3                    T             512K            3H,91A                   (NULL)

  • Reboot and restart IQ does not remove the active version.



  • SAP IQ 16.0
  • SAP IQ 16.1


SAP IQ 16.0 ; SAP IQ 16.1


dropleaks, OkToDrop, active version , BlkTypes, restart, dropleaks, "Blocks Leaked", leaks, leak, , 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 ONE Support launchpad (Login required).

Search for additional results

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