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 for Me (Login required).

Search for additional results

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