Dropping a Spooled Row Data sbspace

Important: Do not drop an Enterprise Replication row data sbspace using the onspaces -d -f (force) command.

You can drop a row data sbspace if you have more than one sbspace specified by the CDR_QDATA_SBSPACE configuration parameter.

To drop a row data sbspace

  1. Shutdown the database server.
  2. Remove the sbspace from the CDR_QDATA_SBSPACE configuration parameter value list.
  3. Start the database server in recovery mode.
  4. Wait for all the smart large objects to get deleted from the sbspace. Use the onstat -g smb lod command to check for smart large objects stored in a sbspace.
  5. If the sbspace was added from the storage pool, use the drop sbspace to storagepool argument with the admin() or task() function to return the empty sbspace to the storage pool.
Parent topic: Row Data sbspaces
Related information:
drop sbspace to storagepool argument: Return space from an empty sbspace to the storage pool (SQL administration API)
Copyright© 2018 HCL Technologies Limited