Modify the size of the CDCStore transient storage area.
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> | Must be specified and must match the name specified in the previous create command. |
[--number-of-blocks=<blocks_per_file> | -b <blocks_per_file>] | The new number of 8MB blocks allocated for each file defined for transient CDC storage. |
[--number-of-logfiles=<number_of_files> | -n <number_of_files>] | 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 recycles blocks when possible before new storage is allocated. |
--data-path=<directory_name> | The path and directory name of the transient storage area to be modified. If more than one --data-path exists, each one must be individually modified. The directory must exist and the user-id associated with the agent must have the right to create and delete files in that directory. |
Note:
- Unlike the Capture/Publisher configuration files, changes to the CDCStore configuration file take effect immediately and do not require the usual stop/apply/start sequence.
- Changing --number-of-logfiles=<number_of_files> takes effect immediately.
- Changing --number-of-blocks=<blocks_per_file> only affects new files allocated.
- Storage Pool Directories added using --data-path=<directory_name) will be used only after all previously allocate files have been created and filled.
- Files or Directories once allocated and used will not be freed or released by the Storage Agent while it is running.