Results 1 to 2 of 2

Thread: DB2 Memory

  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: DB2 Memory

    I'm using DB2 7.1 client on Solaris 8 to connect to Db2 database using the jdbc/app driver. Getting the following errors wtih DB2 conenction. Most of the cases we need to restart the application and it continues to work fine after that for some time. some times when there were too many errors, application crashes with a core dump.

    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL0930N There is not enough storage available to process the statement. SQLSTATE=57011

    or

    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL0973N Not enough storage is available in the "DRDA_HEAP_SZ" heap to process the statement. SQLSTATE=57011

    or

    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0120E Memory allocation failure. SQLSTATE=HY001

    Can any one suggest how to fix these issues with out upgrading DB2?

  2. #2
    Join Date
    May 2002
    Location
    Ukaine
    Posts
    5
    Hi udai78!
    try to increase maxagents and reduce resync_interval

Posting Permissions

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