increase UDF_MEM and APP_CTL_HEAP_SZ size

[Ralf Gross]

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

[Blair Adamache]

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

[Ralf Gross]

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