Application Performance Analyzer for z/OS, Version 11.1, User's Guide

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>



Rate this page

[ Top of Page | Previous Page | Next Page | Contents | Index ]