IBM Support

LI73158: 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 Version 9.5 FixPak3
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73158

  • Reported component name

    DB2 EDE LINUX

  • Reported component ID

    5724N7604

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-02-19

  • Closed date

    2009-04-15

  • Last modified date

    2009-04-15

  • 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 EDE LINUX

  • Fixed component ID

    5724N7604

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 April 2009