Hi,
I have an java application that throws the following exceptions.
COM.ibm.db2.jdbc.DB2Exception -- COM.ibm.db2.jdbc.DB2Exception:
[IBM][CLI Driver][DB2/LINUX] SQL0973N Not enough storage is available
in the "UDF_MEM" heap to process the statement. SQLSTATE=57011
COM.ibm.db2.jdbc.DB2Exception -- COM.ibm.db2.jdbc.DB2Exception:
[IBM][CLI Driver][DB2/LINUX] SQL0954C Not enough storage is available
in the application heap to process the statement. SQLSTATE=57011
Do you have the following settings:
I know that I can increase the UDF_MEM size and APP_CTL_HEAP_SZ size
with the following statements.
db2 update dbm cfg using udf_mem_sz nnnn
db2 update db cfg for <db> using app_ctl_heap_sz nnnn
Is there a problem with the existing database <db>, or do I have to make
a backup of the <db> and restore it after issuing this update?
tia
Ralf