Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  db2diag filter

    Posted 09/22/20 02:21 PM
    we have  db2 luw 11.1 installed and use db2diag to ship mail when Error or Severe is present
    now we are also db2dart to check the db
    and this produces Error entries, as the database is online and being used
    is there also a filter for  PROC:
    in our case db2dart - and we do not want to get a mail on this condition as it is expected
    I could not find this in knowledge center

    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: db2diag filter

    Posted 09/23/20 02:15 AM
    hi Guy,

    can you give as an example db2diag.log entry that you want to be alerted and one you don't want?

    ------------------------------
    Markus Fraune
    ------------------------------



  • 3.  RE: db2diag filter

    Posted 09/23/20 04:10 AM
    Hi,

    not sure if I understood this correctly, but if you want to filter out db2diag entries where PROC=db2dart use this:

    db2diag -level error,severe -gv PROC:=db2dart

    ------------------------------
    Joachim Klassen
    ------------------------------