Viewing the session or batch job associated with a top sql statement for DB2 in Foglight
How can the top SQL executions for a DB2 database instance along with the database sessions or batch job that ran the top SQL statements be seen in the Foglight DB2 agent.
For each running session, Foglight displays the statement they currently run but associating a Top SQL statement to the session or batch job which executed is currently only available in Performance Analysis for DB2.
Did this article solve an issue for you?
Leave a Comment
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.