PH35232: SQL PA PERFORMANCE IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Improve SQL PA performance with optimized internal SQL, optional
  indices, and other configuration
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: BATCH TEST/COMPARE. Function creation job    *
  *                 using BATCH command                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unneeded EXCPs due to *.RUNLIB.LOAD     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTFs                               *
  ****************************************************************
  Unneeded EXCPs due to *.RUNLIB.LOAD
  

Problem conclusion

• Code logic was corrected to fix the issues described.
  

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

• ANLCMACR ANLEEE   ANLJB003 ANLMAIN  ANLPIQLR ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI74703

     UP21/04/02 P F104

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.