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: 8 May 2018
DB2 SQL Performance Analyzer Version 5.1
APAR CLOSE
DATE		 PTF(s) Fixing APAR
if PE		 HIPER? Abstract
PI92557
3_May
2018
UI55635


OBSOLETE MESSAGE ANL5015W AND ETC.
PI93652
16_Apr
2018
UI55250


MISSING STATEMENTS FROM STATIC PACKAGE EXPLAIN WHEN QUERYNO CLAUSE DOES NOT MATCH STMTNOI
PI93656
16_Apr
2018
UI55250


PFSHOW ON COVERS LAST LINE OF ANLPDYNE PANEL
PI92100
26_Mar
2018
UI54756


PACKAGE AND COLLECTION NAMES INCORRECTLY CHANGED TO UPPERCASE INTEST AND COMPARE
PI89775
30_Jan
2018
UI53544


FAILED CREATING PREDICATE TABLE WHEN DISPLAYING STATIC PACKAGE EXPLAIN
PI88329
27_Nov
2017
UI52137


IMPROVEMENTS FOR TEST AND COMPARE
PI85821
9_Oct
2017
UI50953


"NEW STATEMENTS" BEING REPORTED INCORRECTLY
PI67294
18_Sep
2017
UI50385


NEW FUNCTION
PI81160
24_Jul
2017
UI49047


SQL PA FAILS WITH DSNT408I SQLCODE = -104 OR SQLCODE = -206
PI80513
26_Jun
2017
UI48323


STATEMENT MATCHING VALUE 1 MATCHES BY QUERY BLOCK RATHER THAN BYSTATEMENT.
PI73322
26_May
2017
UI47618


THE HIGHEST RETURN CODE WILL BE RETURNED IF AN ERROR MESSAGE IS DISPLAYED IN ANLCAT
PI64927
15_May
2017
UI47262


DB2 SERVICEABILITY
PI57604
30_Jan
2017
UI44309


SET CURRENT SQLID ON ANLPFILE
PI60906
30_Jan
2017
UI44309


ALLOW SPLIT SCREEN ISPF MODE.
PI63501
30_Jan
2017
UI44309


SQLCODE -305 ON DB2 11 PLAN_TABLE MIGRATED FROM DB2 10
PI64853
30_Jan
2017
UI44309


SQLCODE -122 ON EXPLAIN OF QMF QUERY WITH COMMENTS
PI71459
30_Jan
2017
UI44309


ANL108E - AN INTERNAL ERROR OCCURRED WHEN PROCESSING COMPARE OF PACKAGES, PANEL ANLPTCMP.
PI67088
29_Nov
2016
UI42960


IMPROVEMENTS FOR CREATING PHYSICAL AND VIRTUAL INDEXES.
PI62220
6_Sep
2016
UI40664


TO ALLOW ISPF BATCH SQL PA PRIMARY COMMAND TO GENERATE JCL WITH SDSNEXIT IN STEPLIB.
PI57258
29_Aug
2016
UI40425


NEW QUERY BLOCK REPORT
PI50401
29_Jun
2016
UI39054


SQL PA IS FAILING TO PROCESS WILD CHARACTERS IN THE "PACKAGE NAME"- QUERY LIMITS REPORT IS INCOMPLETE.
PI57077
29_Jun
2016
UI39061


TO SET THE CURRENT SQLID IN THE GENERATED B3WLMSAB, TEMPLATE ANLWLMSP, JOB.
PI55204
26_May
2016
UI38194


DB2 SERVICEABILITY
PI50142
6_Apr
2016
UI36824


INVALID EXPLAIN RESULTS WHEN DB2 COMMENTS WITH QUOTES ARE PRESENT INSIDE OF THE EXPLAINABLE SQL STATEMENT.
PI53952
17_Mar
2016
UI36310


NEW DATAGRP PARAMETER TO RESTRICT USER TABLE DATA ACCESS AND NEWSETPLAN VALUES FOR GREATER CONTROL OF GENERIC ID USE.
PI48992
29_Jan
2016
UI34873


ANL1016E DB2 SQLCODE = -553, IOS OPERATION = 21 ERROR OCCURRED DURING ASSIGNMENT OF USEPLAN AUTHID P_T
PI48522
15_Jan
2016
UI34486


SQLCODE104 IN WIF
PI51655
17_Dec
2015
UI33925


SQLCODE199 OR SQLOCDE104 OR INCOMPLETE EXPLAIN OF NSP PACKAGE CREATED BY DATA STUDIO AND ENHANCED COMPARE & TEST

Top of page