F02 DB2 SQL Activity Timeline
The SQLActivityTimeline tag pair and sub-elements are repeated for each SQL call.
| Field title in online report | XML element |
|---|---|
| <SQLActivityTimeline> | |
| Thread | <Thread>n</Thread> |
| REQCT | <REQCT>n</REQCT> |
| Program | <Program>name</Program> |
| Stmt# | <StatementNumber>n</StatementNumber> |
| SQL Function | <SQLFunction>function</SQLFunction> |
| Samps | <Samples>n</Samples> |
| Call Time | <CallTime>hh:mm:ss.ss</CallTime> |
| Interval | <Interval>n</Interval> |
| CPU Time | <CPUTime>n</CPUTime> |
| <GetPagesIdx>n</GetPagesIdx> | |
| <GetPages>n</GetPages> | |
| <SyncReadIO>n</SyncReadIO> | |
| <PrefetchReq>n</PrefetchReq> | |
| <SyncWriteIO>n</SyncWriteIO> | |
| <SQLTextLines> | |
| <SQLTEXT>sqltext</SQLTEXT> | |
| <PrepareInfo> | |
| <PrepareStatementNumber>n</PrepareStatementNumber> | |
| <PrepareSequenceNumber>seqno</PrepareSequenceNumber> | |
| </PrepareInfo> | |
| </SQLTextLines> | |
| </SQLActivityTimeline> |