Results 1 to 3 of 3

Thread: sql code : -954

  1. #1
    Join Date
    Mar 2009
    Posts
    16

    Unanswered: 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

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    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 13:07.

  3. #3
    Join Date
    Nov 2009
    Posts
    21
    Provided Answers: 1

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •