Sample output for the creation of storage spaces, chunks, and logs

The output of the dbschema -c or dbschema -c -ns commands contain all of the SQL administration API or onspaces and onparams utility commands that you can use to reproduce storage spaces, chunks, and logs.

# Dbspace 1 -- Chunk 1
EXECUTE FUNCTION TASK ('create dbspace', 'rootdbs',
 '/export/home/informix/data/rootdbs1150fc4', '200000',
 '0', '2', '500', '100')

# Dbspace 2 -- Chunk 2
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs1',
 '/export/home/informix/data/datadbs1150fc4', '5000000',
 '0', '2', '100', '100')

# Dbspace 3 -- Chunk 3
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs2',
 '/export/home/informix/data/datadbs2150fc4', '5000000',
 '0', '2', '100', '100')

# Dbspace 4 -- Chunk 4
EXECUTE FUNCTION TASK ('create dbspace', 'datadbs3',
 '/export/home/informix/data/datadbs3_1150fc4', '80000',
 '16', '8', '400', '400')
EXECUTE FUNCTION TASK ('start mirror', 'datadbs3',
 '/export/home/informix/data/datadbs3_1150fc4', '80000',
 '16', '/export/home/informix/data/mdatadbs3_1150fc4', '16')

# Dbspace 5 -- Chunk 5
EXECUTE FUNCTION TASK ('create tempdbspace', 'tempdbs',
 '/export/home/informix/data/tempdbs_1150fc4', '1000',
 '0', '2', '100', '100')

# Dbspace 6 -- Chunk 6
EXECUTE FUNCTION TASK ('create sbspace', 'sbspace',
 '/export/home/informix/data/sbspace_1150fc4',
 '1000', '0')

# Dbspace 6 -- Chunk 7
EXECUTE FUNCTION TASK ('add chunk', 'sbspace',
 '/export/home/informix/data/sbspace_1_1150fc4',
 '1000', '0')

# Dbspace 7 -- Chunk 8
EXECUTE FUNCTION TASK ('create blobspace', 'blobdbs',
 '/export/home/informix/data/blobdbs_1150fc4',
 '1000', '0', '4')

# External Space 1
EXECUTE FUNCTION TASK ('create extspace', 'extspace', 
'/export/home/informix/data/extspac_1150fc4')

# Physical Log
EXECUTE FUNCTION TASK ('alter plog', 'rootdbs', '60000')

# Logical Log 1
EXECUTE FUNCTION TASK ('add log', 'rootdbs', '10000')

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

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

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

 Dbspace 4 -- Chunk 4
onspaces -c -d datadbs3 -k 8
 -p /export/home/informix/data/datadbs3_1150fc4
 -o 16 -s 80000 -en 400 -ef 400
 -m /export/home/informix/data/mdatadbs3_1150fc4 16

# Dbspace 5 -- Chunk 5
onspaces -c -d tempdbs -k 2 -t -p
 /export/home/informix/data/tempdbs_1150fc4 -o 0 -s 1000

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

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

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

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