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.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PQ96619
17_Jan
2005
UQ96908


EXECTUTING SQLPA BATCH PROGRAM RECEIVED ABEND04E RSC=00C89012 REASON CODE 00C89012
PQ89681
23_Jul
2004
UQ90427


SQL PA FAILS TO PROCESS ALL DBRM MEMBERS OR THE OUTPUT IS TRUNCATED WHEN PROCESSING MULTIPLE DBRM MEMBERS
PQ91028
23_Jul
2004
UQ90427


AE PQ90792
PQ88466
23_Jul
2004
UQ90427


NEGATIVE NUMBERS OR MISSING ENTRIES IN QLIMIT STATISTICS , MSGANL1008E UNCLEAR, ABENDU4091 WHEN LE ERRCOUNT EXCEEDED
PQ90792
6_Jul
2004
UQ90427


TSO SPA COMMAND FAILS WHEN TRYING TO INVOKE SQL PERFORMANCE ANALYZER
PQ90483
29_Jun
2004
UQ90192


SQLCODE104 WHEN USING OUTPUT FROM ANLSTAT AND DECIMAL=COMMA IN DSNZPARM
PQ84548
5_Mar
2004
UQ85896


MISPLACED HLQ WHEN A NESTED TABLE EXPRESSION (ENCLOSED IN PARENTHESES) FOLLOWS AN OUTER OR INNER JOIN PROCESSED BY SQL
PA
PQ77248
13_Oct
2003
UQ81075


ANLCOST DOES NOT PROCESS ALL ANLSCAN OUTPUT
PQ75356
21_Jul
2003
UQ78740


VARIOUS FIXES
PQ72303
15_May
2003
UQ76931

HIPER

SQLPA WILL HANLDE EITHER UPPER CASE OR LOWER CASE SQL STATEMENTS, AND ALSO THE NLSCODE SWITCH FOR DBCS
PQ70724
1_Apr
2003
UQ75628


INVALID DELETE ..... FROM SYSIBM.SYSINDEXSTATS SQL STATEMENT IN OUTSTAT WHEN RUN ANLSTAT JOB.
PQ68375
15_Jan
2003
UQ73139


MSGANL3033E FIXED OVERFLOW ERROR WAS DETECTED DURING CALCULATIONWHEN RUNNING SQL PA.
PQ66322
15_Nov
2002
UQ71812


MULTIPLE FIX FOR SQLPA V2.1
PQ65453
19_Sep
2002
UQ69984


TO FIX PACKAGING PROBLEMS IN UQ68620. INVALID ANLGIV1 AND ANLPLIIN SANLJCL. ANLSTART IS MISSING FROM SANLVCLS.
PQ63655
1_Aug
2002
UQ68620
PQ65453

MISCELLANEOUS POST GA FIXES.

Top of page