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 parameter files and referenced by SQDPARM DD. See SQDconf Utility for a full explanation of each command, their respective parameters and the utility's operational considerations.
add | modify <cab_file_name>
--data-path=<directory_name)
--number-of-blocks=<blocks_per_file>
--number-of-logfiles=<number_of_files>| 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 /home/sqdata/db2cdc_store.cab |
| <directory_name> |
The ZFS directory(s) previously created for the transient storage files. In our example the original directory was: /home/sqdata/data |
| <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 the default of 32. |
| <number_of_files> |
The number of files that may be allocated in the <directory_name> for transient CDC storage. In our example we started with the default of 8. |
Example 1
Expand the CDCStore by raising the number of files that may be allocated in the existing <directory_name>
//*-------------------------------------------
//* STEP 1: MODIFY A CDCSTORE CAB FILE
//*-------------------------------------------
//MODIFY EXEC PGM=SQDCONF
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
modify /home/sqdata/db2cdc_store.cab
--data-path=/home/sqdata/data
--number-of-blocks=40
--number-of-logfiles=16
//*
//*-------------------------------------------
//* STEP 2: DISPLAY THE CDCSTORE CAB FILE
//*-------------------------------------------
//DISPLAY EXEC PGM=SQDCONF
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
display /home/sqdata/db2cdc_store.cab --details
/*Notes:
- Modifying 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> take affect immediately
- 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.
- No files or Directories once allocated and used will be freed or released by the Storage Agent while it is running.