Enabling or Disabling a SQL Statement Concurrency Control Rule or Disabling All SQL Statement Concurrency Control Rules

Function

This API is used to enable or disable a SQL statement concurrency control rule or disable all SQL statement concurrency control rules.

• Before calling an API, you need to understand the API in Authentication.

URI

• URI format

  PUT /v3/{project_id}/instances/{instance_id}/sql-limit/switch

• Parameter description

  Table 1 Parameters

  Parameter	Mandatory	Description
  project_id	Yes	Project ID of a tenant in a region. To obtain it, refer to Obtaining a Project ID.
  instance_id	Yes	Instance ID.

Request

Example Request

Open a SQL statement concurrency control rule.

PUT https://rds.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/ 49b9dd1d6f464ba4bc91df5cbd2e52ebin03/sql-limit/switch

{ 
   "db_name" : "postgres", 
   "id" : "1", 
   "action" : "open" 
 }

Response

• Normal response

  Table 3 Parameters

  Parameter	Type	Description
  resp	String	Returns successful if the invoking is successful.

• Example normal response

  { 
     "resp" : "successful" 
   }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.