home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IT01401 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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 V9.7 FixPack 10 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 V9.7 FixPack 10.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.04.2014
24.11.2014
24.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList