PI15319: SQLPA NEW FEATURES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• * Display individual DBRM names in the Plan Table report
  when processing multiple DBRMs.
  * New warning displayed when host variable and column in
    the predicate have different length or type.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQLPA v4.2.                     *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      1- RFE 41366:                           *
  *                      Host variable type and length checking. *
  *                      2- RFE 41995:                           *
  *                      Display DBRM name in Plan Table report. *
  *                      3- Qualify unqualified objects in       *
  *                      plans and packages.                     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF for problem resolution.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI19092

Modules/Macros

• ANL$$PRM ANLBPAM  ANLCBTCH ANLCLOB  ANLCONV
  ANLCRNE1 ANLCRNT1 ANLCRNT2 ANLDPRM  ANLEEE   ANLGPRM  ANLICRE8
  ANLJB001 ANLJB002 ANLJCRE8 ANLMAIN  ANLPHU02 ANLPPRMU ANLPRCR
  ANLPRER  ANLQMF   ANLSQLPA ANLTSO   ANLWLMSP H1D0420J
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R420 PSY UI19092

     UP14/06/27 P F406

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.