Question & Answer
Question
APM Db2 monitoring agent widget "Slow SQL Statements - Top 5" contains "Duration" column, which displays data in the format n:n:nn:nnn, where n is an integer.
What does this value represent? For example, is it minutes or seconds?
Answer
The "Duration" column is being presented by the agent in the following format:
HH:MIN:SEC:MSEC, i.e. hours:minutes:seconds:milliseconds
Additional details about the "Duration" attribute:
The agent derives 'Duration' attribute (of "DB2 Slow SQL Stmts" data set ) from the STMT_EXEC_TIME column returned by Db2 table function MON_GET_PKG_CACHE_STMT.
As per Db2 documentation, the value returned by the table function is in milliseconds:
STMT_EXEC_TIME - The total time spent executing this statement by all agents on this member. The value is given in milliseconds.
APM Db2 Monitoring agent converts this value from milliseconds to HH:MIN:SEC:MSEC format to provide the "Duration" attribute.
Related Information
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSVJUL","label":"IBM Application Performance Management"},"ARM Category":[{"code":"a8m500000008b0AAAQ","label":"DB2 Agent"}],"ARM Case Number":"TS003839341","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
27 July 2021
UID
ibm16235822