dbschema -c 或 dbschema -c -ns 命令的输出包含所有 SQL 管理 API 或 onspaces 和 onparams 实用程序命令,可用于复制存储空间、块和日志。
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