A fix is available
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 number
PK26399
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2006-06-12
Closed date
2006-08-21
Last modified date
2007-01-08
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
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"220"}]
Document Information
Modified date:
04 January 2021