Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
Enterprise ReplicationThe HCL OneDB™ Enterprise Replication Guide describes the concepts of data replication using HCL® OneDB® Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Setting up and managing Enterprise ReplicationAfter you design your replication system, you define it and start replication.
Preparing the Replication EnvironmentThe following topics explain the steps that are required for setting up Enterprise Replication.
Preparing the DiskThese topics describe how to prepare your disk for Enterprise Replication.
Setting Up Send and Receive Queue Spool Areas
Row Data sbspacesReplicated data might include UDT and CLOB or BLOB data types. Therefore, the spooled row data is stored as smart large objects in one or more sbspaces.
Dropping a Spooled Row Data sbspace

Dropping a Spooled Row Data sbspace

About this task

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

Procedure

Shutdown the database server.
Remove the sbspace from the CDR_QDATA_SBSPACE configuration parameter value list.
Start the database server in recovery mode.
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.
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.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.