Two Worlds of DB2 LUW Performance Monitoring

You may also like...

4 Responses

  1. Gianfranco Casati says:

    Good morning Mrs. Crooks,
    let me add my personal experiences with “new” monitoring settings, used with DB2LUW v9.7, 10.1 and 10.5 FixPax 7

    My usual settings are:

    for DBM:

    db2 get dbm cfg | grep -i mon

    Transaction processor monitor name (TP_MON_NAME) =
    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = ON
    Lock (DFT_MON_LOCK) = ON
    Sort (DFT_MON_SORT) = ON
    Statement (DFT_MON_STMT) = ON
    Table (DFT_MON_TABLE) = ON
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = ON
    Monitor health of instance and databases (HEALTH_MON) = OFF
    SYSMON group name (SYSMON_GROUP) = DB2MON
    Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90)

    for DB:

    db2 get db cfg | grep -i mon

    Monitor Collect Settings
    Request metrics (MON_REQ_METRICS) = EXTENDED
    Activity metrics (MON_ACT_METRICS) = EXTENDED
    Object metrics (MON_OBJ_METRICS) = EXTENDED
    Routine data (MON_RTN_DATA) = BASE
    Routine executable list (MON_RTN_EXECLIST) = ON
    Unit of work events (MON_UOW_DATA) = BASE
    UOW events with package list (MON_UOW_PKGLIST) = ON
    UOW events with executable list (MON_UOW_EXECLIST) = ON
    Lock timeout events (MON_LOCKTIMEOUT) = HIST_AND_VALUES
    Deadlock events (MON_DEADLOCK) = HIST_AND_VALUES
    Lock wait events (MON_LOCKWAIT) = HIST_AND_VALUES
    Lock wait event threshold (MON_LW_THRESH) = 5000000
    Number of package list entries (MON_PKGLIST_SZ) = 64
    Lock event notification level (MON_LCK_MSG_LVL) = 3

    IMPORTANT NOTE !!

    Always set (HEALTH_MON) = OFF >>> due to high overhead, usually more than 15% CPU utilization

    And, remove from your mind the old “Get Snapshot” not easy to use

    – – – – – –
    Cordiali Saluti, Best Regards

    Gianfranco Casati
    Certified Senior IBM System Engineer
    for zOS, DB2/zOS, Vtam, TCPIP, RACF, CICS, MQ, TWS, DB2LUW, Linux

    IT Security is a Smart Investment
    – – – – – –
    The human mind is our fundamental resource.
    John Fitzgerald Kennedy
    USA President

  1. July 29, 2013

    […] Ember Crooks’ db2commerce.com Blog post onThe Two Worlds of DB2 LUW Performance Monitoring […]

  2. January 19, 2016

    […] blogged about MON_GET goodies before – including these posts: Two Worlds of DB2 LUW Performance Monitoring My New Best Friend – mon_ Part 1: Table Functions My New Best Friend – mon_ Part 2: Views But […]

  3. January 19, 2016

    […] blogged about MON_GET goodies before – including these posts: Two Worlds of DB2 LUW Performance Monitoring My New Best Friend – mon_ Part 1: Table Functions My New Best Friend – mon_ Part 2: Views But […]

Leave a Reply

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