Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Unanswered: db2 error message

    Please assist me in correcting this error:

    DBA2191E SQL execution error.

    com.ibm.db.DataException: A database manager error occurred. : [IBM][CLI Driver][DB2/NT] SQL0973N Not enough storage is available in the "APP_CTL_HEAP" heap to process the statement. SQLSTATE=57011

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    some info from online infocenter
    # Change the value to the recommended value of 1024 (4-KB pages) or to a larger value. You can issue the following command, where db_name identifies your database:
    UPDATE DATABASE CONFIGURATION FOR db_name USING APP_CTL_HEAP_SZ 1024
    # Disconnect all applications from the database.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Feb 2007
    Posts
    10
    Thanks...it worked.

Posting Permissions

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