IBM Support

IZ15905: Load/import/export utilities generating lots of warnings may perform excessively slow

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the Load utility generates lots of warnings (for example if
    the data being parsed is full of errors, truncations, or
    rejected records), the utility may perform very poorly.  This is
    because the Load utility opens its internal server-side message
    file using the O_SYNC flag which means writes to this internal
    server-side message file will block until all message data and
    file meta-data is written to disk. Since this data is not
    critical to the operation of the utility or management of the
    database, we will avoid opening the server-side message file
    using this O_SYNC flag.
    

Local fix

  • You can specify the Load NOROWWARNINGS modifier to force the
    Load utility to avoid writing warning messages all together.
    

Problem summary

  • Please see above.
    

Problem conclusion

  • First fixed in DB2 UDB 8.1 FixPak 17
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ15905

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-02-19

  • Closed date

    2008-09-22

  • Last modified date

    2008-09-22

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

    LI73145

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

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R820 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 September 2008