Informix - Problembeschreibung
Problem IT26076 | Status: Geschlossen |
DBSCHEMA COMMAND DOES NOT DISPLAY INDEX CREATE WHEN RUN AGAINST ENTIRE DATABASE | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problembeschreibung: | |
dbschema -d db1 -t all -ss > /tmp/list.lst or dbschema -d db1 -ss > /tmp/list.lst is wrong, the index definition is not found. But if dbschema is run with a table specified then the result is correct. Following is a example of the output when specifying the table, without the -t the 'create index' output is not observed: dbschema -d db1 -t tab1 -ss DBSCHEMA Schema Utility INFORMIX-SQL Version 11.70.FC5 { TABLE .tab1 row size = 255 number of columns = 2 index size = 9 } create table .tab1 ( col1 char(4) not null , col2(250) ) in dbspace1 extent size 128 next size 128 lock mode row; revoke all on .tab1 from "public" as ; create unique index . on .tab1 (col1) using btree in dbspace2; alter table .tab1 add constraint primary key (col1) constraint .tab1 ; | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
This APAR is a duplicate of IT08259 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 24.08.2018 28.02.2020 28.02.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |