DB2 FOR LUW / DB2FORLUW / A10 - DB2

Starting DB2 9.5 FP8, declaring a global temporary table may 
result in SQL20208N  rc=4 when all of the following conditions 
are satisfied: 
 
 
- the global temporary is declared using the AS (fullselect) 
syntax 
 
- the fullselect references multiple tables with different 
security policies 
 
 
 
SQL20208N  Table "<table-name>" cannot be created. Reason code = 
      "<reason-code>". 
 
Explanation: 
 
The table cannot be created because it violates a restriction as 
indicated by the following reason code: 
 
4. A materialized query table that references a protected table, 
a view 
   that depends on a protected table, or a nickname on which 
caching is 
   not allowed cannot be created.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP4 or later                             * 
****************************************************************

N/A

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 10.1 FP4

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC99300 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

17.10.2013
28.07.2014
28.07.2014