PQ88466: NEGATIVE NUMBERS OR MISSING ENTRIES IN QLIMIT STATISTICS , MSGANL1008E UNCLEAR, ABENDU4091 WHEN LE ERRCOUNT EXCEEDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 SQL Performance Analyzer R210 :
  1. Unpredictable results including large numbers or negative
     costs were reported when there are more than 64 multiple
     index plan steps.
  2. Queries that are unexplainable are not recorded in the
     QLIMIT fie.
  3. ANL1008E error message is unclear.
  4. U4091 abend is received if installation's LE ERRCOUNT is
     exceeded.
  5. SQL/PA SQL Performance Analyzer issues message
  MSGANL1009W PGM CANNOT DETERMINE THE COST OF STATEMENT:
  100001868, SQLCODE =  -104   ( 104 ).
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "-".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 SQL Performance Analyzer R210 :     *
  *                      1. Unpredictable results including      *
  *                         large numbers or negative costs      *
  *                         were reported when there are more    *
  *                         than 64 multiple index plan steps.   *
  *                      2. Queries that are unexplainable are   *
  *                         not recorded in the QLIMIT fie.      *
  *                      3. ANL1008E error message is unclear.   *
  *                      4. U4091 abend is received if           *
  *                         installation's LE ERRCOUNT is        *
  *                         exceeded.                            *
  *                      5. SQL/PA SQL Performance Analyzer      *
  *                         issues message                       *
  *                       MSGANL1009W PGM CANNOT DETERMINE THE   *
  *                       COST OF STATEMENT:                     *
  *                       100001868, SQLCODE =  -104   ( 104 ).  *
  ****************************************************************
  * RECOMMENDATION: Install this APAR fix PQ88466.               *
  ****************************************************************
  

Problem conclusion

• Code has been chnaged to correct these conditions.
  

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

•    ANLCOST  ANLPROC  ANLSCAN  ANL4QMF
  

Fix information

• Fixed component name

  DB2 SQL PER AN

• Fixed component ID

  5697F5701

Applicable component levels

• R210 PSY UQ90427

     UP04/07/27 P F407

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.