|
Problem IC61568
|
Status: Geschlossen |
SQLCODE 20459 WHILE EXPLAINING QUERIES VIA DATA STUDIO WHEN EXPLAIN TABLES EXIST IN BOTH SESSION USERS & SYSTOOLS SCHEMA |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
problem:
SQLCODE 20459 with SQLSTATE 01H55 WHILE EXPLAINING QUERIES VIA
DATA STUDIO WHEN EXPLAIN TABLES EXISTS IN BOTH THE SESSION
USER'S AND THE SYSTOOLS SCHEMA
description:
When explain tables exist in the session user's schema and the
SYSTOOLS schema, explaining queries in Data Studio fails with:
Failed to collect explain data for the query access plan for
the target data server with SQLSTATE 01H55.
This error is caused by: db2luw20459E: SQLCODE: 20459,
SQLSTATE: 01H55, SQL20459W The procedure "SYSPROC.EXPLAIN_SQL"
has encountered an internal processing error. |
| Problem-Zusammenfassung: |
First fixed in 9.1 FP8 |
| Local-Fix: |
Have only one set of explain tables, either the session user
schema or the SYSTOOLS schema. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
The fix for the subject APAR has been delivered to v91fp8,
v95fp5, and v97fp1. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC61569 IC61570
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.06.2009
28.10.2009
28.10.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP8,
9.5.FP5,
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.8
|
 |
