DB2 FOR LUW / DB2FORLUW / 970 - DB2

The case statement for OBJECTTYPE in  SYSIBMADM.PRIVILEGES and 
SYSIBMADM.OBJECTOWNERS contains A,H, N, S, T, U, V and W. 
However in SYSCAT.TABLES column "type" has two additional values 
G and L, were  G = Created temporary table  and L = Detached 
table.  This needs to be added to SYSIBMADM.PRIVILEGES and 
SYSIBMADM.OBJECTOWNERS. 
 
Object types available in 
SYSCAT.TABLES: 
A = Alias 
G = Created temporary table 
H = Hierarchy table 
L = Detached table 
N = Nickname 
S = Materialized query table 
T = Table (untyped) 
U = Typed table 
V = View (untyped) 
W = Typed view

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V9.7 on LUW users.                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix pack 7 or subsequent Fix Packs.      * 
****************************************************************

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 V9.7 Fix Pack 7

not known / see Local fix

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

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

11.04.2012
24.06.2013
24.06.2013

9.7.FP7