How to set a filter on an elapsed time field on a MainView view?

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    MainView Infrastructure


    APPLIES TO:

    All MainView products



    QUESTION:

    How do I set a filter on an elapsed time field on a MainView view?

    I’m trying to customise the DB2 Threads view THDACTV, for example, but I can't figure out how to filter on "elapsed time greater than xxx". It either shows nothing or still shows every row.

    THDACTV filter 1

    THDACTV filter 2



     


    ANSWER:

    For ANY elapsed time column, you need to filter in units of hundredths of seconds.

    In the JCPU example below, 37440000 is 104 * 3600 * 100

    JCPU successful filter

    In your example, you would want to filter on > 96 * 3600 * 100 = > 34560000.
     


    Article Number:

    000106443


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles