IT26076: DBSCHEMA COMMAND DOES NOT DISPLAY INDEX CREATE WHEN RUN AGAINST ENTIRE DATABASE

APAR status

• Closed as duplicate of another APAR.

Error 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 <owner>.tab1 row size = 255 number of columns =
  2 index size = 9 }
  create table <owner>.tab1
  (
  col1 char(4) not null ,
  col2(250)
  ) in dbspace1 extent size 128 next size 128 lock mode row;
  
  revoke all on <owner>.tab1 from "public" as <owner>;
  
  create unique index <owner>.<indexname> on <owner>.tab1
  (col1) using btree in dbspace2;
  alter table <owner>.tab1 add constraint primary key
  (col1) constraint <owner>.tab1 ;
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• This APAR is a duplicate of IT08259
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels