Informix - Problem description
Problem IT26076 | Status: Closed |
DBSCHEMA COMMAND DOES NOT DISPLAY INDEX CREATE WHEN RUN AGAINST ENTIRE DATABASE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
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 Summary: | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Comment | |
This APAR is a duplicate of IT08259 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.08.2018 28.02.2020 28.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |