469,579 Members | 1,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

increase UDF_MEM and APP_CTL_HEAP_SZ size

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
Nov 12 '05 #1
2 6376
There's no need to bacup the database after thse commands. Depending on
which version of DB2 you're on, you may have to do a db2start to restart
the instance.

Ralf Gross wrote:
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


Nov 12 '05 #2
Blair Adamache wrote:
There's no need to bacup the database after thse commands. Depending on
which version of DB2 you're on, you may have to do a db2start to restart
the instance.


I think I have to restart the database, but that's not a problem.

Thanks

Ralf
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by msnews.microsoft.com | last post: by
9 posts views Thread by Ajay | last post: by
4 posts views Thread by =?Utf-8?B?R2F1cmF2?= | last post: by
3 posts views Thread by James Harris | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.