|
DB2 SQL Performance Analyzer Version 4.2
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2017 |
SQL PA FAILS WITH DSNT408I SQLCODE = -104 OR SQLCODE = -206 | ||||
2017 |
THE HIGHEST RETURN CODE WILL BE RETURNED IF AN ERROR MESSAGE IS DISPLAYED IN ANLCAT | ||||
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 |
TO ALLOW ISPF BATCH SQL PA PRIMARY COMMAND TO GENERATE JCL WITH SDSNEXIT IN STEPLIB. | ||||
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 |
ANL1016E DB2 SQLCODE = -553, IOS OPERATION = 21 ERROR OCCURRED DURING ASSIGNMENT OF USEPLAN AUTHID P_T | ||||
2016 |
SQLCODE104 IN WIF | ||||
2015 |
UNEXPECTED MSGANL2002E WHEN PROCESSING PROCESSING SELECT INTO:H WITH INNER JOIN. | ||||
2015 |
UNEXPECTED MSG "PLANS MUST USE PKLIST" ON PANEL ANLPPLAN | ||||
2015 |
EXPLAIN OF A NSP PACKAGE CREATED BY DATA STUDIO FROM DB2 CATALOGIS INCOMPLETE OR FAILS WITH SQLCODE199 OR SQLOCDE104 | ||||
2015 |
SQL COMMAND ON OPTION 1.3, 1.4 OR 1.5 RESULTS IN REPORTS PARAMETER TO RESET TO LOG AND EMPTY EXPLAIN AND DETAIL REPORTS |
||||
2015 |
MSGANL0538E EXPLAIN FAILED WITH SQLCODE204 WHEN ATTEMPTING TO DYNAMICALLY EXPLAIN A PACKAGE WITH A CURSOR USING MULTIPLE CTES. |
||||
2015 |
SQLPA CREATES DB2 10 NFM DSN_DETCOST_TABLE WITH 125 COLUMNS RATHER THAN THE EXPECTED 132 COLUMNS WHEN USING ANLCHECK | ||||
2015 |
EXPLAIN PUTS TSO USER ID IN LOCATION PLACE AND RECEIVED SQLCODE -512 | ||||
2015 |
WHEN AN ALIAS OWNER IS SPECIFIED ON THE PACKAGE PANEL INSTEAD OFA TABLE OWNER, THE PLAN TABLE REPORT IS EMPTY. | ||||
2015 |
INCLUDE DECLARE CURSOR INFORMATION IN THE SQL STATEMENT WHEN EXPLAINING A DBRM | ||||
2015 |
SQL PA 4.2 USER GETS DSNT408I SQLCODE = -204 +OFF+.PLAN_TABLE IS AN UNDEFINED NAME WHEN GENERIC TABLES WERE REQUESTED | ||||
2015 |
MSGANL1031I DB2 OBJECT NOT FOUND (TABLE OR COLUMN NAME) NNNNNN, SQLCODE -204, WHEN EXPLAIN FROM A DBRM | ||||
2014 |
IBM0461S ONCODE=300 THE OVERFLOW CONDITION WAS RAISED IN SQL PA4.2. | ||||
2014 |
MSGANL2001E WITH SQLCODE104 WHEN 'DECIMAL POINT IS' ON INSTALLATION PANEL DSNTIPF IS SET TO COMMA(,) | ||||
2014 |
WHAT-IF PROCESSING ENHANCEMENTS | ||||
2014 |
ALLOW MORE THAN ONE FULLY QUALIFIED DBRM ALLOCATED AS INPUT FOR PROCESSING DBRMS IN BATCH. | ||||
2014 |
NOT ALL SQL STATEMENTS FROM A PACKAGE ARE DISPLAYED IN THE "QUERY LIMITS REPORT". | ||||
2014 |
NOT REPORTING ACCESS TYPE OF NR | ||||
2014 |
SQLCODE104 AND SQLCODE204 ERRORS DUE TO WITH CLAUSE AND/OR INTO CLAUSE PROCESSING | ||||
2014 |
WHEN PROCESSING A PACKAGE FROM DB2 CATALOG IN BATCH, OPTION 1.2,SQL PA DOES NOT CREATE REQUIRED DETCOST AND PREDICAT TABLES. | ||||
2014 |
MSGANL8005I SHOWS THREE LAST DIGITS OF THE TOTAL NUMBER OF THE PROCESSED DB2 OBJECTS. | ||||
2014 |
SQLPA LOOPS FILLING SYSPRINT WITH MESSAGES AFTER B37, D37 OR E37ON OUTSTAT DD OF ANLCAT PROGRAM | ||||
2014 |
NEW FUNCTIONS | ||||
2014 |
JOB CARD UPDATE WITH USER PARMS | ||||
2014 |
VARIOUS SIZE ERRORS ANL1070W ANL3034E ANL3099E COND = 340 | ||||
2014 |
SQLCODE206 -206 DUE TO MISSING TABLE QUALIFIER IN WHERE CLAUSE | ||||
2014 |
SQLPA HANGS WHILE RECALLING DATASETS (LIKE ANLCOST.LOG) FORCING TSO USER TO CANCEL THE TSO SESSION | ||||
2014 |
NEW ACCESSPATH FORMAT OF THE PLAN TABLE REPORT | ||||
2014 |
SQLCODE104 EXPLAINING PACKAGE IN DB2 10 CM 14/06/05 PTF PECHANGE |
||||
2014 |
SQLPA NEW FEATURES | ||||
2014 |
DUPLICATE LINES IN THE PLAN_TABLE DATA OF THE "EXPLAIN INFORMATION FOR STATEMENT" REPORT OF THE EEE FILE. | ||||
2014 |
SQLPA FAILS TO EXPLAIN STATEMENTS FROM STORED PROCEDURE. | ||||
2014 |
LOCAL EXPLAIN OF REMOTE PACKAGE USING DRDA | ||||
2014 |
REMOVE THE NEED TO CREATE EEE TABLE FOR EACH USER | ||||
2014 |
TOO MANY BLOCKS AND SQLS SHOWN IN THE "PLAN_TABLE" REPORT | ||||
2014 |
DB2 11 EXPLOITATION AND OTHER ENHANCEMENTS AND FIXES | ||||