返回首页

gbase数据、南大通用产品文档:GBase8a设定行分隔符的示例

更新日期:2024年09月11日

db2 数据库系统中创建如下表及数据:
CREATE DATABASE test
connect to test
DROP TABLE t
CREATE TABLE t (a int,b decimal(15,2), c varchar(20),d real,e date)
INSERT INTO t VALUES (-3,0.93,'helloworld',569.9,'2013-03-19')
INSERT INTO t VALUES (-3,0.93,'helloworld',569.9,'2013-03-19')
INSERT INTO t VALUES (19,-15.69,'ff',157,'1999-11-16')
INSERT INTO t VALUES (20,16,'he\n%\n\t\t$\n',52,'1982-06-03')
INSERT INTO t VALUES (20,16,'\n\nhe\t%$\t',23,'1982-06-03')
INSERT INTO t VALUES (58,12.30,'xyz
abc',13.69,'1978-12-20')
INSERT INTO t VALUES (991,-0,'北京',1.230000E+01,'1989-06-07')

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
570

操作步骤
步骤1:修改gcAddInfo.xml 文件,将新增加到vc1 的两个IP 写入该文件:
$ cat gcAddInfo.xml







步骤2:将freenode 添加到vc1 中:
$ gcadmin addnodes gcAddInfo.xml vc1
gcadmin add nodes ...

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
247
flush statemachine success
gcadmin addnodes to vc [vc1] success
添加后,集群状态信息如下:
$ 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
|
1
|
|
---------------------------------------------
|
vc2
|
2
|
|
---------------------------------------------
2 virtual cluster: vc1, vc2
4 coordinator node
0 free data node
$ gcadmin showcluster vc vc1
CLUSTER STATE:
ACTIVE
VIRTUAL CLUSTER MODE:
NORMAL
=============================================
|
GBASE VIRTUAL CLUSTER INFORMATION
|
=============================================
|
VcName
| DistributionId |
comment
|
---------------------------------------------

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
248
|
vc1
|
1
|
|
---------------------------------------------
==========================================================================
===
|
VIRTUAL CLUSTER DATA NODE INFORMATION
|
==========================================================================
===
| NodeName |
IpAddress
| DistributionId | gnode | syncserver | DataState |
-----------------------------------------------------------------------------
|
node1
|172.168.83.11 |
1
| OPEN
|
OPEN
|
0
|
-----------------------------------------------------------------------------
|
node2
|172.168.83.12 |
1
| OPEN
|
OPEN
|
0
|
-----------------------------------------------------------------------------
|
node3
|172.168.83.15 |
| OPEN
|
OPEN
|
0
|
-----------------------------------------------------------------------------
|
node4
|172.168.83.16 |
| OPEN
|
OPEN
|
0
|
-----------------------------------------------------------------------------
4 data node

表 5-105 具体信息如下:
TABLE_ID
表id
COLUMN_ID
列id
DP
dc 号
LOCK_COUNT
加锁的数量
LOCKED
是否加锁
SIZE
占用空间