on 05-04-2012 10:18 AM
Hi,
We have a customer DB2 for i5/OS and we need the lastest data in ST04 to find the most expensive SQL's statement, but the data are always the same.
How can I update or refresh them?. I new in DB2.
Best Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Luis,
this is controlled by the profile parameter as4/dbmon/enable ... when this one is turned off, it will never update any more.
Regards
Volker Gueldenpfennig
Thanks Volker. I have checked this parameter in the system and it has the value 1 (dbmon will be automatically started for all work processes), so I believe the parameter is turned on. Am I in the correct way?.
If the parameter is Ok, what can be the problem?
what do you see in ST04 in the Goto->"database monitor activity" ?
Hi Volker,
I can't see anything
Regards.
... then I woudl open an OSS ticket with BC-DB-DB4 ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.