Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: way to turn mon switch for all..

    Isn't there anyway to turn monitor switches on for all application for a database.

    AFAIK, to do this one need to turn this at dbm level which needs restart of instance.


    TIA.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You do not need to restart the instance for the monitor switches change ... This is true for V8 and IIRC, V7 also

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    but "dbm cfg show detail" does not show

    Thanks Sathyaram..

    "dbm cfg show detail" does not show it changed untill we restart the instance.
    Are we missing something ?

    Actually we are looking to turn switches on at database level not just an application level so ended up changing it at DBM level, Is there anyway to do it at whole database level ?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I'm afraid, snapshot is an instance wide operation and therefore the parameter is at the index level ...
    What version of db2 are you on ?

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Nov 2003
    Posts
    121

    dbm monitor switches

    We are at udb 8.1 ..

    any clue ? or way to turn it on at database level without instance recycle ?

    TIA..

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    As I said earlier, you cannot turn it at a database level .. it can be done only at the instance level ...

    On 8.1 and above the monitor switches are definitely configurable online
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The monitor switches are set at the database manager level (instance), but you can request snapshots for a particular database.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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