IC62545: DBSCHEMA CAN GIVE A MISLEADING WARNING THAT A GENERATED STATEMENT MIGHT BE TOO LONG WHEN IN FACT NO LONG STATEMENT IS CREATED

APAR status

• Closed as program error.

Error description

• For a database schema that has an expression fragmented index
  the statement length calculation of dbschema can be wrong.
  
  This can happen when in between the table creation commands and
  the fragmented index creation command sufficiently many
  statements (grant statements, for example) are genereated.
  
  An sample schema for this would look like (20000 grant
  statements here):
  
  create table "usera".tab1
    (
      i1 integer,
      c2 char(10)
    ) extent size 16 next size 16 lock mode row;
  
  grant select on "usera".tab1 to "user00000001" as "usera";
  ...
  grant select on "usera".tab1 to "user00020000" as "usera";
  
  
  create index "usera".tab1_idx1 on "usera".tab1 (i1) using
      btree
    fragment by expression
      (i1 <= 0 ) in dbs1,
      (i1 > 0 ) in dbs2;
  
  In this specific case the warning given by "dbschema -d db -ss"
  can be ignored (the actual number printed in the last line of
  the message may vary, depending on your schema layout):
  
  DBSCHEMA Schema Utility       INFORMIX-SQL Version 11.50.FC5
  The dbschema utility might have generated a statement that is
  too long. If you
   want IDS to use this output, then rerun the dbschema command
  with the -sl
   option, passing 89 or less as the parameter.
  
  To be sure you can verfiy the usability of the generated schema
  by trying to import it on an appropriate test system.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * dbschema users                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Dbschema can give a misleading warning that a generated      *
  * statement might be too long when in fact no such statement   *
  * is created.                                                  *
  * dbschema -sl core dumps                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem has been fixed in IDS 11.50.xC6. The misleading dbschema
  warning has been disabled.
  dbschema -sl will not core dump
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP