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 IT02250 Status: Closed

DB2EXPLN CANNOT PRINT NAME FOR CGTTS, THEN PRINTS SQL0100W INSTEAD.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
The db2expln cannot print names for CGTTs, then prints SQL0100W 
instead. 
The following steps illustrates the problem. 
 
1. Create a CGTT 
db2 connect to sample 
db2 create global temporary table t1 like org 
 
2. Take an explain by db2expln. 
db2expln -d sample -q "select * from t1" -t 
 
The explain output shows no table name, then prints SQL0100W as 
below: 
 
(    2) Access Warning during FETCH for table. 
 
Message Text = 
SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the 
result of a 
query is an empty table.  SQLSTATE=02000 
 
sqlcaid   = SQLCA 
sqlcabc   = 136 
sqlcode   = 100 
sqlstate  = 02000 
sqlerrml  = 0 
sqlerrmc  = 
sqlerrp   = SQLRI01F 
sqlerrd0  = 0x80040001 = -2147221503 
sqlerrd1  = 0x00000001 = 1 
sqlerrd2  = 0x00000000 = 0 
sqlerrd3  = 0x00000000 = 0 
sqlerrd4  = 0x00000000 = 0 
sqlerrd5  = 0x00000000 = 0 
sqlwarn   = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' 
' 
 
Global Temporary Table Name = .  ID = -6,-32768 
   // missing table schema.name 
        |  |  Prefetch: Eligible 
        |  Sargable Predicate(s) 
(    1) |  |  Return Data to Application 
        |  |  |  #Columns = 5 
(    1) Return Data Completion
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who take db2expln against SQL statements involving     * 
* CGTTs.                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V10.1 FixPack 5 or later.              * 
****************************************************************
Local Fix:
Please use explain option to compile the statements, then format 
it by db2exfmt tool.
Solution
This problem was first fixed in DB2 V10.1 FixPack 5.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

05.06.2014
13.07.2015
13.07.2015
Problem solved at the following versions (IBM BugInfos)


Problem solved according to the fixlist(s) of the following version(s)


10.1.0.5

FixList