|
Problem IC61568
|
Status: Closed |
SQLCODE 20459 WHILE EXPLAINING QUERIES VIA DATA STUDIO WHEN EXPLAIN TABLES EXIST IN BOTH SESSION USERS & SYSTOOLS SCHEMA |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
First fixed in 9.1 FP8 |
| Local Fix: |
Have only one set of explain tables, either the session user
schema or the SYSTOOLS schema. |
| available fix packs: |
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
|
| Solution |
The fix for the subject APAR has been delivered to v91fp8,
v95fp5, and v97fp1. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC61569 IC61570
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2009
28.10.2009
28.10.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP8,
9.5.FP5,
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.8
|
 |
