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.