IC89798: SOLDD GENERATES INCOMPLETE OR INCORRECT SQL SCRIPT

APAR status

• Closed as program error.

Error description

• When using solidDB Data Dictionary (soldd) to export data
  definition statements from solidDB databases with
  referencing/referenced tables, some of the generated SQL scripts
  might include the following kind of problems:
  
  - CREATE TABLE and CREATE VIEW statements are in wrong order.
  - Indexes are not output correctly (some indexes are missing),
  which causes foreign key constraint definitions to fail.
  

Local fix

• To avoid problems related to missing indexes, use the
  undocumented -xfkaltertable option in the soldd startup script.
  The -xfkaltertable option generates the CREATE TABLE statements
  without indexes. The indexes are included in separate ALTER
  TABLE statements.
  
  To recover from the wrong ordering of the CREATE TABLE and
  CREATE VIEW statements, edit the SQL script generated by soldd
  (soldd.sql) manually.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All soldd users, all platforms                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM solidDB V6.5 Fix Pack 13.                     *
  ****************************************************************
  

Problem conclusion

• Fix is included in IBM solidDB V6.5 Fix Pack 13. Now solidDB
  Data Dictionary (soldd) exports data definition statements from
  solidDB databases with referencing/referenced tables and/or
  views works in correct order. Table id column is used to order
  the tables/views in correct order.
  

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:

  IC91004

Fix information

• Fixed component name

  SOLIDDB-DB2/IDS

• Fixed component ID

  5724V1700

Applicable component levels

• R650 PSY

     UP

• R700 PSY

     UP