PH30267: PROBLEM WITH MIXED CASE VERSION IDS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Problem with mixed case version IDs
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of component                           *
  *                 - ISPF/BATCH Process packages from the DB2   *
  *                   system catalog                             *
  *                 - ISPF/BATCH   Process a test of packages    *
  *                   for updated access paths                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.SQLPA not being able to explain a     *
  *                        package  where its version contains   *
  *                        lowercase characters.                 *
  *                      2.Test function finished with error :   *
  *                        IBM0461S ONCODE=300 The OVERFLOW      *
  *                        condition                             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTFs                               *
  ****************************************************************
  1.SQLPA not being able to explain a
    package  where its version contains
    lowercase characters.
  2.Test function finished with error :
    IBM0461S ONCODE=300 The OVERFLOW condition
  
  
  Code logic was corrected to fix the issues described.
  
  
  Search Keywords:
  On panel ANLPUPRM, cannot exit out ;
  SQLPA not being able to explain a package  where its version
  contains lowercase characters.
  Wehn TEST --> IBM0461S ONCODE=300 The OVERFLOW condition.
  

Problem conclusion

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:

  UI72771

Modules/Macros

• ANLBATCH ANLCBTCH ANLCMIGR ANLCRNE1 ANLCRNT1 ANLEEE   ANLMAIN
  ANLPH126 ANLPH127 ANLPH200 ANLPIDD  ANLPPKGE ANLPUPRM ANLSQLPA
  ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI72771

     UP20/11/28 P F011

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.