For some reason which I'm missing, I'm having problems turning off the timestamp database manager monitor:

$ db2 get dbm monitor switches

DBM System Monitor Information Collected

Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 12-26-2003 10:59:26.780480
Unit of Work Information (UOW) = OFF

$ db2 update dbm cfg using dft_mon_timestamp off
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed
successfully.

$ db2 get dbm monitor switches

DBM System Monitor Information Collected

Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 12-26-2003 10:59:26.780480
Unit of Work Information (UOW) = OFF

I'm sure it's something which I've missed or overlooked, but why can't I turn the timestamp monitor off?

DB2 v8.1 fixpack 3 on Solaris 2.8

Thanks

Ken

Did you restart the instance?

No I haven't. Do I need to restart the instance? I was able to
disable some of the other switches and the changes seemed
to take affect.

But I could be wrong.

Thanks

I don't know if you need a restart the instance for teh Timestamp switch to effect. You are correct that most of the other monitor switches can be changed on the fly. But if the Timestamp switch does not respond on the fly, it may be worth a try to restart the instance.

If you use the SHOW DETAIL command on get database configuration, then it will show any delayed values deferred until restart.

timestamp database manager monitor:
is one of the parms that you must recycle the db to change it.