|
DB2 SQL Performance Analyzer Version 4.1
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
SQLCODE104 EXPLAINING PACKAGE IN DB2 10 CM 14/06/05 PTF PECHANGE |
||||
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 |
TOO MANY BLOCKS AND SQLS SHOWN IN THE "PLAN_TABLE" REPORT | ||||
2013 |
ONLY THE LAST REQUESTED DBRM EXPLAINED OF SEVERAL DBRMS SELECTEDFROM MULTIPLE PAGES OF THE ISPF MODE | ||||
2013 |
SQLCODE219 FOR OPTION 1.3 "PROCESS DBRMS" ON ANLPDBRM PANEL RUNNING ON DB2 V10 | ||||
2013 |
ANLCSPA GENERATES ERROR ANL1016E CAF CONNECTION ERROR | ||||
2013 |
PLAN_TABLE INCORRECTLY CREATED WITH VERSION COLUMN OF VARCHAR 64 | ||||
2013 |
EEE572E WHEN PROCESS PLANS FROM CATALOGAND OTHER MISCELANEOUS PROBLEMS RESOLVED | ||||
2013 |
EXPLAINING PACKAGE GENERATES MSG EEE538E SQLCODE -417 OR -418 | ||||
2013 |
PROVIDE VIEW ALTERNATE BROWSE IF VIEW IS NOT ENABLED. | ||||
2013 |
MSG IE3024I ISSUED INVOKING ANLCSPA TO EXPLAIN SQL | ||||
2013 |
SQLCODE -199, ERROR: ILLEGAL USE OF KEYWORD INTO ERROR MESSAGE WHEN RUNNING AN EXPLAIN | ||||
2013 |
SQLCODE -204 EXPLAINING SQL AFTER INNER JOIN | ||||
2013 |
PANEL ANLPTBLS MAY GENERATE INCORRECT RESULTS. | ||||
2013 |
CORRECT PROBLEM FOUND IN APAR FIX | ||||
2013 |
MISCELLANEOUS DEFECTS | ||||
2013 |
MSG EEE364W EXPLAINING A PACKAGE WITH GREATER THAN 8 CHARACTERS | ||||
2013 |
COMMAND LINE IS NOT RECOGNIZED ON ANLPREPT 'PRINT REPORT' SCREENIN SQLPA 4.1 | ||||
2012 |
SQLPA DOES NOT SET THE CORRECT DB2 SYSTEM ID | ||||
2012 |
TEMPLATES ANL3@ATH AND ANL3@SGN CONTAIN INCORRECT NAMES FOR DSN3SATH AND DSN3SSGN | ||||
2012 |
EXPLAIN ON SQL FROM PANEL ANLPFILE GENERATES MSG ANL1047W & ANL1016E SQLCODE -991 | ||||
2012 |
SQLPA 4.1 JOBS CREATED BY TCZ DROPS DATABASE | ||||
2012 |
GENERATED SQLPA REPORT SHOWS ONLY 8 CHARACTERS OF DBRM NAME FIELD | ||||
2012 |
TEMPLATE ANLQMFGV GENERATES ERROR MSG ASMA144E & ASMA435I | ||||
2012 |
ERROR MSG: INVALID INFORMATION ON PANEL ANLPSYST. | ||||
2012 |
PANEL ANLPQMF ISSUES MSG QMF QUERY NOT FOUND | ||||
2012 |
TCZ SPECIFIED COMMAND PROCEDURES LIBRARY IS USED FOR BOTH STEPLIB AND SYSPROC DSN IN GENERATED JCL | ||||
2012 |
JOBCARD TRUNCATION AND PANEL ANLPJCL DOES NOT SAVE CHANGES | ||||
2012 |
SQL PERFORMANCE ANALYZER GENERATES INCORRECT "DMTSSID" PARAMETER | ||||
2012 |
PANEL ANLPCOLL ANLPCOL2 GENERATE INCORRECT OUTPUT | ||||
2012 |
PANEL ANLPPKGE GENERATES LOOP AND MSG EEE358W ON UNQUALIFIED TB | ||||
2012 |
ANLPFILE DSNT408I -199 EXPLAIN CURSOR WITH HOLD SQLCODEN199 | ||||
2012 |
LOOP OCCURS EXITING FROM PANEL ANLPSQL EXPLAINING A PACKAGE | ||||
2012 |
SOME PARMS ARE NOT BEING READ IN PROPERLY FROM THE PARM FILES | ||||
2011 |
PANEL ANLPCOLL ANLPCOL2 GENERATE INCORRECT OUTPUT | ||||
2011 |
QUERY LIMIT REPORT GENERATING INCORRECT VALUES 11/11/30 PTF PECHANGE |
||||
2011 |
SSIDJTST RC12 ABEND04E RC00E20002 | ||||
2011 |
BATCH JOB LOOPING DUE TO MISSING ANLPRINT DD STATEMENT | ||||
2011 |
ANL1028W ERROR PROCESSING TABLE & INCORRECT COST INFORMATION | ||||
2011 |
EXPLAIN ON ANLPFILE GENERATES MSG FAILED CREATING PLAN_TABLE | ||||
2011 |
MSG EEE538E BATCH JOB EXPLAINING SQL STATEMENT | ||||
2011 |
EXPLAIN FROM PANEL ANLPFILE GENERATES U4088 RC1004 | ||||
2011 |
IMPLEMENT NEW OPTION TO THE TURNOFF PARAMETER IN SQL/PA | ||||
2011 |
PANEL ANLPFILE GENERATES CONTENTION WITH ONE USERID | ||||
2011 |
ADDRESS SQL/PA PROBLEMS DYNAMICALLY CREATE PLAN TABLE, OPTION 1.7 PROCESS QMF NOT WORKING, UNABLE TO RUN STORED PROCEDURE | ||||
2011 |
EXPLAIN GENERATES DSNT408I -204 OR -512 ON CTE | ||||
2010 |
SQL PERFORMANCE ANALYZER FOR Z/OS MISCELLANEOUS POST GA FIXES | ||||