|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
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 |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > Updating dbm cfg parameters from Application Program |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|