Topic
1 reply Latest Post - ‏2013-03-14T16:32:31Z by nivanov1
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic Error when trying to post an XML schema in DB2 for decomposition

‏2013-03-13T23:14:55Z |
i'm getting this error, can anybody tell me what seems to be the issue?

Register - DB2ADMIN.POM

DB2ADMIN.POM - Drop successful.
Not enough storage is available in the "AGENT_STACK_SZ" heap or stack to process the statement.. SQLCODE=-973, SQLSTATE=57011, DRIVER=4.13.111
DB2ADMIN.POM - Register failed.
DB2ADMIN.POM - Roll back completed successfully.

Already adjusted the APPLHEAPSZ number to something higher

CALL SYSPROC.ADMIN_CMD ('UPDATE DATABASE CONFIGURATION FOR SAMPLE USING APPLHEAPSZ 8128');
Updated on 2013-03-14T16:32:31Z at 2013-03-14T16:32:31Z by nivanov1
  • nivanov1
    nivanov1
    53 Posts
    ACCEPTED ANSWER

    Re: Error when trying to post an XML schema in DB2 for decomposition

    ‏2013-03-14T16:32:31Z  in response to SystemAdmin
    Did you restart the instance after changing the parameter? You should. If it still does not work, try increasing it some more. Take a look at this also: http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.xml.doc/doc/c0022711.html