CDR_QDATA_SBSPACE Configuration Parameter

Specifies the list of up to 32 names of sbspaces that Enterprise Replication uses to store spooled transaction row data.

onconfig.std value
none
separators
comma
range of values
up to 128 characters for each sbspace name; up to 32 sbspace names. Use a comma to separate each name in the list. At least one sbspace name must be specified.
takes effect
when the database server is shut down and restarted or immediately for the following actions:
  • Adding a value using the cdr add onconfig command
  • Removing a value using the cdr remove onconfig command
  • Changing a value using the cdr change onconfig command

The CDR_QDATA_SBSPACE configuration parameter specifies the list of up to 32 names of sbspaces that Enterprise Replication uses to store spooled transaction row data. Enterprise Replication creates one smart large object per transaction. The sbspaces must be used only for Enterprise Replication. If CDR_QDATA_SBSPACE is configured for multiple sbspaces, then Enterprise Replication uses all appropriate sbspaces in round-robin order.

Important: You must set the CDR_QDATA_SBSPACE configuration parameter and create the sbspaces specified by CDR_QDATA_SBSPACE before defining a server for replication. If the configuration parameter is not set in the onconfig file or the sbspace names specified by CDR_QDATA_SBSPACE are invalid, Enterprise Replication fails to define the server. For more information, see Row Data sbspaces and Defining Replication Servers.
You can have Enterprise Replication automatically configure disk space from the storage pool and set the CDR_QDATA_SBSPACE configuration parameter when defining a replication server. If the CDR_QDATA_SBSPACE configuration parameter is not set and the database server has a storage pool with sufficient space, the cdr define server command automatically creates the necessary disk space and sets the configuration parameter to the appropriate value in memory and the onconfig file. For clusters, the cdr define command creates new sbspaces and sets the CDR_QDATA_SBSPACE configuration parameters in all secondary database servers, as well.
Note: A database server's storage pool must have 500 MB of free space for the sbspace. The sbspace must be comprised of chunks of size 100 MB or greater for the database server to use automatic storage provisioning.
Warning: Do not change the value of CDR_QDATA_SBSPACE while Enterprise Replication is running.