DB2 FOR LUW / DB2FORLUW / 970 - DB2

When creating new types in DB2, it is possible that a SQL20005N 
error occurs, even though the maximum number of types allowed in 
the database was not reached. 
 
SQL20005N  The internal identifier limit of "<limit>" has been 
exceeded 
      for object type "<object-type>". 
 
DB2 has a limit on the maximum TYPEID value that is allowed in 
the database.  When a new type is created DB2 will generate a 
new TYPEID based on the value of the largest TYPEID that is 
already in the database. 
 
If types are dropped/altered/inserted many times in a 
development environment (for example), it is possible that the 
TYPEID values go out of sync.   When that happens some TYPEID 
values get lost and do not get reused.  As such it is possible 
that the database system has the capacity for more types but the 
maximum value for the TYPEID was reached so DB2 returns an error 
message. 
 
 
DB2 should allow a little more than 28000 types in the database.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpak 8                         * 
****************************************************************

If possible, drop all the types in the database, and then 
recreate them one at a time.  That will ensure each TYPEID will 
be in proper sync.

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 Version 9.7, Fixpak 8

see Local Fix.

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

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

05.09.2012
15.04.2013
15.04.2013

9.7.