MVSFORUMS.com

manu · Beginner Joined: 26 Dec 2002 Posts: 47 Topics: 19

I have a SQL query and wants to determine the approximate run times of the query. Can I do it using QMF or SPUFI or any other tools. Please let me know your suggestions.

kolusu · Posted: Fri Dec 15, 2017 11:15 am Post subject:

manu,

You need to have auditing turned to able to see the stats or if your shop has "DB2 Query Monitor" product, then you can simply look at the EXEC COUNT column which stores the number of times a the SQL statement has executed

https://www.ibm.com/support/knowledgecenter/en/SSAURY_3.2.0/topics/cqmucon_opsumcols.html
_________________
Kolusu
www.linkedin.com/in/kolusu

NASCAR9 · Posted: Fri Dec 15, 2017 12:02 pm Post subject:

In the past Auditing was very expensive for CPU in our shop.
This is a little rough, but it will get the job done.

If the time does not have to be 100% perfect you could do something like this:

kolusu · Posted: Fri Dec 15, 2017 12:26 pm Post subject:

NASCAR9,

I think OP wanted to check if a particular Query is run by ANY user from anywhere (TSO, BATCH, SPUFI, QMF, Program....)
_________________
Kolusu
www.linkedin.com/in/kolusu

manu · Beginner Joined: 26 Dec 2002 Posts: 47 Topics: 19

Kolusu and NASCAR9

Thanks for you inputs on this. I will review and get back if needed. Thanks.