/AWS1/CL_RDS=>RESETDBPARAMETERGROUP()
¶
About ResetDBParameterGroup¶
Modifies the parameters of a DB parameter group to the engine/system default value.
To reset specific parameters, provide a list of the following:
ParameterName
and ApplyMethod
. To reset the entire DB
parameter group, specify the DBParameterGroup
name and
ResetAllParameters
parameters. When resetting the entire group, dynamic
parameters are updated immediately and static parameters are set to
pending-reboot
to take effect on the next DB instance restart or
RebootDBInstance
request.
Method Signature¶
IMPORTING¶
Required arguments:¶
IV_DBPARAMETERGROUPNAME
TYPE /AWS1/RDSSTRING
/AWS1/RDSSTRING
¶
The name of the DB parameter group.
Constraints:
Must match the name of an existing
DBParameterGroup
.
Optional arguments:¶
IV_RESETALLPARAMETERS
TYPE /AWS1/RDSBOOLEAN
/AWS1/RDSBOOLEAN
¶
Specifies whether to reset all parameters in the DB parameter group to default values. By default, all parameters in the DB parameter group are reset to default values.
IT_PARAMETERS
TYPE /AWS1/CL_RDSPARAMETER=>TT_PARAMETERSLIST
TT_PARAMETERSLIST
¶
To reset the entire DB parameter group, specify the
DBParameterGroup
name andResetAllParameters
parameters. To reset specific parameters, provide a list of the following:ParameterName
andApplyMethod
. A maximum of 20 parameters can be modified in a single request.MySQL
Valid Values (for Apply method):
immediate
|pending-reboot
You can use the immediate value with dynamic parameters only. You can use
thepending-reboot
value for both dynamic and static parameters, and changes are applied when DB instance reboots.MariaDB
Valid Values (for Apply method):
immediate
|pending-reboot
You can use the immediate value with dynamic parameters only. You can use
thepending-reboot
value for both dynamic and static parameters, and changes are applied when DB instance reboots.Oracle
Valid Values (for Apply method):
pending-reboot