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 3.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK86336
5_Aug
2009
UK49036


ANLEEE REPORTS INCOMPLETE INFORMATION FOR REMOTE PACKAGE WHEN SOURCE CONTAINS UPPER AND LOWER CASE CHARACTERS
PK78706
14_Apr
2009
UK45756


ISPF TERMINAL 3270KN KATAKANA ISRE741 IN ANLSORT
PK78164
18_Feb
2009
UK44154


ON A DBRM REMOTE BIND EEE IS NOT CONVERTING UNICODE TO EBCDIC
PK78149
18_Feb
2009
UK44154


INCOMPLETE REPORTS FROM ANLEEE
PK76258
8_Jan
2009
UK42990


ABEND0C9 IN CUNMCA2A X'2C0'.
PK66762
30_Sep
2008
UK40348


ANL3031E OVERFLOW CONDITION DETECTED DURING INTERNAL CALCULATIONS. CHECK STATISTICS, CORRECT, THEN RE-RUN PROGRAM.
PK56754
30_Jan
2008
UK33348


EEE538E EXPLAIN OF SUPPLIED SQL-STATEMENT FAILED, SQLCODE -104
PK58852
30_Jan
2008
UK33360


THE USER IS NOT BEING PROMPTED TO CANCEL THE QUERY WHEN ONE OF THE THRESHOLDS HAVE BEEN EXCEEDED.
PK53911
26_Nov
2007
UK31592


DELETE OPERATION DURING INSERT
PK51794
19_Oct
2007
UK30462


SQLCODE -418
PK50134
12_Sep
2007
UK29130


SQLPA DETAIL TRACE REPORT GIVES WRONG INDEX STATISTICS. STATS FOR ONE INDEX MAY BE REPORTED AS FOR ANOTHER INDEX.
PK51210
12_Sep
2007
UK29130


ANLEEE ( EASY EXPLAIN ) FEATURE OF SQLPA REPORTS SHOW DATA FROM INTEGER FIELDS OF CATALOG INFO. THIS APAR CHANGES TO FLOAT
FIELD
PK42853
7_Sep
2007
UK28990


DB2 V9 EXPLOITATION IN THE SQLPA INTERFACE TO THE DB2 OPTIMIZER.
PK48705
7_Sep
2007
UK28990


UK26088 IN ERROR, MISSING A PRE-REQ ON UK26718. 07/07/14 PTF
PECHANGE
PK47423
29_Jun
2007
UK26718
PK48705

SQLPA ANLEEE EASY EXPLAIN FUNCTION REPORTS IGNORE MULTIROW MULTI ROW FETCH IN USER PROGRAMS CREATED UNDER DB2 V8.
PK45469
13_Jun
2007
UK26088


IN SQLPA PANEL ANLOPUT RECEIVE ERROR 9001 & "DS DOES NOT EXIST" INSTEAD OF GENERATING NEW REPORT DS AS ELSEWHERE IN PANELS.
PK43853
25_May
2007
UK25548


SQLCODE -104 SQLCODE104 ILLEGAL SYMBOL IN SQLPA WHEN KOREAN CCSID 933 IS IN USE.
PK42851
30_Apr
2007
UK24585


SQLPA ANLUSERN USERIDS CAN BE HUNG AFTER SESSIONS END.
PK40756
11_Apr
2007
UK23920


EEE REPORT LOOPING
PK37292
30_Mar
2007
UK23560


SQLPA DB2 V9 SUPPORT. CATALOG AND DOCUMENTATION CHANGES.
PK39592
6_Mar
2007
UK22739


SQLCODE -418 WHEN DETERMINING THE COST OF A DBRM
PK38017
16_Feb
2007
UK22292


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


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


SQLPA PANEL DIALOG PROBLEMS WITH PF3 ACTING LIKE "ENTER" ON SOME PANELS.
PK32601
21_Nov
2006
UK19938


DB2 V9 TOLERATION APAR.
PK30961
8_Nov
2006
UK19527


SQLPA REPORTS SUCCESSFUL ATTEMPT TO CREATE A CLUSTERING INDEX, BUT DB2 REPORTS IT REALLY FAILED.
PK30156
3_Nov
2006
UK19393


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


PERFORMANCE ENHANCEMENT WHEN A JOIN ON SYSIBM.SYSDUMMY1 IS NEEDED.
PK29956
8_Sep
2006
UK17855


DEVELOPMENT APAR TO PROVIDE A NEW MORE USER FRIENDLY FORMAT FOR THE OUTPUT OF THE COST REPORT. TO FULFILL MR111205611.
PK30301
8_Sep
2006
UK17856


WILDCARDS NOT WORKING.
PK28915
22_Aug
2006
UK17408


CREATE INDEX STATEMENT IS NOT POPULATING THE INDEX.
PK26399
21_Aug
2006
UK17367
PK30805

SEVERAL FIXES TO THE EEE COMPONENT OF SQLPA.
PK26397
4_Aug
2006
UK16941


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


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


SQLPA GENERATES SQLCODE -204 204 ( 71114 )
PK24422
9_Jun
2006
UK15296

HIPER

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


SQLPA R310 RECEIVE MSGANL1016E FATAL SQL ERROR ENCOUNTERED DURING ANL REGISTRY PROCESS W/ SQLCODE 12 IOS OPERATION 9.

Top of page