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

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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