PI11734: VARIOUS SIZE ERRORS ANL1070W ANL3034E ANL3099E COND = 340

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLPA may return error messages like the following indicating
  processing problems due to large SQL statements.
  
  ANL1070W Size error occurred during Explain while
           storing SQL PA will continue processing
           data. Cond =  340
  
  another reported similar situation with messages like the
  following:
  
  ANL3034E A Size error was detected during internal
           calculations Check statistics and correct
           ... then re-run pgm.
  ...
  
  ANL3099E A terminal processing error has occurred.
           PLI Error Code =    340.
           ANL Error Code =      0.
            & Return Code =     16.
   SQL PA  Program terminates with unrecoverable error.
   Possible cause:
   Variable size error - check catalog stats, Runstats
  
  SQL PA may repeatedly issue message ANL3028E after an
  SQLCODE = -804 error received.
  
  ANL2008I No Index  stats for query, when EXPLAIN DB2
  INSERT
  
  OTHER KEYWORDS:  MSGANL1070W MSGANL3034E MSGANL3099E
  ANL1070W ANL3034E ANL3099E    ANL1070 ANL3034 ANL3099
  MSGANL3028E ANL3028E ANL3028 MSGANL2008I ANL2008I
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL Performance Analyzer.       *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      1. VARIOUS SIZE ERRORS:                 *
  *                         ANL1070W                             *
  *                         ANL3034E                             *
  *                         ANL3099E                             *
  *                         COND = 340                           *
  *                                                              *
  *                      2. Incorrectly post ANL2008I No Index   *
  *                         stats for query                      *
  *                                                              *
  *                      3. SQLCODE206 -206 DUE TO MISSING       *
  *                         TABLE QUALIFIER IN WHERE CLAUSE      *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF for problem resolution.
  

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:

  UI20866 UI20867

Modules/Macros

• ANLDPRM  ANLEEE   ANLGPRM  ANLJCRE8 ANLMAIN
  ANLPRCC  ANLPRCR  ANLPREC  ANLPRER  ANLQMF   ANLSQLPA ANLTSO
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R410 PSY UI20866

     UP14/08/28 P F408

• R420 PSY UI20867

     UP14/08/28 P F408

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.