The parameters controlling the Storage Pool can be modified dynamically, without stopping the Storage Agent, using the SQDCONF utility. Like the initial configuration of the Storage Agent, sequences of SQDCONF commands to modify the storage agent can/should be stored in Shell Scripts. See SQDCONF Utility for a full explanation of each command, their respective parameters and the utility's operational considerations.
Syntax
The following sequence of SQDCONF commands will be used to modify the storage pool managed by the CDCStore Storage agent:
$ sqdconfmodify /<SQDATA_VAR_DIR>/udbcdc/udbcdc_store.cab --number-of-blocks=<blocks_per_file> --number-of-logfiles=<number_of_files> --data-path=<directory_name)
| Keyword | Description |
|---|---|
| <cab_file_name> | This is where the Storage Agent configuration file is stored. There is only one CAB file per Storage Agent. In our example //<SQDATA_VAR_DIR>/udbcdc/oracdc.cab |
| <blocks_per_file> | The number of 8MB blocks that will be allocated for each File defined for transient CDC storage. In our example we started with 32. |
| <number_of_files> | How many files are allocated for transient storage CDC storage. In our example we started with 8. |
| <directory_name> |
The directory(s) created for the transient storage files. In our example the first directory was: /<SQDATA_VAR_DIR>/udbcdc/data |
- Execute the SQDCONF modify command:
$ sqdconf modify /<SQDATA_VAR_DIR>/udbcdc/udbcdc_store.cab --number-of-blocks=40 --number-of-logfiles=20 --data-path=/<SQDATA_VAR_DIR>/udbcdc/data - Execute the SQDCONF display command:
$ sqdconfdisplay /<SQDATA_VAR_DIR>/udbcdc/udbcdc_store.cab --details - Modify the value of --number-of-blocks=<blocks_per_file>will only affect new files allocated.
- Changes to the value of --number-of-logfiles=<number_of_files> to take affect immediately.
- Add Storage pool directories using --data-path=<directory_name) will be used only after all --number-of logfiles=<number_of_files> have been created and filled.
- No files or Directories once allocated and used will be freed or released by the Storage Agent while it is running.