I can able to get statement text and cpu time of particular query from table function "SNAP_GET_DYN_SQL".
But i can't able to get who is running that particular statement and from which database.
So i used SNAP_GET_STMT table function which gives statment text with agent_id and database_name.
But the problem is always get statment text as null from SNAP_GET_STMT table function.
Anyone know the reason, why i am getting null value in statement text column. I am running this query on db2 v10
And if any alternate way to get cpu intensive query with username ( who is running this query )
Please help me on this.
Thanks and regards