If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > sql code : -954

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-18-09, 06:54
dbBash dbBash is offline
Registered User
 
Join Date: Mar 2009
Posts: 15
sql code : -954

Hi,

While fetching records from the table using simple select query I am getting the following error after some records are returned.

com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -954, SQLSTATE: 57011, SQLERRMC: null

I found that 57011 is the resource unavailibity error but could not found anything baout the sql code -954.

Can anyone tell me whats exactly this error is ?

Thanks
Reply With Quote
  #2 (permalink)  
Old 11-18-09, 07:22
Stealth_DBA Stealth_DBA is offline
Registered User
 
Join Date: May 2009
Posts: 472
dbBash, If you don't have the manuals you can type:

DB2 ? SQLxxxxc

In a DB2 Command window to display the text of the SQL error message. Or you can go to the DB2 Information Center and search for the error code (ie. SQL0954C).

Code:
SQL0954C

Not enough storage is available in the application heap to process the 
statement.
Explanation

All available memory for the application has been used.

The statement cannot be processed.
User response

Terminate the application on receipt of this message. If the applheapsz 
database configuration parameter is set to AUTOMATIC, you will need to 
increase either the APPL_MEMORY database configuration setting, or the 
INSTANCE_MEMORY database manager configuration setting. Otherwise, 
increase the applheapsz database configuration parameter to allow a larger 
application heap.

When updating configuration parameters, it is recommended to change 
them by 10% of the current size at a time until the error condition is 
resolved. To change applheapsz, enter a command similar to the following, 
which sets applheapsz to size 4000 for database sample:

db2 UPDATE DB CFG FOR sample USING APPLHEAPSZ 4000

If all associated configuation parameters are set to either AUTOMATIC or 
COMPUTED, then the memory demands of the instance exceed the amount 
of memory configured on the machine. Possible solutions include reducing 
the database workload, enabling the connection concentrator feature, or 
adding additional memory to the machine.

sqlcode: -954

sqlstate: 57011

Last edited by Stealth_DBA; 11-18-09 at 12:07.
Reply With Quote
  #3 (permalink)  
Old 11-18-09, 10:57
surgeon surgeon is offline
Registered User
 
Join Date: Nov 2009
Posts: 7
sql code -954

SQL0954CNot enough storage is available in the application heap to process the statement.
Explanation:
All available memory for the application has been used.

The statement cannot be processed.

User response:
Terminate the application on receipt of this message. Increase the database configuration parameter ( applheapsz) to allow a larger application heap.

sqlcode: -954

sqlstate: 57011


Thanks

Surgeon
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On