|
Modifying Transient Storage Pool |
Scroll |
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:
$ sqdconf modify /<SQDATA_VAR_DIR>/udbcdc1/udbcdc1_store.cab --number-of-blocks=<blocks_per_file> --number-of-logfiles=<number_of_files> --data-path=<directory_name)
Keyword and Parameter Descriptions
<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>/udbcdc1/udbcdc1.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
Example
Execute the SQDCONF modify command:
$ sqdconf modify /<SQDATA_VAR_DIR>/udbcdc1/udbcdc1_store.cab
--number-of-blocks=40 --number-of-logfiles=20
--data-path=/<SQDATA_VAR_DIR>/udbcdc1/data
Execute the SQDCONF display command:
$ sqdconf display /<SQDATA_VAR_DIR>/udbcdc1/uudbcdc1_store.cab --details
Notes:
1.Modifying the value of --number-of-blocks=<blocks_per_file> will only affect new files allocated.
2.Changes to the value of --number-of-logfiles=<number_of_files> take affect immediately
3.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.
4.No files or Directories once allocated and used will be freed or released by the Storage Agent while it is running.
