This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
All MainView products
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.
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
In your example, you would want to filter on > 96 * 3600 * 100 = > 34560000.