Informix - Problembeschreibung
Problem IT29147 | Status: Geschlossen |
DBSCHEMA DOES NOT DISPLAY THE CORRECT COMMANDS FOR REPRODUCING THE PLOGSPACE | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to version 14.10.xC2. * **************************************************************** * PROBLEM DESCRIPTION: * * DBSCHEMA DOES NOT DISPLAY THE CORRECT COMMANDS FOR * * REPRODUCING * * THE PLOGSPACE * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.05.2019 19.09.2019 19.09.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
14.10.xC2 | |
Problem behoben lt. FixList in der Version |