In this post, you’ll learn about the error message -905 unsuccessful execution due to resource limit being exceeded,resource name = resource name limit = limit amount1 cpu seconds (limit amount2 service units) derived from limit source in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-905 unsuccessful execution due to resource limit being exceeded,resource name = resource name limit = limit amount1 cpu seconds (limit amount2 service units) derived from limit source
Reason for the Error
The execution of the SQL statement was terminated because a resource limit was exceeded.The name of the resource whose limit was exceeded is ‘resource name’.� It is also the name of the column in the resource limit specification table from which the limit was derived.� The limit that was exceeded in CPU seconds is ‘limit amount1’ and in service units it is ‘limit amount2’.The ‘resource name’ may be ASUTIME, which is the number of CPU seconds permitted for each SQL statement.� The maximum number of CPU seconds permitted is ‘limit amount1’.� The maximum number in service units is ‘limit amount2’.The source used to derive the limit amount is ‘limit source’ and is either the name of a resource limit specification table or a ‘system parameter’.If the source is a system parameter, the resource limit specification table did not contain an applicable entry or an error occurred while accessing the table.� In either case, the limit is obtained from an install (system) parameter.
Solution
Determine why this SQL statement took so long and take appropriate action.� Consider simplifying the SQL statement, restructuring tables and indexes, or contacting the installation group responsible for maintaining the resource limit specification tables. An application program that receives this return code can execute additional SQL statements.
