Amazon RDS for Db2 参数

可以通过运行 describe-engine-default-parameters AWS CLI 命令，来查看 Db2 版本的数据库管理器配置参数和注册表变量。为 --db-parameter-group-family 选项指定下列值之一：

例如，要查看 Db2 Standard Edition 11.5 的参数，请运行以下命令：

aws rds describe-engine-default-parameters --db-parameter-group-family db2-se-11.5

此命令生成类似于以下示例的输出：

{
    "EngineDefaults": {
        "Parameters": [
            {
                "ParameterName": "agent_stack_sz",
                "ParameterValue": "1024",
                "Description": "You can use this parameter to determine the amount of memory that is allocated by Db2 for each agent thread stack.",
                "Source": "engine-default",
                "ApplyType": "static",
                "DataType": "integer",
                "AllowedValues": "256-32768",
                "IsModifiable": false
            },
            {
                "ParameterName": "agentpri",
                "ParameterValue": "-1",
                "Description": "This parameter controls the priority given to all agents and to other database manager instance processes and threads by the operating system scheduler. This priority determines how CPU time is allocated to the database manager processes, agents, and threads relative to other processes and threads running on the machine.",
                "Source": "engine-default",
                "ApplyType": "static",
                "DataType": "integer",
                "AllowedValues": "1-99",
                "IsModifiable": false
            },
            ...
        ]
    }
}

要仅列出 Db2 Standard Edition 11.5 的可修改参数，请运行以下命令：

对于 Linux、macOS 或 Unix：

aws rds describe-engine-default-parameters \
    --db-parameter-group-family db2-se-11.5 \
    --query 'EngineDefaults.Parameters[?IsModifiable==`true`].{ParameterName:ParameterName, DefaultValue:ParameterValue}'

对于 Windows：

aws rds describe-engine-default-parameters ^
    --db-parameter-group-family db2-se-11.5 ^
    --query 'EngineDefaults.Parameters[?IsModifiable==`true`].{ParameterName:ParameterName, DefaultValue:ParameterValue}'

要查看数据库参数组的参数值，请使用带下列所需参数的 RDS API DescribeDBParameters 命令。