Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 6 July 2023
DB2 SQL Performance Analyzer Version 2.2
APAR CLOSE
DATE		 PTF(s) Fixing APAR
if PE		 HIPER? Abstract
PK47526
26_Oct
2007
UK30683


SQLCODE -104
PK43853
25_May
2007
UK25547


SQLCODE -104 SQLCODE104 ILLEGAL SYMBOL IN SQLPA WHEN KOREAN CCSID 933 IS IN USE.
PK40756
11_Apr
2007
UK23919


EEE REPORT LOOPING
PK38017
16_Feb
2007
UK22291


PLAN_TABLE ALIAS OF TYPE='A' IS NOT BEING CREATED.
PK36927
12_Feb
2007
UK22070


PACKAGE NOT FOUND AFTER MIGRATING TO DB2 V8 NFM WHEN NOT0004 USING THE WILDCARD % SIGN. GETTING MESSAGE EEE374W.
PK34964
14_Dec
2006
UK20640


SQLPA PANEL DIALOG PROBLEMS WITH PF3 ACTING LIKE "ENTER" ON SOME PANELS.
PK33751
16_Nov
2006
UK19750


THE VALUE FOR HIGH2KEY AND LOW2KEY APPEARS IN UNICODE
PK30156
3_Nov
2006
UK19392


USER COMPLETION CODE=4088 REASON CODE=000003EC USING EEE WITHIN SQLPA. SQLPA WILL DELIVER ITS OWN VERSION OF CEEUOPT.
PK32157
16_Oct
2006
UK18840


PERFORMANCE ENHANCEMENT WHEN A JOIN ON SYSIBM.SYSDUMMY1 IS NEEDED.
PK30805
14_Sep
2006
UK18041


PTF UK17366 FOR APAR PK26399 ON SQLPA RELEASE R220 REGRESSED THEFIX FOR THE EEE COMPONENT OF SQLPA FROM PK14394 / UK10500. PE
PK26399
21_Aug
2006
UK17366
PK30805
SEVERAL FIXES TO THE EEE COMPONENT OF SQLPA.
PK26397
4_Aug
2006
UK16940


SQLPA RECEIVE DB2 SQLCODE -204 42704 SQLSTATE WHEN USEPLAN IS SET.
PK21665
14_Jul
2006
UK16276


NO SAMPLE JCL ( JOB ) PROVIDED TO BIND PLAN(EEEPLIN). ( 29704 ).
PK24422
9_Jun
2006
UK15295

HIPER

 RUNNING ANLPGME7 GETS IEW2646W 4B07 ESD RMODE(24) CONFLICTS WITHUSER-SPECIFIED RMODE(ANY) FOR SECTION ANLBPAM.
PK23139
31_May
2006
UK15009


MSGANL2006I MSGANL2007I MSGANL2008I "NO STATS FOUND" IN INDEX ORCATALOG WHEN STATISTICS REALLY ARE AVAILABLE.
PK20472
10_Apr
2006
UK13425


ON THE SQL PA EASY EXPLAIN ( EEE ) MAIN MENU ( PANELID EEE ) HIT PF1 HELP GET ISPP100 PANEL "DSN6SP1 " ERROR. PANEL NOT
FOUND.
PK13207
17_Jan
2006
UK10891


SQL PA WARNING MESSAGE ANL5018W SHOULD CAUSE RC=12 BUT RESULTS IN RC=00. MSGANL5018W. PTF2205
PK14394
3_Jan
2006
UK10500


SLOW PERFORMANCE WHEN EEE ( EASY EXPLAIN FUNCTION ) IS INVOKED VIA SQL PA. DUE TO POOR ACCESSPATH.
PK11683
13_Oct
2005
UK08110


LONG RESPONSE TIMES AFTER CONVERSION TO R220.
PK02940
8_Jul
2005
UK05248


DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD WITH,ED TOKEN ( SET
PK00861
30_Mar
2005
UK01941


SQL PA STORED PROCEDURE ANLPROCR ENDS WITH SQLCODE430 -430.
PQ96619
17_Jan
2005
UQ96909


EXECTUTING SQLPA BATCH PROGRAM RECEIVED ABEND04E RSC=00C89012 REASON CODE 00C89012

Top of page