|
DB2 SQL Performance Analyzer Version 3.2
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2013 |
MSG EEE364W EXPLAINING A PACKAGE WITH GREATER THAN 8 CHARACTERS | ||||
2012 |
GENERATED SQLPA REPORT SHOWS ONLY 8 CHARACTERS OF DBRM NAME FIELD | ||||
2012 |
ANLPFILE DSNT408I -199 EXPLAIN CURSOR WITH HOLD SQLCODEN199 | ||||
2011 |
QUERY LIMIT REPORT GENERATING INCORRECT VALUES 11/11/30 PTF PECHANGE |
||||
2011 |
ANL1028W ERROR PROCESSING TABLE & INCORRECT COST INFORMATION | ||||
2011 |
MSG EEE538E BATCH JOB EXPLAINING SQL STATEMENT | ||||
2011 |
EXPLAIN FROM PANEL ANLPFILE GENERATES U4088 RC1004 | ||||
2011 |
DSN_DETCOST_TABLE INCORRECT COLUMN NAME IMPRED NOT IMMPRED | ||||
2011 |
CORRECT SQL/PA PROVIDED STORED PROCEDURE SAMPLE AND SQL TABLE ERRORS | ||||
2011 |
ANLPGM31 ISSUES RC12 FOR MESSAGES ANL5XXXW | ||||
2011 |
EXPLAIN ON TABLE INCORRECTLY GENERATES MSG ANL7039I | ||||
2010 |
EXPLAIN GENERATES DSNT408I SQLCODEN204 ON SYNONYM | ||||
2010 |
MSG DSNT230I RC08 RUNNING SAMPLE JOB ANLJJTST | ||||
2010 |
DSNT4081 SQLCODEN104 EXPLAIN ON PACKAGE OR PLANS | ||||
2010 |
DSNT408I SQLCODE -206 -418 ANLPPKGE ANLPLIM1 EXPLAINING PACKAGE WITH QUOTES OR SCALAR FUNCTION | ||||
2010 |
HOST VARIABLES MESSAGE INCORRECTLY ISSUED | ||||
2010 |
PANEL ANLPDBRM MAY GENERATE ABEND U4088 OR SQLCODE -104 | ||||
2010 |
ANLCAT31 GENERATES MSG IKJ56545I AND INCORRECT RESULTS WITH LONGCREATOR AND TABLE NAMES | ||||
2010 |
PANEL ANLPSYST DEFAULT DATABASE NAME CONTAINS INVALID VALUE | ||||
2010 |
QUERY LIMIT REPORT DOES NOT REPORT DBRM MEMBER NAME FOR TYPE NB STATEMENTS | ||||
2010 |
UPDATE TO SYSIBM.SYSCOLDISTSTAT COLUMN COLVALUE IS TRUNCATED RESULTING IN -530 WHEN THE SQL UPDATE IS RUN | ||||
2010 |
DSNT4081 SQLCODEN104 EXPLAIN SELECT STATEMENTS | ||||
2010 |
PANEL ANLPPKGE DOES NOT CONTAIN LOCATION NAME FOR REMOTE PACKAGE | ||||
2010 |
ANLPFILE -204 IN THE ANLEEE REPORT ON NON-EXISTENT PLAN_TABLE | ||||
2010 |
ABEND0C9 IN MODULE CUNMUNI. | ||||
2010 |
SQLCODE -104 AFTER MIGRATING TO DB2 V8. | ||||
2010 |
NEW FUNCTION - MR110708313 TERSE REPORT & MR0909087448 LIST DBRM | ||||
2010 |
PANEL ANLPFILE GENERATES MSG ANL3028E & ANL7039I WITH COMMON TABLE EXPRESSION. | ||||
2010 |
PANEL ANLPSQL GENERATES INCORRECT STMTS | ||||
2009 |
PANEL ANLPPKGE INVALID COLLECTION ERROR UNDEFINED CALL BY REFERENCE ERROR | ||||
2009 |
MSG EEE538E:H:H HOST VARS IN DBRM | ||||
2009 |
MSG IKJ56545I ISSUED FROM PANEL ANLPDBRM WHEN MEMBER NAME IS % | ||||
2009 |
IN ANLCHECK GETTING MESSAGE FAILED CREATING DSN_FUNCTION_TABLE | ||||
2009 |
ANLEEE REPORTS INCOMPLETE INFORMATION FOR REMOTE PACKAGE WHEN SOURCE CONTAINS UPPER AND LOWER CASE CHARACTERS | ||||
2009 |
PANEL ANLPSQLD SETTING SQLID TO BLANKS | ||||
2009 |
LOOP DURING INSERT INTO GLOBAL TEMP TABLE PROCESSING DBRM ABEND222 | ||||
2009 |
PANEL ANLPQUEN MSG EEE654E SQL CODE -204 | ||||
2009 |
EXPLAIN ON DBRM FAILES WITH MSG ANL1031I & DSNT408I SQLCODE -204 | ||||
2009 |
CANNOT SPECIFY SQLPA VERSION ID ON PACKAGE. | ||||
2009 |
SQLPA COST SUMMARY REPORT NOT BEING GENERATED | ||||
2009 |
DSNT408I SQLCODE -204 EXPLAINING A PACKAGE WITH AN UNQUALIFIED NAME | ||||
2009 |
IRX0007I ERROR RUNNING ANLCSORT WITH INVALID PARAMETER | ||||
2009 |
SQLCODE -104 SQLCODE104 ILLEGAL SYMBOL IN SQLPA WHEN KOREAN CCSID 1364 IS IN USE | ||||
2009 |
ANLQSORT IS MISSING FROM SQLPA R320. | ||||
2009 |
CURRENT DEGREE DEFAULT | ||||
2009 |
ANLPFILE ANLPLIM1 ANLCSPA EDIT GENERATES SQLCODE104 SQLCODE -104 | ||||
2009 |
SQLPA QMF GOVERNOR EXIT DSQUEGV1 S0C1 DSQ50517 | ||||
2009 |
ANL1009W PARSING LEFT OUTER JOIN DSNT408I SQLCODE = -104 | ||||
2009 |
CUSTOMIZATION OF SQL/PA ANLPPARM ANLCANLI PARAMETER FILE NOT FOUND | ||||
2009 |
SQLPA ANLPPKGE EEE572E CONVERSION FROM UNICODE TO EBCDIC FAILED RC=0008, REASON=003 | ||||
2009 |
SQLPA ANLPPLAN EEE572E CONVERSION FROM UNICODE TO EBCDIC FAILED RC=0004, REASON=001 DSNT408I -104 | ||||
2009 |
MIG OF SYSINDEXSTATS INCORRECT SQLCODE = -117 | ||||
2009 |
INCOMPLETE REPORTS FROM ANLEEE | ||||
2009 |
ABEND0C9 IN CUNMCA2A X'2C0' | ||||
2009 |
ANLUSER0 DOES NOT HAVE THE PRIVILEGE | ||||
2009 |
DBRM REMOTE BIND EEE IS NOT CONVERTING UNICODE TO EBCDIC | ||||
2008 |
FIELD SIZES ARE TOO SHORT | ||||
2008 |
MSGANL1009W TOGETHER WITH SQLCODE= -104 SQLCODEN104 OR SQLCODE -208 SQLCODEN208. | ||||
2008 |
GETTING PARSER ERROR ANLPGM31 | ||||
2008 |
GETTING MESSAGE DSNT408I SQLCODE = -204 ON A VIEW | ||||
2008 |
AFTER EXPLAINING AN SQL-STATEMENT WITH SQL/PA, VIEW COST REPORT WITH LINE-COMMAND "C" (FROM PANEL ANLPLIM1), GET EDIT RC = 20. |
||||
2008 |
WHEN ANALYZING SQL IN SQLPA, THE FIRST CHARACTER OF THE HLQ OF THE PROGRAM NAME IS TRUNCATED. | ||||
2008 |
MESSAGE "EEE654E INSERT IN EEEPATH TABLE FAILED - SQL-CODE: -204" IS DISPLAYED ON THE EASY EXPLAIN REPORT. | ||||
2008 |
ISPF INTERFACE LOOPING WHEN =X ENTERED INTO THE PRIMARY COMMANDLINE FROM THE PANEL FOR BROWSING THE REPORTS PANEL. | ||||
2008 |
INCREASED ELAPSED TIME AND I/O | ||||
2008 |
PROVIDE NEW FUNCTION TO SATISFY MR0312083755 REQUESTING ABILITY TO ANALYZE SQL CONTAINING A SYNONYM, W/O NEED TO SET USEPLAN. | ||||
2008 |
SQL/PA AND EASY EXPLAIN LENGTH FAILURE. | ||||
2008 |
STARTUP CLIST (ANLCANLI) HANGS WHEN MEMBER <SSID>ISPF IS MISSINGFROM THE SANLSAMP LIBRARY, WHERE, <SSID> IS THE DB2 SSID | ||||
2008 |
EEE538E EXPLAIN OF SUPPLIED SQL-STATEMENT FAILED, SQLCODE -104 | ||||
2008 |
THE USER IS NOT BEING PROMPTED TO CANCEL THE QUERY WHEN ONE OF THE THRESHOLDS HAVE BEEN EXCEEDED. | ||||
2007 |
PROBLEMS FOUND DURING INTERNAL TESTING OF 3.2.0 | ||||