By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Updating dbm cfg parameters from Application Program

P: 2
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_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
Dec 7 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.