Adjusting the size of the CDCStore transient storage area allows you to control how much memory and disk space is allocated for Change Data Capture (CDC) replication.
Important: When modifying the transient storage pool, make sure to specify the location of the storage cab file.
Syntax
sqdconf modify <cab_file_name>
--number-of-blocks=<blocks_per_file>
--number-of-logfiles=<number_of_files>
--data-path=<directory_name>
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <cab_file_name> | This parameter is required and must match the name used in the previous Create command. |
| [--number-of-blocks=<blocks_per_file> | -b <blocks_per_file>] | Specifies the new number of 8MB blocks allocated for each file used for transient CDC storage. |
| [--number-of-logfiles=<number_of_files> | -n <number_of_files>] | Sets the new number of files that can be allocated in a data path. Files are allocated as needed, one full file at a time, during storage agent operation. CDCStore will reuse blocks when possible before allocating new storage. |
| --data-path=<directory_name> | Specifies the path and directory name of the transient storage area to be modified. If there are multiple --data-path entries, each must be modified separately. The directory must already exist, and the user ID associated with the agent must have permission to create and delete files in that directory. |
Note:
- Unlike the Capture and Publisher configuration files, changes to the CDCStore configuration file take effect immediately. You do not need to perform the usual sequence.
- When you change
--number-of-logfiles=<number_of_files>, the update is applied immediately. - When you change
--number-of-blocks=<blocks_per_file>, the new value only applies to files that are allocated after the change. - Storage Pool Directories added with
--data-path=<directory_name>will only be used after all previously allocated files have been created and filled. - Files or directories that have already been allocated and used will not be freed or released by the Storage Agent while it is running.