Updating parameters
The update parameters option allows the user to update the current parameter setting. The user can update the retention periods, the partitioning period, tablespace etc.
About this task
Note: The impact of these changes on the system must be considered before implementation.
The updates to a parameter's setting can be limited by type, subtype or table type or table name.
Procedure
The syntax of the update parameters option is as follows:
part_admin -updateparams [-type] [-subtype] [-tabtype] [-filter] [-param] [-value]Example
The following example updates the data_retention to 90 days for all softalarm tables:
part_admin -updateparams -type TABLE -subtype "softalarm" -param data_retention -value 90