ALTER RESOURCE POOL

Purpose

You can use this statement to modify a resource pool.

Syntax

ALTER RESOURCE POOL {
    pool_name
    UNIT [=] unit_name,
    UNIT_NUM [=] unit_num [DELETE UNIT = (unit_id_list)],
    ZONE_LIST [=] ('zone_name' [, 'zone_name' ...])
 | MERGE
   ('pool_name'[, 'pool_name' ...])
    INTO ('merge_pool_name')
 | SPLIT INTO ('pool_name' [, 'pool_name' ...])
   ON ('zone_name' [, 'zone_name' ...])
};

Parameters

Examples

• You can modify only one attribute of resource pool pool1 at a time. For example, the following statement attempts to modify the UNIT, UNIT_NUM, and ZONE_LIST attributes at a time, and an error will occur during its execution.

  obclient> ALTER RESOURCE POOL pool1 UNIT='unit2', UNIT_NUM=1, ZONE_LIST=('zone1');
  ERROR 1235 (0A000): alter unit_num, resource_unit, zone_list in one cmd not supported
  

  When you attempt to decrease the value of UNIT_NUM, you can specify the units to be deleted.

  obclient> ALTER RESOURCE POOL pool1 UNIT_NUM=1 DELETE UNIT = (1002);
  Query OK, 0 rows affected
  

• Modify the UNIT attribute of resource pool pool1.

  obclient> ALTER RESOURCE POOL pool1 UNIT='unit2';
  Query OK, 0 rows affected
  

• Split resource pool pool1 into resource pools pool10 and pool11.

  obclient> CREATE RESOURCE POOL pool1 unit='unit1',unit_num=1,zone_list=('zone1','zone2');
  Query OK, 0 rows affected
  
  
  obclient> ALTER RESOURCE POOL pool1 SPLIT INTO ('pool10','pool11') ON ('zone1','zone2');
  Query OK, 0 rows affected
  

• Merge resource pools pool0, pool1, and pool2 of tenant1 for unified management.

  obclient>ALTER RESOURCE POOL MERGE ('pool0','pool1','pool2') INTO ('pool3');
  Query OK, 0 rows affected