Ember’s Take on Monitoring DB2 LUW

You may also like...

2 Responses

  1. Nadir Doctor says:

    Monitor + alert hardware-related issues like disk errors, path failures without auto-recovery in a reasonable amount of time

  2. Roberto Mandolini says:

    We use a simple script for base monitoring (moving to IBM netcool tool)
    sample report
    ##############################################################################
    DB2 status report for date : 2017-04-11-00:00:01 on usdb2pl806_dbgcp01

    ##############################################################################

    # REPORT DATABASE GCUDBP01

    SERVER: usdb2pl806
    INSTANCE: usdb2pl806_dbgcp01
    DATABASE: GCUDBP01
    DB_STATUS: Active
    LAST_BACKUP: 2017-04-10-02.24.11.000000
    LAST_ARCHIVE_STATUS: Success
    DB_CONNECT_STATUS: OK
    HADR_STATUS: PEER
    HADR_CONNECT_STATUS: CONNECTED
    HADR_ROLE: PRIMARY
    APP_CONNECT: 17

    # REPORT FILESYSTEM PER DB GCUDBP01

    /dev/mapper/myvg-gcudbp01_LOG0lv /gcudbp01_LOG0 Normal
    /dev/mapper/myvg-gcudbp01_ARCHlv /gcudbp01_ARCH Normal
    /dev/mapper/myvg-gcudbp01_BKUPlv /gcudbp01_BKUP Normal
    /dev/mapper/myvg-gcudbp01_CAT0lv /gcudbp01_CAT0 Normal
    /dev/mapper/myvg-gcudbp01_DAT0lv /gcudbp01_DAT0 Normal

    Proactive monitoring should be done also with this new tool/script relased by IBM
    http://www-01.ibm.com/support/docview.wss?uid=swg21993956

    from ibm web page:
    The db2mon script is a created on top of the SQL monitoring interfaces provided by DB2 LUW
    It monitors database activity for a set amount of time ( default = 30 seconds ) and provides various metrics in a detailed report section as the output.

Leave a Reply

Your email address will not be published. Required fields are marked *