dbschema displays incorrect FUNTION TASK to create a
plogspace... and the onspaces -c -d command to instead of the
onspace -c -P command.
IBM Informix Dynamic Server Version 12.10.FC10 -- On-Line -- Up
21:43:19 -- 206848 Kbytes
Dbspaces
address number flags fchunk
nchunks pgsize flags owner
name
10af8e028 1 0x30001 1
1 2048 N BA informix rootdbs
10c95b080 2 0x20001 2
1 2048 N BA informix
llog_dbs
10c9e8cf8 3 0x1030001 3
1 2048 N PBA informix
plog_dbs
.
.
==> chunk 3 is the plogspace (plog_dbs).
$ dbschema -c
DBSCHEMA Schema Utility INFORMIX-SQL Version 12.10.FC10
-- Dbspace 1 -- Chunk 1
-- EXECUTE FUNCTION TASK
-- ('create dbspace', 'rootdbs',
'/opt/IBM/informix/dev/root_dbs', '300000', '0', '2', '500',
'400');
-- Dbspace 2 -- Chunk 2
EXECUTE FUNCTION TASK
('create dbspace', 'llog_dbs', '/opt/IBM/informix/dev/llog_dbs',
'4194304', '0', '2', '100', '100');
-- Dbspace 3 -- Chunk 3
EXECUTE FUNCTION TASK
('create dbspace', 'plog_dbs', '/opt/IBM/informix/dev/plog_dbs',
'4194304', '0', '2', '100', '100');
-- Physical Log
EXECUTE FUNCTION TASK
('alter plog', 'plog_dbs', '4194198');
.
.
==> The command for -- Dbspace 3 -- Chunk 3 should be:
EXECUTE FUNCTION task ("create plogspace", "plogdbs",
'/opt/IBM/informix/dev/plog_dbs', '4194304', '0');
$ dbschema -c -ns|head -20
DBSCHEMA Schema Utility INFORMIX-SQL Version 12.10.FC10
# Dbspace 1 -- Chunk 1
# onspaces -c -d rootdbs -k 2 -p /opt/IBM/informix/dev/root_dbs
-o 0 -s 300000 -ef 500 -en 400
# Dbspace 2 -- Chunk 2
onspaces -c -d llog_dbs -k 2 -p /opt/IBM/informix/dev/llog_dbs
-o 0 -s 4194304 -ef 100 -en 100
# Dbspace 3 -- Chunk 3
onspaces -c -d plog_dbs -k 2 -p /opt/IBM/informix/dev/plog_dbs
-o 0 -s 4194304 -ef 100 -en 100
# Physical Log
onparams -p -s 4194198 -d plog_dbs -y
==> The command for # Dbspace 3 -- Chunk 3 should be:
onspaces -c -P plogdbs -p /opt/IBM/informix/dev/plog_dbs -o
0 -s 4194304 |
