Modifying a Stage of a Resource Management Plan

Function

This API is used to modify a stage of a resource management plan.

Calling Method

For details, see Calling APIs.

URI

PUT /v2/{project_id}/clusters/{cluster_id}/workload/plans/{plan_id}/stages/{stage_id}

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
cluster_id	Yes	String	Definition Cluster ID. For details about how to obtain the value, see Obtaining the Cluster ID. Constraints The value must be a valid DWS cluster ID. Range It is a 36-digit UUID. Default Value N/A
plan_id	Yes	String	Definition Plan ID. Constraints N/A Range N/A Default Value N/A
stage_id	Yes	String	Definition Plan stage ID. Constraints N/A Range N/A Default Value N/A

Request Parameters

**Table 2** Request body parameters
Parameter	Mandatory	Type	Description
workload_plan_stage	No	workload_plan_stage object	Definition Details of the resource management plan stage Range N/A

**Table 3** workload_plan_stage
Parameter	Mandatory	Type	Description
day	No	String	Definition Date. Range N/A
month	No	String	Definition Month Range N/A
stage_name	No	String	Definition Plan stage Range N/A
start_time	No	String	Definition Start time Range N/A
end_time	No	String	Definition End time. Range N/A
queue_list	No	Array of QueueResourceItem objects	Definition Resource queue Range N/A

**Table 4** QueueResourceItem
Parameter	Mandatory	Type	Description
queue_name	Yes	String	Definition Resource pool name. Range N/A
queue_resources	Yes	Array of WorkloadResourceItem objects	Definition Resource configuration queue. Range N/A

**Table 5** WorkloadResourceItem
Parameter	Mandatory	Type	Description
resource_name	Yes	String	Definition Resource name. Constraints N/A Range cpu: percentage of CPU time cpu_limit: percentage of CPU cores memory: percentage of available memory resources on each data node concurrency: number of concurrent queries shortQueryConcurrencyNum: number of concurrent simple statements weight: weight for network scheduling Default Value N/A
resource_value	Yes	Integer	Definition Resource attribute value. Constraints N/A Range The value range varies according to the value of resource_name. If resource_name is cpu, the value is an integer from 1 to 99. If resource_name is cpu_limit, the value is an integer from 0 to 100. The value 0 indicates no limit. If resource_name is memory, the value is an integer from 0 to 100. The value 0 indicates that no limit. If resource_name is concurrency, the value is an integer from 1 to 2147483647. The value -1 or 0 indicates no limit. If resource_name is shortQueryConcurrencyNum, the value is an integer from -1 to 2147483647. The value -1 or 0 indicates no limit. If resource_name is weight, the value is an integer from 1 to 2147483647. The default value is -1. Default Value N/A
value_unit	No	String	Definition Resource attribute unit. Constraints N/A Range N/A Default Value N/A
resource_description	No	String	Definition Additional resource description. Constraints N/A Range N/A Default Value N/A

Response Parameters

Status code: 200

**Table 6** Response body parameters
Parameter	Type	Description
workload_res_code	Integer	Definition Result status code. Range N/A
workload_res_str	String	Definition Result description. Range N/A
workload_plan_stage	PlanStage object	Definition Plan stage details. Range N/A

**Table 7** PlanStage
Parameter	Type	Description
month	String	Definition Month. Range N/A
day	String	Definition Date. Range N/A
plan_id	String	Definition Plan ID. Range N/A
stage_id	String	Definition Plan stage ID. Range N/A
stage_name	String	Definition Plan stage name. Range N/A
start_time	String	Definition Start time of the plan. Range N/A
end_time	String	Definition End time. Range N/A
next_valid_time	String	Definition Next validation time. Range N/A
queue_list	Array of QueueResourceItem objects	Definition Resource queue list. Range N/A

**Table 8** QueueResourceItem
Parameter	Type	Description
queue_name	String	Definition Resource pool name. Range N/A
queue_resources	Array of WorkloadResourceItem objects	Definition Resource configuration queue. Range N/A

**Table 9** WorkloadResourceItem
Parameter	Type	Description
resource_name	String	Definition Resource name. Constraints N/A Range cpu: percentage of CPU time cpu_limit: percentage of CPU cores memory: percentage of available memory resources on each data node concurrency: number of concurrent queries shortQueryConcurrencyNum: number of concurrent simple statements weight: weight for network scheduling Default Value N/A
resource_value	Integer	Definition Resource attribute value. Constraints N/A Range The value range varies according to the value of resource_name. If resource_name is cpu, the value is an integer from 1 to 99. If resource_name is cpu_limit, the value is an integer from 0 to 100. The value 0 indicates no limit. If resource_name is memory, the value is an integer from 0 to 100. The value 0 indicates that no limit. If resource_name is concurrency, the value is an integer from 1 to 2147483647. The value -1 or 0 indicates no limit. If resource_name is shortQueryConcurrencyNum, the value is an integer from -1 to 2147483647. The value -1 or 0 indicates no limit. If resource_name is weight, the value is an integer from 1 to 2147483647. The default value is -1. Default Value N/A
value_unit	String	Definition Resource attribute unit. Constraints N/A Range N/A Default Value N/A
resource_description	String	Definition Additional resource description. Constraints N/A Range N/A Default Value N/A

Example Requests

put https://{Endpoint}/v2/89cd04f168b84af6be287f71730fdb4b/clusters/e59d6b86-9072-46eb-a996-13f8b44994c1/workload/plans/0c2145ad-4d76-4abe-bd1b-cdbe9128478a/stages/00bc8bc5-c885-42e5-b205-80547d3f94c4

{
  "workload_plan_stage" : {
    "day" : "1",
    "month" : "1",
    "stage_name" : "stage1",
    "start_time" : "00:00:00",
    "end_time" : "00:00:00",
    "queue_list" : [ {
      "queue_name" : "test_1",
      "queue_resources" : [ {
        "resource_name" : "cpu",
        "resource_value" : 80
      }, {
        "resource_name" : "cpu_limit",
        "resource_value" : 0
      }, {
        "resource_name" : "memory",
        "resource_value" : 0
      }, {
        "resource_name" : "concurrency",
        "resource_value" : 10
      }, {
        "resource_name" : "shortQueryConcurrencyNum",
        "resource_value" : -1
      }, {
        "resource_name" : "weight",
        "resource_value" : -1
      } ]
    } ]
  }
}

Example Responses

Status code: 200

Stage information of the resource management plan modified.

{
  "workload_plan_stage" : {
    "day" : "1",
    "month" : "1",
    "stage_name" : "stage1",
    "start_time" : "00:00:00",
    "end_time" : "00:00:00",
    "queue_list" : [ {
      "queue_name" : "test_1",
      "queue_resources" : [ {
        "resource_name" : "cpu",
        "resource_value" : 80
      }, {
        "resource_name" : "cpu_limit",
        "resource_value" : 0
      }, {
        "resource_name" : "memory",
        "resource_value" : 0
      }, {
        "resource_name" : "concurrency",
        "resource_value" : 10
      }, {
        "resource_name" : "shortQueryConcurrencyNum",
        "resource_value" : -1
      }, {
        "resource_name" : "weight",
        "resource_value" : -1
      } ]
    } ]
  }
}

Status Codes

Status Code	Description
200	Stage information of the resource management plan modified.
400	Request error.
401	Authentication failed.
403	You do not have required permissions.
404	No resources found.
500	Internal server error.
503	Service unavailable.