PK59738: PERFORMANCE IMPROVEMENT IN SQL GENERATION STEP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This is a performance enhancement to speed up the SQL generation
  process when thousands of SQL statements and many tables are
  involved.
  
  The information about each table is now being stored in memory
  for faster processing.
  
  This was also delivered in LAT v3.1 APAR/PTF PK55380/UK33176.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: This is a performance enhancement to    *
  *                      speed up the SQL generation process     *
  *                      when thousands of SQL statements and    *
  *                      many tables are involved. The           *
  *                      information about each table is now     *
  *                      being stored in memory for faster       *
  *                      processing.                             *
  ****************************************************************
  * 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:

Modules/Macros

•    ALALF2
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK33593

     UP08/02/15 P F802

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.