PK40756: EEE REPORT LOOPING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The EEE report is looping printing many blank lines in the
  output. The job is cancelled to discontinue the loop.
  ADDITIONAL SYMPTOMS:
  
  1) EEE538E  EXPLAIN of supplied SQL-statement failed, SQL-code:
     -104
     DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "0". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: FOR WITH FETCH ORDER UNION
     EXCEPT QUERYNO OPTIMIZE
     DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  2) When LEVEL=SUMMARY is used before a PLN statement, the PLN
     still showed DETAIL level information, not SUMMARY level.
  3) SQLCODE -312
     ANL1009W Pgm cannot determine the cost of statement:
     100000001,  Sqlcode =  -312
     (P)    One or more host variables cannot be correctly
     substituted with marker:
  .
     - or - an illegal symbol has been encountered
     within the SQL. Statement ignored and process continues.
  4) The user user started entering dataset names in ANLOPUT, but
     stopped after entering the HLQ. The user then left the panel
     and went back to ANLMAIN. This set Define Output Files to NO
     on ANLMAIN. The result is that SQLPA does a delete/define of
     the datasets specified in the Output Reports Panel.
  5) ANL1009W Pgm cannot determine the cost of statement:
     100007418, Sqlcode = -104
     DSNT408I SQLCODE = -104
  6) Correct the following -418 error:
     ANL1009W Pgm cannot determine the cost of statement:
     100000924, Sqlcode =  -418
      (P)  One or more host variables cannot be correctly
           substituted with marker:
           Parameter Markers (?) are illegal in some "EXPLAIN"
           requests.
           - or - an illegal symbol has been encountered within
           the SQL.
           Statement ignored and process continues.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQL Performance Analyzer.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The EEE report is looping printing      *
  *                      many blank lines in the output. The     *
  *                      job is cancelled to discontinue the     *
  *                      loop.                                   *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1. EEE538E  EXPLAIN of supplied SQL     *
  *                      -statement failed, SQL-code: -104       *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "0". SOME SYMBOLS THAT   *
  *                      MIGHT BE LEGAL ARE: FOR WITH FETCH      *
  *                      ORDER UNION EXCEPT QUERYNO OPTIMIZE     *
  *                      DSNT418I SQLSTATE   = 42601 SQLSTATE    *
  *                      RETURN CODE                             *
  *                      2. When LEVEL=SUMMARY is used before a  *
  *                      PLN statement, the PLN still showed     *
  *                      DETAIL level information, not SUMMARY   *
  *                      level.                                  *
  *                      3. SQLCODE -312 ANL1009W Pgm cannot     *
  *                      determine the cost of statement:        *
  *                      100000001,  Sqlcode =  -312             *
  *                      (P) One or more host variables cannot   *
  *                      be correctly substituted with marker:   *
  *                      - or - an illegal symbol has been       *
  *                      encountered within the SQL. Statement   *
  *                      ignored and process continues.          *
  *                      4. The user user started entering       *
  *                      dataset names in ANLOPUT, but stopped   *
  *                      after entering the HLQ. The user then   *
  *                      left the panel and went back to         *
  *                      ANLMAIN. This set Define Output Files   *
  *                      to NO on ANLMAIN. The result is that    *
  *                      SQLPA does a delete/define of the       *
  *                      datasets specified in the Output        *
  *                      Reports Panel.                          *
  *                      5. ANL1009W Pgm cannot determine the    *
  *                      cost of statement: 100007418,           *
  *                      Sqlcode = -104                          *
  *                      DSNT408I SQLCODE = -104                 *
  *                      6. Correct the following -418 error:    *
  *                      ANL1009W Pgm cannot determine the cost  *
  *                      of statement: 100000924, Sqlcode =      *
  *                      -418 (P)  One or more host variables    *
  *                      cannot be correctly substituted with    *
  *                      marker: Parameter Markers (?) are       *
  *                      illegal in some "EXPLAIN" requests.     *
  *                      - or - an illegal symbol has been       *
  *                      encountered within the SQL. Statement   *
  *                      ignored and process continues.          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK23919 UK23920

Modules/Macros

• ANLCLOB  ANLHEX3  ANLLOOP  ANLMAIN  ANLOPUT
  ANLPGM31 ANLPLAN  ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLQMF31
  ANLSERV  ANLSQ2M  ANLTABS  ANLUNIC  ANLUOPT  ANLVER8  ANL30
  EEEMAIN  EEEPLAN  EEESERV  EEESQ2M  EEETABS  EEEUNIC  EEEVER8
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R220 PSY UK23919

     UP07/04/13 P F704

• R310 PSY UK23920

     UP07/04/14 P F704

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.