Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.