Merge resource pools

For ease of management, you can merge multiple resource pools with the same resource configurations under a tenant into one resource pool.

Limitations

When you merge resource pools, note the following limitations:

• The unit_num settings of the resource pools to be merged must be the same.

• The resource configurations of the resource pools to be merged must be the same.

Merge resource pools

The syntax for merging resource pools is as follows:

ALTER RESOURCE POOL MERGE  ('pool_name'[, 'pool_name' ...]) INTO ('merge_pool_name')

This statement can be executed only by the administrator of the sys tenant.

Note

The resource pools can still be used by the tenant when they are being merged. They are merged into one resource pool only from the perspective of the management layer in which the RootService is located, to facilitate unified maintenance.

Here is an example:

obclient>ALTER RESOURCE POOL MERGE ('pool0','pool1','pool2') INTO ('pool3');