PK94922: LONG RUNNING DB2 LOG ANALYSIS TOOL HIGH SPEED MODE JOB WITH LARGE VOLUME OF EXTFILE (EXTRACT FILES) AND UOW (UNITS OF WORK)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When requesting high speed mode in DB2 Log Analysis Tool,
  EXTFILE records are matched against internal array holding UOWs.
  If there are large numbers of either EXTFILE records or UOWs,
  the lookup process may be very slow. It may appear to be
  looping, but it is not. The slowness of the process is dependent
  on actual ordering of records within the EXTFILE, so not every
  large volume job will incur this.
  
  This lookup process has been enhanced to be more efficient, and
  run times can benefit greatly from this APAR for high speed mode
  jobs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When requesting high speed mode in DB2  *
  *                      Log Analysis Tool, EXTFILE records are  *
  *                      matched against internal array holding  *
  *                      UOWs. If there are large numbers of     *
  *                      either EXTFILE records or UOWs, the     *
  *                      lookup process may be very slow. It     *
  *                      may appear to be looping, but it is     *
  *                      not. The slowness of the process is     *
  *                      dependent on actual ordering of         *
  *                      records within the EXTFILE, so not      *
  *                      every large volume job will incur this. *
  *                      This lookup process has been enhanced   *
  *                      to be more efficient, and run times     *
  *                      can benefit greatly from this APAR for  *
  *                      high speed mode jobs.                   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK50098 UK50099 UK50100

Modules/Macros

•    ALAETV
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK50098

     UP09/10/06 P F910

• R310 PSY UK50099

     UP09/10/06 P F910

• R320 PSY UK50100

     UP09/10/06 P F910

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.