We are fairly new to DB2. We love the db2advis command, but would like to bounce it off queries captured by WLM. We aren't sure how to use it with the '-start-time' and '-end-time' option. Specifically, what date format do you give it. Such as yyyy-mm-dd HH:MM, or whatever.

The documentation we have found shows this, but it doesn't give specifics on how to format the date and time.

We are using DB2 v9.5 Fix Pack 3b running on Suse Linux 2.6.16.60-0.21-smp in a D5100 IBM Infosphere Balanced Warehouse.

-wlm--evmonname--+-----------------------------------------------------+--+--------------------------+-'
+-+-workloadname-+--workloadname----------------------+ '-start-time--+----------+-'
| '-wl-----------' | '-end-time-'
'-+-serviceclass-+--superclassname--+---------------+-'
'-sc-----------' '-,subclassname-'

Thanks for your help.