创建存储空间、块和日志的样本输出

dbschema -cdbschema -c -ns 命令的输出包含所有 SQL 管理 API 或 onspacesonparams 实用程序命令,可用于复制存储空间、块和日志。

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')

onspaces 和 onparams 实用程序格式的输出示例

# Dbspace 1 -- Chunk 1
onspaces -c -d rootdbs -k 2 -p
 /export/home/gbasedbt/data/rootdbs1150fc4
 -o 0 -s 200000 -en 500 -ef 100

# Dbspace 2 -- Chunk 2
onspaces -c -d datadbs1 -k 2 -p
 /export/home/gbasedbt/data/datadbs1150fc4
 -o 0 -s 5000000 -en 100 -ef 100

# Dbspace 3 -- Chunk 3
onspaces -c -d datadbs2 -k 2 -p
 /export/home/gbasedbt/data/datadbs2150fc4
 -o 0 -s 5000000 -en 100 -ef 100

 Dbspace 4 -- Chunk 4
onspaces -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
onspaces -c -d tempdbs -k 2 -t -p
 /export/home/gbasedbt/data/tempdbs_1150fc4 -o 0 -s 1000

# Dbspace 6 -- Chunk 6
onspaces -c -S sbspace -p
 /export/home/gbasedbt/data/sbspace_1150fc4
 -o 0 -s 1000 -Ms 500

# Dbspace 7 -- Chunk 7
onspaces -c -b blobdbs -g 4 -p
 /export/home/gbasedbt/data/blobdbs_1150fc4 -o 0 -s 1000

# External Space 1
onspaces -c -x extspace -l
 /export/home/gbasedbt/data/extspac_1150fc4

# Logical Log 1
onparams -a -d rootdbs -s 10000