创建存储空间、块和日志的样本输出
dbschema -c 或 dbschema -c -ns 命令的输出包含所有 SQL 管理 API 或
gspaces 和 glogadmin 实用程序命令,可用于复制存储空间、块和日志。
SQL 管理 API 格式的输出示例
# Dbspace 1 -- Chunk 1
EXECUTE FUNCTION TASK ('create dbspace', 'rootdbs',
'/export/home/gbasedbt/data/rootdbs1150fc4', '200000',
'0', '2', '500', '100')
# Dbspace 2 -- Chunk 2
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs1',
'/export/home/gbasedbt/data/datadbs1150fc4', '5000000',
'0', '2', '100', '100')
# Dbspace 3 -- Chunk 3
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs2',
'/export/home/gbasedbt/data/datadbs2150fc4', '5000000',
'0', '2', '100', '100')
# Dbspace 4 -- Chunk 4
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs3',
'/export/home/gbasedbt/data/datadbs3_1150fc4', '80000',
'16', '8', '400', '400')
EXECUTE FUNCTION TASK ('start mirror', 'datadbs3',
'/export/home/gbasedbt/data/datadbs3_1150fc4', '80000',
'16', '/export/home/gbasedbt/data/mdatadbs3_1150fc4', '16')
# Dbspace 5 -- Chunk 5
EXECUTE FUNCTION TASK ('create tempdbspace', 'tempdbs',
'/export/home/gbasedbt/data/tempdbs_1150fc4', '1000',
'0', '2', '100', '100')
# Dbspace 6 -- Chunk 6
EXECUTE FUNCTION TASK ('create sbspace', 'sbspace',
'/export/home/gbasedbt/data/sbspace_1150fc4',
'1000', '0')
# Dbspace 6 -- Chunk 7
EXECUTE FUNCTION TASK ('add chunk', 'sbspace',
'/export/home/gbasedbt/data/sbspace_1_1150fc4',
'1000', '0')
# Dbspace 7 -- Chunk 8
EXECUTE FUNCTION TASK ('create blobspace', 'blobdbs',
'/export/home/gbasedbt/data/blobdbs_1150fc4',
'1000', '0', '4')
# External Space 1
EXECUTE FUNCTION TASK ('create extspace', 'extspace',
'/export/home/gbasedbt/data/extspac_1150fc4')
# Physical Log
EXECUTE FUNCTION TASK ('alter plog', 'rootdbs', '60000')
# Logical Log 1
EXECUTE FUNCTION TASK ('add log', 'rootdbs', '10000')
gspaces 和 glogadmin 实用程序格式的输出示例
# Dbspace 1 -- Chunk 1
gspaces -c -d rootdbs -k 2 -p
/export/home/gbasedbt/data/rootdbs1150fc4
-o 0 -s 200000 -en 500 -ef 100
# Dbspace 2 -- Chunk 2
gspaces -c -d datadbs1 -k 2 -p
/export/home/gbasedbt/data/datadbs1150fc4
-o 0 -s 5000000 -en 100 -ef 100
# Dbspace 3 -- Chunk 3
gspaces -c -d datadbs2 -k 2 -p
/export/home/gbasedbt/data/datadbs2150fc4
-o 0 -s 5000000 -en 100 -ef 100
Dbspace 4 -- Chunk 4
gspaces -c -d datadbs3 -k 8
-p /export/home/gbasedbt/data/datadbs3_1150fc4
-o 16 -s 80000 -en 400 -ef 400
-m /export/home/gbasedbt/data/mdatadbs3_1150fc4 16
# Dbspace 5 -- Chunk 5
gspaces -c -d tempdbs -k 2 -t -p
/export/home/gbasedbt/data/tempdbs_1150fc4 -o 0 -s 1000
# Dbspace 6 -- Chunk 6
gspaces -c -S sbspace -p
/export/home/gbasedbt/data/sbspace_1150fc4
-o 0 -s 1000 -Ms 500
# Dbspace 7 -- Chunk 7
gspaces -c -b blobdbs -g 4 -p
/export/home/gbasedbt/data/blobdbs_1150fc4 -o 0 -s 1000
# External Space 1
gspaces -c -x extspace -l
/export/home/gbasedbt/data/extspac_1150fc4
# Logical Log 1
glogadmin -a -d rootdbs -s 10000