DB2 FOR LUW / DB2FORLUW / 970 - DB2

When you have oracle compatibility mode turned on and have a 
table that has fullkeycard of zero, you may receive SQL0413N if 
you try to query against table SYSIBMADM.DBA_INDEXES. Also, when 
you have a partitioned index that has fullkeycard of zero, you 
will receive SQL0413N if you query against table 
SYSIBMADM.DBA_IND_PARTITIONS. 
 
For example, 
db2set DB2_COMPATIBILITY_VECTOR=ORA 
db2 "CREATE TABLE foo(a int)" 
db2 "CREATE INDEX i on foo(a)" 
db2 "RUNSTATS ON TABLE db2user.foo ON KEY COLUMNS AND 
INDEXES ALL" 
db2 "SELECT * FROM SYSIBMADM.DBA_INDEXES" 
SQL0413N  Overflow occurred during numeric data type conversion. 
 
or 
 
db2set DB2_COMPATIBILITY_VECTOR=ORA 
db2 "CREATE TABLE foo(a INT)  PARTITION BY RANGE (a) (STARTING 
FROM (1) ENDING AT (100) EVERY (20))" 
db2 "CREATE INDEX i ON foo(a) PARTITIONED" 
db2 "RUNSTATS ON TABLE db2user.foo ON KEY COLUMNS AND 
INDEXES ALL " 
db2 "SELECT * from SYSIBMADM.DBA_INDEXES" 
SQL0413N  Overflow occurred during numeric data type conversion.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running servers on DB2 Version 9.7 on platforms    * 
* Linux, Unix and Windows, and querying against                * 
* SYSIBMADM.DBA_INDEXES or SYSIBMADM.DBA_IND_PARTITIONS        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* This problem is first fixed in DB2 Version v9.7 Fix Pack 7.  * 
****************************************************************

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 v9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

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

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

16.07.2012
20.10.2012
20.10.2012

9.7.FP7