A fix is available
APAR status
Closed as program error.
Error description
No sample JCL ( JOB ) provided to BIND PLAN(EEEPLIN). ( 29704 ). . ADDITIONAL SYMPTOMS: 1) While running SQLPA with DB2 V8 in Compatability mode receive EEE ( Easy Explain ) error message MSGEEE680E ALTER TABLE ... COLUMN failed for table DBDB2SM.PLAN_TABLE - SQL-c with DB2 errors: DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE DSNT418I SQLSTATE = 56038 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXIALC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 25 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000019' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION EEE538E EXPLAIN of supplied SQL-statement failed, SQL-code: -220 and / or DSNT408I SQLCODE = -220, ERROR: THE COLUMN TABLE_ENCODE IN EXPLANATION TABLE DBDB2SM.PLAN_TABLE IS NOT DEFINED PROPERLY DSNT418I SQLSTATE = 55002 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOD0P SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF1A' X'00000000' X'00000000' X'FFFFFFFF' ( 77374 ) 2) After receiving a legitimate error in the EEE panels the user may be forced to ATTENTION out of the dialog to get out of the error path. For instance if he enters the wrong DB2 SSID on the EEE main menu he receives: DSNE110E XXXX NOT VALID SUBSYSTEM ID, COMMAND TERMINATED IKJ56712I INVALID KEYWORD, PLAN(EEE) IKJ56703A REENTER THIS OPERAND - If he then tries to hit enter to get out of the error messages and back to the main menu to enter the correct SSID he receives: IKJ56712I INVALID KEYWORD, END IKJ56703A REENTER THIS OPERAND - and IKJ56712I INVALID KEYWORD, PARMS('/Y') IKJ56703A REENTER THIS OPERAND - ( 05008 ) 3) SQLPA / EEE ( Easy Explain ) dialogs do not preserve the DB2 SSID from one session to another. ( 87933 ). 4) DSNT231I -DB21 BIND DBRM ERROR USING R028 AUTHORITY PLAN=ANLITST DBRM ANLITST IS IN AN INCONSISTENT STATE ( 32109 ) 5) EEE using DB2 V8 compatibility mode receives an error -EEE374W Package not found 6) EEE Looping and displays invalid SQL on reports
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 SQL Performance Analyzer. * **************************************************************** * PROBLEM DESCRIPTION: 1. No sample JCL ( JOB ) provided to * * BIND PLAN(EEEPLIN). ( 29704 ). * * 2. While running SQLPA with DB2 V8 in * * Compatability mode receive EEE ( Easy * * Explain ) error message MSGEEE680E * * ALTER TABLE ... COLUMN failed for table * * DBDB2SM.PLAN_TABLE - SQL-c with DB2 * * errors: DSNT408I SQLCODE = -4700, * * ERROR: ATTEMPT TO USE NEW FUNCTION * * BEFORE NEW FUNCTION MODE DSNT418I * * SQLSTATE = 56038 SQLSTATE RETURN CODE * * DSNT415I SQLERRP = DSNXIALC SQL * * PROCEDURE DETECTING ERROR DSNT416I * * SQLERRD = 25 0 0 -1 0 0 SQL DIAGNOSTIC * * INFORMATION DSNT416I SQLERRD = * * X'00000019' X'00000000' X'00000000' * * X'FFFFFFFF' X'00000000' X'00000000' * * SQL DIAGNOSTIC INFORMATION * * EEE538E EXPLAIN of supplied * * SQL-statement failed, SQL-code: -220 * * and / or DSNT408I SQLCODE = -220, * * ERROR: THE COLUMN TABLE_ENCODE IN * * EXPLANATION TABLE DBDB2SM.PLAN_TABLE * * IS NOT DEFINED PROPERLY * * DSNT418I SQLSTATE = 55002 SQLSTATE * * RETURN CODE * * DSNT415I SQLERRP = DSNXOD0P SQL * * PROCEDURE DETECTING ERROR * * DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL * * DIAGNOSTIC INFORMATION * * DSNT416I SQLERRD = X'FFFFFF1A' * * X'00000000' X'00000000' * * X'FFFFFFFF' ( 77374 ) * * 3. After receiving a legitimate error * * in the EEE panels the user may be * * forced to ATTENTION out of the dialog * * to get out of the error path. For * * instance if he enters the wrong DB2 * * SSID on the EEE main menu he receives: * * DSNE110E XXXX NOT VALID SUBSYSTEM ID, * * COMMAND TERMINATED * * IKJ56712I INVALID KEYWORD, PLAN(EEE) * * IKJ56703A REENTER THIS OPERAND - * * If he then tries to hit enter to get * * out of the error messages and back to * * the main menu to enter the correct * * SSID he receives: * * IKJ56712I INVALID KEYWORD, END * * IKJ56703A REENTER THIS OPERAND - and * * IKJ56712I INVALID KEYWORD, PARMS('/Y') * * IKJ56703A REENTER THIS OPERAND - * * ( 05008 ) * * 4. SQLPA / EEE ( Easy Explain ) * * dialogs do not preserve the DB2 SSID * * from one session to another. ( 87933 ) * * 5. DSNT231I -DB21 BIND DBRM ERROR * * USING R028 AUTHORITY PLAN=ANLITST * * DBRM ANLITST IS IN AN INCONSISTENT * * STATE ( 32109 ) * * 6. EEE using DB2 V8 compatibility mode * * receives an error -EEE374W Package not * * found. * * 7. EEE Looping and displays invalid * * SQL on reports. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct these conditions.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK21665
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-03-16
Closed date
2006-07-14
Last modified date
2006-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK16276 UK16277
Modules/Macros
ANLEEE ANLITST ANLMAIN ANLPLAN ANLPLIN ANLSERV ANLSQ2M ANLTABS ANLUNIC ANLVER8 EEE EEEITST EEEJBIND EEEMAIN EEEPLAN EEEPLIN EEESERV EEESQ2M EEETABS EEEUNIC EEEVER8
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUTT","label":"DB2 SQL Performance Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"220","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 December 2020