db2 ? sql will point you in the right direction info as below

SQL0905N 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>".

Explanation:

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.

User Response:

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.

sqlcode : -905

sqlstate : 57014





"santoshshaastry" <db2udbdba-ezmlmshield-x2082088.[Email address protected]
20/02/2006 09:13

To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: SQLSTATE 57014 error...






While i was trying to execure a query(quite a big one) iam getting the
following error...can anyone elaborate on this??
SQL0905N Unsuccessful execution due to resource limit being exceeded.
Resource name = " ", limit = " " CPU seconds (" " service units) derived
from " ". SQLSTATE=57014
Regards,
Santosh shaastry.

************************************************************
HSBC Software Development (India) Pvt Ltd
HSBC Center Riverside,West Avenue ,
25 B Kalyani Nagar Pune 411 006 INDIA

Telephone: +91 20 26683000
Fax: +91 20 26681030
************************************************************


-----------------------------------------
***********************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.

Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
***********************************************************************



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page