Amazon RDS for Db2 參數

您可以執行 describe-engine-default-parameters 命令來檢視 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}'

若要檢視資料庫參數群組的參數值，請搭配下列必要參數使用 DescribeDBParameters 作業。