Given your condition, it means you used:
db2 update monitor switches using statements on
This sets the switch on for your session only, not at the dbm cfg level.
DB2 will only provide snapshot statement based info to that session not to
any other appl. or session that would issue the snaphot command.
Example:
D:\SQLLIB\BIN>db2 get dbm monitor switches
DBM System Monitor Information Collected
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 2006-04-14
23.45.10.021050
Lock Information (LOCK) = ON 2006-04-14
23.45.10.021050
Sorting Information (SORT) = ON 2006-04-14
23.45.10.021050
SQL Statement Information (STATEMENT) = ON 2006-04-14
23.45.10.021050
Table Activity Information (TABLE) = ON 2006-04-14
23.45.10.021050
Take Timestamp Information (TIMESTAMP) = ON 2006-04-14
23.45.10.021050
Unit of Work Information (UOW) = ON 2006-04-14
23.45.10.021050
D:\SQLLIB\BIN>db2 update monitor switches using statement off
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
D:\SQLLIB\BIN>db2 get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 2006-04-14
23.45.10.021050
Lock Information (LOCK) = ON 2006-04-14
23.45.10.021050
Sorting Information (SORT) = ON 2006-04-14
23.45.10.021050
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = ON 2006-04-14
23.45.10.021050
Take Timestamp Information (TIMESTAMP) = ON 2006-04-14
23.45.10.021050
Unit of Work Information (UOW) = ON 2006-04-14
23.45.10.021050
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Hitesh Bagchi" <nh******@gmail.com> a écrit dans le message de news:
11*********************@e56g2000cwe.googlegroups.c om...
When I run ..db2 get dbm cfg, I see the following:
Default database monitor switches
Buffer pool
(DFT_MON_BUFPOOL) = OFF
Lock
(DFT_MON_LOCK) = OFF
Sort
(DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT)
= OFF
Table
(DFT_MON_TABLE) = OFF
Timestamp
(DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW)
= OFF
Monitor health of instance and databases (HEALTH_MON) = OFF
It shows that DFT_MON_STMT is off. Yet when I run -> db2 get monitor
switches..it shows as on for the statement level. Any idea were I am
going wrong?