logo  
Google
 

DB2 SQL-Error: -497

SQLState: 54041

Short Description: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE

The SQL statement cannot be executed because an internal identifier limit has been exceeded for the database. The cause of this error is due to one of the following: 1. On a CREATE DATABASE statement, the limit of 65279 DBIDs has been exceeded. 2. For all other statements, the limit of 32767 OBIDs has been exceeded for that database.System action: The SQL statement cannot be executed. Programmer response: Take the appropriate action as described in the following cases: 1. In the case of a DBID limit being exceeded, DROP all unused databases and issue a COMMIT. 2. In the case of an OBID limit being exceeded, DROP all unused objects in the database and issue a COMMIT, specify a different database or run the MODIFY utility to reclaim unused OBIDs.

 <-  BACK TO INDEX