PH25186: INCORRECT ANL2021W MESSAGE DUE TO USING IBM_SERVICE_DATA FIELD FOR VERSION 12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect ANL2021W message due to using IBM_SERVICE_DATA field
  for version 12
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of component:                          *
  *                 - ISPF Process SQL from a sequential data    *
  *                   set or PDS member or ISPF Process          *
  *                   application DBRM during using line command *
  *                   I for remote location;                     *
  *                 - ISPF Process packages from the DB2 system  *
  *                   catalog during using primary command       *
  *                   EXPLAIN;                                   *
  *                 - BATCH process from item 1.1, 1.2, 1.3 for  *
  *                   remote location;                           *
  *                 - Posibility to use two version of SQLPA in  *
  *                   one DB2.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Incorrect index information in Qblock *
  *                        report for explain on remote location *
  *                      2.Not possible to use two releases of   *
  *                        SQLPA in one DB2                      *
  *                      3.ANL2021W message is shown even if     *
  *                        VERSION parameter is correct.         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1.Not showing correct information about indexes for remote
  location;
  2.Not possible to use two version of SQLPA
  in one DB2 ;
  3.Is showed ANL2021W message even if
  VERSION parameter is correct.
  

Problem conclusion

• Code logic was corrected to fix the issues described.
  
  Search Keywords:
  message ANL2021W even if VERSION parameter is correct
  

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:

  UI70225

Modules/Macros

• ANLBATCH ANLBPAM  ANLCAT   ANLCHECK ANLCLOB  ANLCONV  ANLCSV
  ANLDB2X  ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLMAIN  ANLNUXD
  ANLPDBRM ANLPFILE ANLPICP  ANLPIDD  ANLPIQLR ANLPITP  ANLPLAN
  ANLPLIN  ANLPPKGE ANLPRCR  ANLPRER  ANLPTCM  ANLPTEX  ANLPTLD
  ANLPTRP  ANLPTSM  ANLQMF   ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS
  ANLTOHEX ANLTSO   ANLUNIC  ANLUOPT  ANLVER8  ANLWIF   ANLWIFF
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI70225

     UP20/06/26 P F006

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.