Help Center/ Distributed Database Middleware/ API Reference/ APIs (Recommended)/ DDM Instances/ Querying Parameters of a Specified DDM Instance
Updated on 2022-09-15 GMT+08:00

Querying Parameters of a Specified DDM Instance

Function

This API is used to query parameters of a specified DDM instance.

Constraints

None

URI

GET /v3/{project_id}/instances/{instance_id}/configurations

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID of a tenant in a region

instance_id

Yes

String

DDM instance ID

Table 2 Query parameters

Parameter

Mandatory

Type

Description

offset

No

Integer

Which page the server starts returning items. The start value cannot be less than 0. The default value is 0.

Minimum value: 0

limit

No

Integer

Number of records displayed on each page. The value is greater than 0 and not greater than 128. The default value is 128.

Minimum value: 1

Maximum value: 128

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Language

No

String

Language. The default language is Chinese. zh-cn indicates the language is Chinese. en-us indicates the language is English.

X-Auth-Token

Yes

String

User token

It can be obtained by calling an IAM API. The value of X-Subject-Token in the response header is the user token.

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

updated

String

Time when DDM instance parameters are last updated

configuration_parameter

Array of ConfigurationParameterList objects

Information about DDM instance parameters

offset

Integer

Which page the server starts returning items

limit

Integer

Number of records displayed on each page

total

Integer

Total collections

Table 5 ConfigurationParameterList

Parameter

Type

Description

name

String

Parameter name

value

String

Parameter value

need_restart

String

Whether the instance needs to be restarted

read_only

String

Whether the parameter is read-only

value_range

String

Parameter value range

data_type

String

Parameter type

description

String

Parameter description

Status code: 400

Table 6 Response body parameters

Parameter

Type

Description

errCode

String

Service error code

externalMessage

String

Error message

Status code: 500

Table 7 Response body parameters

Parameter

Type

Description

errCode

String

Service error code

externalMessage

String

Error message

Example Request

GET https://{endpoint}/v3/{project_id}/instances/{instance_id}/configurations

Example Response

Status code: 200

OK

{
  "updated" : "2021-11-09 03:26:52",
  "configuration_parameter" : [ {
    "name" : "temp_table_size_limit,",
    "value" : "1000000,",
    "need_restart" : "0,",
    "read_only" : "0,",
    "value_range" : "500000-2000000000,",
    "data_type" : "integer,",
    "description" : "Maximum size of the temporary table."
  } ],
  "offset" : "0,",
  "limit" : "128,",
  "total" : 22
}

Status code: 400

bad request

{
  "externalMessage" : "Parameter error.",
  "errCode" : "DBS.280001"
}

Status code: 500

server error

{
  "externalMessage" : "Server failure.",
  "errCode" : "DBS.200412"
}

Status Codes

Status Code

Description

200

OK

400

bad request

500

server error

Error Codes

For details, see Error Codes.