Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    10

    Unanswered: Unable to turn off timestamp monitor

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you restart the instance?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    May 2003
    Posts
    10
    Originally posted by Marcus_A
    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you use the SHOW DETAIL command on get database configuration, then it will show any delayed values deferred until restart.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Unable to turn off timestamp monitor

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •