PH18019: FIX OPEN CURSOR ISSUE CAUSING LOOPING SYMPTOMS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Fix open cursor issue causing looping symptoms
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Db2 SQL Performance Analyzer             *
  *                 users of component :                         *
  *                 - Basic DB2 SQL PA Processing                *
  *                  1.1 Process package form DB2 system catalog *
  *                  1.2 Process application DBRM                *
  *                 -2.2 Migrate statistic                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLPA is looping for same DBRMs         *
  *                       when 1.2 is performing                 *
  *                      SQLCODE=-304 occur if DB2 at version 12 *
  *                      and "migrate statisttics" item          *
  *                      is performing.                          *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  SQLPA is looping for same dbrms  when 1.2 item is performing .
  SQLCODE=-304 occur if DB2 at level 12 and "migrate statisttics"
  item is performing.
  

Problem conclusion

• Code logic was corrected to fix the issue described.
  
  Search Keywords:
  SQLCODE -304 in item 2.2.2
  Looping when 1.2 is perfoming
  

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:

  UI66558

Modules/Macros

• ANLSQLPA ANLTSO   ANLWIF
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI66558

     UP19/11/23 P F911

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.