Db2 (On Premises and Cloud)

Expand all | Collapse all

How can I delete all messages in DMC Notification Center?

  • 1.  How can I delete all messages in DMC Notification Center?

    Posted Thu September 16, 2021 10:55 AM
    How can I delete all messages in DMC Notification Center?

    Bulk delete is only possible for 30 Messages in one go.

    How to get rid of thousands of messages when notifcation was defined tooo sensitive?

    Michael form Hamburg


    ------------------------------
    Michael Klemmer
    ------------------------------


  • 2.  RE: How can I delete all messages in DMC Notification Center?

    Posted 27 days ago
    Hi Michael,
    Did you tried to modify the content of the table SCHEMA.ALERT ?
    Etienne

    ------------------------------
    etienne salvadori
    ------------------------------



  • 3.  RE: How can I delete all messages in DMC Notification Center?

    Posted 27 days ago
    Oh yes, tried that once, in older Version of DMC 3.1. Ended up having to recreate the repo db to get rid of all the errors caused by the delete.
    Did you try this with 3.1.5.1?
    I see an "on delete cascade" in dependent table alert_properties, so it should work.

    Nevertheless this is sort of an open heart surgery ;-). DMC must have a way to do this via DMC.

    Regards
    Michael

    ------------------------------
    Michael Klemmer
    ------------------------------