gbase数据、南大通用产品文档：GBase8s

具有相同的索引名称的嵌套FOR LOOP语句
BEGIN
<>
FOR i IN 1..3 LOOP
<>
FOR i IN 1..3 LOOP
IF outer_loop.i = 2 THEN
DBMS_OUTPUT.PUT_LINE('outer: ' || TO_CHAR(outer_loop.i) || ' inner: '||
TO_CHAR(inner_loop.i));
END IF;
END LOOP inner_loop;
END LOOP outer_loop;
END;

--Result:
--outer: 2 inner: 1
--outer: 2 inner: 2
--outer: 2 inner: 3

资源池为集群任务执行过程中的资源供给者与管理者，
分为静态资源池与动态资源
池两种，静态资源池为资源供给者，而动态资源池为资源管理者，约束任务对资源
的使用。

操作步骤
步骤1：将安装目录下的gcChangeInfo.xml 复制到gcS_vc1.xml 文件，然后去掉待
缩容的节点IP。
修改后的gcS_vc1.xml 文件参考如下：
$cp gcChangeInfo.xml gcS_vc1.xml
$cat gcS_vc1.xml







步骤2：执行创建distribution 的命令。
$ gcadmin distribution gcS_vc1.xml p 1 d 1 vc vc1
gcadmin generate distribution ...
gcadmin generate distribution successful
完成后的集群信息如下：

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
278
$ gcadmin distribution gcS_vc1.xml p 1 d 1 vc vc1
gcadmin generate distribution ...
gcadmin generate distribution successful
$ gcadmin
CLUSTER STATE:
ACTIVE
================================================================
|
GBASE COORDINATOR CLUSTER INFORMATION
|
================================================================
|
NodeName
|
IpAddress
| gcware | gcluster | DataState |
----------------------------------------------------------------
| coordinator1 | 172.168.83.11 |
OPEN
|
OPEN
|
0
|
----------------------------------------------------------------
| coordinator2 | 172.168.83.12 |
OPEN
|
OPEN
|
0
|
----------------------------------------------------------------
| coordinator3 | 172.168.83.13 |
OPEN
|
OPEN
|
0
|
----------------------------------------------------------------
| coordinator4 | 172.168.83.15 |
OPEN
|
OPEN
|
0
|
----------------------------------------------------------------
=============================================
|
GBASE VIRTUAL CLUSTER INFORMATION
|
=============================================
|
VcName
| DistributionId |
comment
|
---------------------------------------------
|
vc1
|
4,5
|
|
---------------------------------------------
|
vc2
|
2
|
|
---------------------------------------------
2 virtual cluster: vc1, vc2
4 coordinator node
0 free data node
$ gcadmin showdistribution vc vc1
Distribution ID: 5 | State: new | Total segment num: 2
Primary Segment Node IP
Segment ID
uplicate Segment node IP
===================================================================
|