Please enable JavaScript to view this site.

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>

[--reset-stats]

 

Keyword and Parameter Descriptions

<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.

[--reset-stats] - Reset cumulative statistics for the CDCStore.

Notes:

1.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.

2.Changing --number-of-logfiles=<number_of_files> takes effect immediately

3.Changing --number-of-blocks=<blocks_per_file>  only affects new files allocated.

4.Storage Pool Directories added using --data-path=<directory_name) will be used only after all --number-of-logfiles=<number_of_files>  have been created and filled.

5.Files or Directories once allocated and used will not be freed or released by the Storage Agent while it is running.