|
DB2 SQL Performance Analyzer Version 5.1
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2024 |
SQL PA ABENDS WHEN PROCESSING EXPLAIN STATEMENTS FROM A DBRM IF THE SQL STATEMENT LENGTH EXCEEDS 32K. | ||||
2024 |
SQL PA TRIGGERING SQLCODES -518 AND -423 IN MODULES ANLEEE AND ANLCHECK ( SQLCODE518 , SQLCODE423 ) | ||||
2024 |
COMPARE REPORT ENHANCEMENT | ||||
2023 |
EXPLAIN IN SQL PA ENDS WITH CODE -060 AND -60 DUE TO THE WRONG LIMIT IN CAST FUNCTION. | ||||
2023 |
POOR PERFORMANCE FOR TEST FUNCTION | ||||
2023 |
MINOR SQL PERFORMANCE ANALYZER ENHANCEMENTS. | ||||
2023 |
MACRO ANLCSPA CANNOT EXTRACT SQL WHEN DELETE OR UPDATE STATEMENTS HAVE IN THE EXPRESSION KEYWORD CURRENT. | ||||
2023 |
NEW COLUMNS UNCONDITIONALLY ADDED TO SQLPA EXPLAIN TABLES IN BATCH MODE | ||||
2023 |
SOME QUERIES ARE NOT DISPLAYED IN QUERY LIMIT REPORT FOR OPTION 1.9 - PROCESS STABILIZED DYNAMIC QUERIES. | ||||
2023 |
MINOR USABILITY | ||||
2023 |
SQLPA TEST ENHANCEMENTS FOR APREUSE | ||||
2023 |
SQLPA COMPATIBILITY WITH DB2ZAI AFTER APAR PH44421 | ||||
2023 |
NEW FUNCTION | ||||
2022 |
PROPER ERROR HANDLING FOR PROMPT PANEL FOR SELECTING COLLECTION AND VERSION ON REMOTE LOCATION | ||||
2022 |
NEW FUNCTION | ||||
2022 |
EXCESSIVE NUMBER OF EXECUTE STMTS" CUSTOMIZING MORE THAN 8 GENERIC USERIDS | ||||
2022 |
PROBLEM WITH PARSING SQL STATEMENTS DOUBLE-QUOTES. | ||||
2022 |
INCORRECT CURSOR PLACEMENT IN PLAN_TABLE REPORT | ||||
2022 |
TCZ DISCOVERY FUNCTION GIVES AN ERROR "'SAMPLIB1' WAS NOT FOUND IN CATALOG" WHEN COMMAND RUN IS CALLED | ||||
2022 |
SQLPA CANNOT HANDLE CONCAT STATEMENT WHEN IT'S IN JOIN STATEMENT | ||||
2022 |
SYNTAX ERROR IN ANLICRE8 MODULE FOR CLIST GENERATED JCL | ||||
2022 |
EXPLAIN FOR MERGE STATEMENTS DOESN'T WORK WHEN IT'S RUN VIA ANLCSPA MACRO | ||||
2022 |
NEW FUNCTION | ||||
2022 |
NEW FUNCTION | ||||
2022 |
ANLCREXX ISSUE IF PACKAGE DSNTIAD IS BOUND AT FL506+ | ||||
2022 |
LOST CONNECTION TO THE REMOTE LOCATION WHEN PROCESSING EXPLAIN PACKAGE VIA SQL OPTION. | ||||
2022 |
NEW FUNCTION | ||||
2021 |
TEST FUNCTION WITH STATEMENT MATCH 2 DOES NOT DO CORRECT STATEMENT MATCHING IN SOME CASES | ||||
2021 |
NEW FUNCTION | ||||
2021 |
PROBLEM WITH GENERATED STATEMENTS AND WITH PREFIXES FOR DATASET ALIASES DURING CUSTOMIZATION. | ||||
2021 |
ONCODE=340 THE SIZE CONDITION WAS RAISED IN ANLCAT MODULE | ||||
2021 |
ANLPTEX RETURNS SQL ERROR -514 DURING CLOSING CURSOR | ||||
2021 |
IMPROVE ACCESS TO EXISTING EXPLAIN INFORMATION | ||||
2021 |
TEST FUNCTION USES WRONG VERSION ID FOR REBIND STATEMENT | ||||
2021 |
ERROR DURING EXPLAIN QUERY WITH 'FETCH FIRST ? ROWS' CLAUSE IS NOT HANDLED PROPERLY | ||||
2021 |
PROVIDE OPTIONAL INDICES FOR PERFORMANCE | ||||
2021 |
COMPARE TO PREVIOUS FUNCTION SHOULD USE PREVIOUS VERSION ID IN PACKAGE | ||||
2021 |
MACRO ANLCSPA INCORRECTLY PROCESSES SOME SQL'S WHICH CONTAIN EXPRESSION 'CURRENT DATE' | ||||
2021 |
SQL PA PERFORMANCE IMPROVEMENTS | ||||
2021 |
PLAN TABLE REPORT SHOWS DUPLICATE STRINGS WITH PROCESSOR COST INFORMATION FOR PACKAGES WITH THE SAME QUERYNO | ||||
2021 |
SQL/PA - RUNNING TEST ON COLLECTION GETTING ABENDU4087 DUE TO LIMITATION FOR ARRAY SIZE | ||||
2021 |
DOING OPTION 1 GOING TO A REMOTE SSID, GETTING RESULT BACK, THENGO TO OPTION 3 TO THE SAME LOCATION GET UNABLE TO CONNECT | ||||
2021 |
CODE -104 DOING A DYNAMIC EXPLAIN IN SQL PA | ||||
2021 |
INCORRECT EXPLAIN OUTPUT USING ANLCSPA | ||||
2021 |
SQL/PA - ANLPTTST - GETTING ANL0206E WHEN RUNNING TEST ON TRIGGER PACKAGE | ||||
2021 |
NEGATIVE VALUE FOR COLLECTED COUNTS STATISTIC | ||||
2020 |
GRANT STATEMENTS ARE NOT EXECUTED DURING PRODUCT CUSTOMIZATION | ||||
2020 |
DYNAMIC EXPLAIN IN SQL PA GETS -199 ERROR | ||||
2020 |
PAGE NUMBERS DO NOT APPEAR IN SQL PAR REPORT | ||||
2020 |
ANLPUPRM PF3 DOES NOT WORK. | ||||
2020 |
PROBLEM WITH MIXED CASE VERSION IDS | ||||
2020 |
LINE COMMANDS FOR SQL WITH HISTORY TABLES IN BLOCK REPORT. | ||||
2020 |
SQL/PA HAVING FCSVCOMP Y WITHOUT THE CORRESPONDING DDNAME ANLCSVCF ABENDS WITH 4038. | ||||
2020 |
CAPTURE COST AND PATH INFORMATION FOR NEW SQL | ||||
2020 |
PROTECT SQL PA COMPARE AND TEST FUNCTION FROM OVERFLOW CONDITION | ||||
2020 |
SQL PA COMPARE FUNCTION DOES NOT HANDLE PROCESS WHEN TOTAL_COST VALUE IS 0 | ||||
2020 |
SQL PA DOES NOT EXTRACT AND EXPLAIN SQL STATEMENTS FROM PROGRAM SOURCE WITH HOST VARIABLES WHICH CONTAINS DOUBLE DASHES | ||||
2020 |
AUTOMATE BUFFERS POPULATION IN SQLPA SYSTEMS PARAMETERS | ||||
2020 |
INCORRECT ANL2021W MESSAGE DUE TO USING IBM_SERVICE_DATA FIELD FOR VERSION 12 | ||||
2020 |
ANLPQBR1 - LINE COMMANDS DO NOT WORK WHEN DOING EXPLAIN TO A REMOTE LOCATION | ||||
2020 |
DBRM MODULES WERE NOT UPDATED WITH CORRECT VERSION ID WITHIN PTF | ||||
2020 |
SQL PA IS NOT HANDLE CONCENTRATE LITERALS (& SIGN) | ||||
2020 |
ANL0538E ERROR MESSAGE DURING DYNAMIC EXPLAIN | ||||
2020 |
RFE 126824 - ADDING VALUES FROM DSN_DETCOST_TABLE TO THE CSV REPORT | ||||
2020 |
COMPARE FUNCTION HANDLES PACKAGE WITH EMPTY TABLE NAME IN PLAN IN WRONG WAY | ||||
2020 |
COMPARE FUNCTION DOES NOT HANDLE TEMPORAL TABLES CORRECTLY | ||||
2020 |
RFE 126824 - CREATE COMPARE AND TEST REPORT IN CSV FORMAT | ||||
2019 |
USER GETS SQL CODE - 204 IN SQL PA OPTIONS 1.1 WHEN TABLE DSN_DETCOST_TABLE WAS NOT DEFINED | ||||
2019 |
FIX OPEN CURSOR ISSUE CAUSING LOOPING SYMPTOMS | ||||
2019 |
PROVIDE NEW FILTERS TO TEST AND COMPARE | ||||
2019 |
ADD THE PERCENTAGE CHANGE FIELD TO THE DELTA REPORT | ||||
2019 |
IMPLEMENT REPORTCOSTGT IN SQLPA AS A DEFAULT BEHAVIOR | ||||
2019 |
SQLCODE = -104 MAY OCCUR IF COMMA IS USED AS DECIMAL POINT VALUEIN ZPARM | ||||
2019 |
ANL0205E FOR COMPARE WHEN ONLY ONE VERSION OF A PACKAGE EXISTS IN A PLAN TABLE | ||||
2019 |
SQLCODE104 WHEN EXPLAIN FROM A DBRM | ||||
2019 |
ENHANCEMENTS TO COMPARE & TEST REPORTING SELECTIVITY BASED ON COST CHANGE PERCENT, TIMESTAMP, AND DBRM EXISTENCE | ||||
2019 |
PROVIDE COST INFORMATION IN QUERY BLOCK REPORT | ||||
2019 |
UI62615 |
SQLPA COMPARE FUNCTION ABENDS DUE TO OUT OF MEMORY APARNOPUB | |||
2019 |
CUSTOMER WANTS AN EASY WAY TO SELECT EXISTING VERSION IDS WHEN EXPLAINING PACKAGES FROM THE CATALOG | ||||
2019 |
EXPLAIN SHOWS INDEX ACCESS WITH COLUMNS NOT IN THAT INDEX | ||||
2019 |
MODIFY SUPPORT FOR MISSING SEMICOLON IN THE INPUT SQL | ||||
2019 |
TSO/E COMMAND ALLOCATE DD ANLTERM1 IS NOT COMPLETED | ||||
2018 |
SQLCODE -418 FOR DYNAMIC EXPLAIN OF REMOTELY BOUND PACKAGE | ||||
2018 |
ADD SUPPORT FOR MISSING SEMICOLON IN THE INPUT SQL | ||||
2018 |
UI62846 |
COMPARE SHOWS ONLY FIRST CHANGE IN QUERY BLOCK | |||
2018 |
ERROR DURING TEST WITH CCSID 930 | ||||
2018 |
ACTION COMPARE USING WILDCARD STOPS AFTER FIRST PACKAGE. | ||||
2018 |
SQL PA IS UNABLE TO CREATE A VIRTUAL INDEX ON A TABLE WITH MORE THAN 64 COLUMNS. | ||||
2018 |
EXPAND PARM ANLWLMEV "NAME OF WLM APPLENV FOR STORED PROCEDURE" TO 32 | ||||
2018 |
DB2 12 COMPATIBILITY ISSUES | ||||
2018 |
ALLOW TO DISPLAY A SEQUENCE OF THE COLUMNS DEFINED IN THE INDEX IN THE OPTION 'I - INDEX INFO'. | ||||
2018 |
ANL0546E AND SQLCODE=100 DISPLAYED FOR VIRTUAL INDEX IN PLAN TABLE REPORT. | ||||
2018 |
OBSOLETE MESSAGE ANL5015W AND ETC. | ||||
2018 |
MISSING STATEMENTS FROM STATIC PACKAGE EXPLAIN WHEN QUERYNO CLAUSE DOES NOT MATCH STMTNOI | ||||
2018 |
PFSHOW ON COVERS LAST LINE OF ANLPDYNE PANEL | ||||
2018 |
PACKAGE AND COLLECTION NAMES INCORRECTLY CHANGED TO UPPERCASE INTEST AND COMPARE | ||||
2018 |
FAILED CREATING PREDICATE TABLE WHEN DISPLAYING STATIC PACKAGE EXPLAIN | ||||
2017 |
IMPROVEMENTS FOR TEST AND COMPARE | ||||
2017 |
"NEW STATEMENTS" BEING REPORTED INCORRECTLY | ||||
2017 |
NEW FUNCTION | ||||
2017 |
SQL PA FAILS WITH DSNT408I SQLCODE = -104 OR SQLCODE = -206 | ||||
2017 |
STATEMENT MATCHING VALUE 1 MATCHES BY QUERY BLOCK RATHER THAN BYSTATEMENT. | ||||
2017 |
THE HIGHEST RETURN CODE WILL BE RETURNED IF AN ERROR MESSAGE IS DISPLAYED IN ANLCAT | ||||
2017 |
DB2 SERVICEABILITY | ||||
2017 |
SET CURRENT SQLID ON ANLPFILE | ||||
2017 |
ALLOW SPLIT SCREEN ISPF MODE. | ||||
2017 |
ANL108E - AN INTERNAL ERROR OCCURRED WHEN PROCESSING COMPARE OF PACKAGES, PANEL ANLPTCMP. | ||||
2017 |
SQLCODE -305 ON DB2 11 PLAN_TABLE MIGRATED FROM DB2 10 | ||||
2017 |
SQLCODE -122 ON EXPLAIN OF QMF QUERY WITH COMMENTS | ||||
2016 |
IMPROVEMENTS FOR CREATING PHYSICAL AND VIRTUAL INDEXES. | ||||
2016 |
TO ALLOW ISPF BATCH SQL PA PRIMARY COMMAND TO GENERATE JCL WITH SDSNEXIT IN STEPLIB. | ||||
2016 |
NEW QUERY BLOCK REPORT | ||||
2016 |
SQL PA IS FAILING TO PROCESS WILD CHARACTERS IN THE "PACKAGE NAME"- QUERY LIMITS REPORT IS INCOMPLETE. | ||||
2016 |
TO SET THE CURRENT SQLID IN THE GENERATED B3WLMSAB, TEMPLATE ANLWLMSP, JOB. | ||||
2016 |
ADD SUPPORT FOR DB2 VERSION 12 V12 | ||||
2016 |
INVALID EXPLAIN RESULTS WHEN DB2 COMMENTS WITH QUOTES ARE PRESENT INSIDE OF THE EXPLAINABLE SQL STATEMENT. | ||||
2016 |
NEW DATAGRP PARAMETER TO RESTRICT USER TABLE DATA ACCESS AND NEWSETPLAN VALUES FOR GREATER CONTROL OF GENERIC ID USE. | ||||
2016 |
ANL1016E DB2 SQLCODE = -553, IOS OPERATION = 21 ERROR OCCURRED DURING ASSIGNMENT OF USEPLAN AUTHID P_T | ||||
2016 |
SQLCODE104 IN WIF | ||||
2015 |
SQLCODE199 OR SQLOCDE104 OR INCOMPLETE EXPLAIN OF NSP PACKAGE CREATED BY DATA STUDIO AND ENHANCED COMPARE & TEST | ||||