-
Updating dbm cfg parameters from Application Program
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 asswd;
EMB_SQL_CHECK("Connecting to database");
EXEC SQL CALL SYSPROC.ADMIN_CMD('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_CMD('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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|