DB2 FOR LUW / DB2FORLUW / 970 - DB2

The following stack trace can be see in the FODC_AppErr 
directories when encountering the SQL0901N and "Unknown 
dependent object type: G" errors: 
 
2012-06-14-20.08.12.756886-240 I53976014E861       LEVEL: Severe 
PID     : 13207                TID  : 46919325837632PROC : 
db2sysc 1 
INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE 
APPHDL  : 1-31416              APPID: 
*N1.db2inst1040.120615000707 
AUTHID  : IBMDB2 
EDUID   : 3967                 EDUNAME: db2agent (SAMPLE) 1 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 32 
 sqlerrmc: Unknown dependent object type: G 
 sqlerrp : SQLRL50C 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFA6      (6) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
 
sqlzeSqlCode 
sqlrrSqlCode 
sqlrlCheckNonTABAUTHDepObjectPrivileges 
sqlrlTransferVerifyNewOwnerPrivileges 
sqlrlTransferObject 
sqlnq_transfer_ownership_end 
sqlnq_transfer_ownership_stmt 
 
DB2 is internally cross-checking the object type G (Created 
temporary tables) with an internal list as below: 
 A - Alias 
 R - Structured type 
 S - Summary table 
 D - Server definition 
 P - Pagesize 
 B - Trigger 
 Table row anchor 
 
This APAR is to add a new case type to the above list for 
created temporary table object G.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running servers on DB2 Version 9.7 on platforms    * 
* Linux, Unix and Windows, and running transfer ownership      * 
* command.                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 Version 9.7 Fix Pack 7.                        * 
****************************************************************

N/A

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
 

This problem is first fixed in DB2 Version 9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC88343 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

17.07.2012
20.10.2012
20.10.2012

9.7.FP7