PK26399: SEVERAL FIXES TO THE EEE COMPONENT OF SQLPA.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message DSNT408I with SQLCODE -199 ERROR: ILLEGAL USE OF KEYWORD
  WITH, TOKEN issued on EEE explain with DECLARE ... Cursor with
  hold.
  (54667 )
  ADDITIONAL SYMPTOMS:
  1) EEE batch program output INDEX column name may
     appear more than once. ( 75392 )
  2) Provide improved EEE performance by adding additional
     WHERE predicates. ( 89073 )
  3) EEE batch run of large package with many SQL
     statements may loop, with repeated blank lines
     written in the output. ( 75479 )
  4) When runnig a detail report with EEE on SQLPA see a parseing
  problem with the job:
  .
  MSGEEE538E  EXPLAIN of supplied SQL-statement failed, SQL-code:
          -199
  SELECT DISTINCT CCSID FROM S FROM S FROM S FROM S
  FROM S FROM
  .
  DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD FROM.
  FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE WAS EXPECTED
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  5) Receiving ISPF Dialog Error - PF1 on panel ANLEEE
     Panel 'ANLEH01' error
     Illegal characters or statement type found in )ATTR section.
  6. DSNE317A with EEE on output file create.
  7. After migrating EEE from the test system to the production
     system, the initial EEE screen is still populated with
     the test system. Have to manually change the screen to the
     production system every time.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message DSNT408I with SQLCODE -199      *
  *                      ERROR: ILLEGAL USE OF KEYWORD WITH,     *
  *                      TOKEN issued on EEE explain with        *
  *                      DECLARE ... Cursor with hold.           *
  *                      (54667 )                                *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1. EEE batch program output INDEX       *
  *                      column name may appear more than once.  *
  *                      ( 75392 )                               *
  *                      2. Provide improved EEE performance by  *
  *                      adding additional WHERE predicates.     *
  *                      ( 89073 )                               *
  *                      3. EEE batch run of large package with  *
  *                      many SQL statements may loop, with      *
  *                      repeated blanks lines written in the    *
  *                      output. ( 75479 )                       *
  *                      4. When runnig a detail report with     *
  *                      EEE on SQLPA see a parseing problem     *
  *                      with the job:                           *
  *                      MSGEEE538E  EXPLAIN of supplied         *
  *                      SQL-statement failed, SQL-code: -199    *
  *                      SELECT DISTINCT CCSID FROM S FROM S     *
  *                      FROM S FROM S FROM S FROM               *
  *                      DSNT408I SQLCODE = -199, ERROR:         *
  *                      ILLEGAL USE OF KEYWORD FROM.            *
  *                      FETCH ORDER UNION EXCEPT QUERYNO        *
  *                      OPTIMIZE WAS EXPECTED                   *
  *                      DSNT418I SQLSTATE   = 42601 SQLSTATE    *
  *                      RETURN CODE                             *
  *                      5. Receiving ISPF Dialog Error - PF1    *
  *                      on panel ANLEEE Panel 'ANLEH01' error   *
  *                      Illegal characters or statement type    *
  *                      found in ATTR section.                  *
  *                      6. DSNE317A with EEE on output file     *
  *                      create.                                 *
  *                      7. After migrating EEE from the test    *
  *                      system to the production system, the    *
  *                      initial EEE screen is still populated   *
  *                      with the test system. Have to manually  *
  *                      change the screen to the production     *
  *                      system every time.                      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  (V2R2 only)
  1. Correct problem on program EEEMAIN displaying duplicate
   index names on EEE report (PMR 75392).
  2.  Correct problem on program EEEMAIN looping (PMR 75479 and
   00946)
  3. Fixed EEE report displaying DSNE371A message and noting being
   created (PMR 30121 and 32543)
  (V3R1 only)
  1. Correct problem on program EEEMAIN displaying duplicate index
   names on EEE report (PMR 75392).
  2. Correct problem on program EEEMAIN looping (PMR 75479 and
   00946)
  3. Fixed EEE report displaying DSNE371A message and noting being
   created (PMR 30121 and 32543)
  4.  Fixed Dialog error ANLEEE when displaying EEE help panels.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ×**** PE06/08/31 PTF IN ERROR. SEE APAR PK30805  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK17366 UK17367

Modules/Macros

• ANLEEE   ANLEH01  ANLEH01A ANLEH01B ANLEH011
  ANLEH012 ANLEH013 ANLEH014 ANLEH015 ANLEH016 ANLEH017 ANLEH018
  ANLEH019 ANLMAIN  EEE      EEEMAIN
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R220 PSY UK17366

     UP06/08/29 P F608

• R310 PSY UK17367

     UP06/08/29 P F608

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.