Updating dbm cfg parameters from Application Program

[Lekh Raj]

Hi,
I want to update dbm cfg parameters DFT_MON_BUFPOOL and
DFT_MON_STMT from C program. I am using db2 version 9.1.2 on Linux
platform

When I use
"db2 update dbm cfg using DFT_MON_BUFPOOL ON DFT_MON_STMT ON"
command for this purpose "db2 get dbm cfg show detail" command
reflects changes in both current and delayed values of DFT_MON_BUFPOOL
and DFT_MON_STMT immediately.

I want to do same thing from C application programming

my code for this is given below..

=============== =============== =============== =
sqleatin(node, userid, passwd, &sqlca);
DB2_API_CHECK(" Attach to instance");

EXEC SQL CONNECT TO :dbalias USER :userid USING :passwd;
EMB_SQL_CHECK(" Connecting to database");

EXEC SQL CALL SYSPROC.ADMIN_C MD('UPDATE DBM CFG USING
DFT_MON_BUFPOOL ON DFT_MON_STMT ON IMMEDIATE');
EMB_SQL_CHECK(" update dbm cfg");
sqledtin (&sqlca);
DB2_API_CHECK(" Detach from instance");
EXEC SQL CONNECT RESET;
=============== =============== =============== =

but "db2 get dbm cfg show detail" command reflects changes only in
delayed values of both parameters not in current values.

I tried to update it by using API "sqlfusys" instead of " EXEC SQL
CALL SYSPROC.ADMIN_C MD('UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
DFT_MON_STMT ON IMMEDIATE')" , but I got same results.

Can someone help me with this?

Regards
Lekh Raj