IC89798: SOLDD GENERATES INCOMPLETE OR INCORRECT SQL SCRIPT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    IC89798

  • Reported component name

    SOLIDDB-DB2/IDS

  • Reported component ID

    5724V1700

  • Reported release

    650

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-24

  • Closed date

    2013-03-21

  • Last modified date

    2013-03-21

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM solidDB

Software version:

650

Reference #:

IC89798

Modified date:

2013-03-21

Translate my page

Machine Translation

Content navigation