Symptom
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 N (NULL)
- Reboot and restart IQ does not remove the active version.
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
Keywords
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.