Results 1 to 2 of 2

Thread: DB2 Memory

  1. #1
    Join Date
    Nov 2006

    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. [IBM][CLI Driver] SQL0930N There is not enough storage available to process the statement. SQLSTATE=57011

    or [IBM][CLI Driver] SQL0973N Not enough storage is available in the "DRDA_HEAP_SZ" heap to process the statement. SQLSTATE=57011

    or [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
    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