Real Time Information Director User Documentation

RTID Management
Hewlett-Packard Company 10 529618 - 001
accumulation. Thus, if you request statistics gathering for ORDERS05 documents, global
statistics will exclude statistical data for ORDERS05.
Global statistics for documents that were processed successfully are accumulated
separately from those for documents that failed. For a report of global, document class,
and failure statistics combined, use the –sx option to harvest statistics to a file.
Some statistics gathering options (those ending with s) specify collection of summary
statistics. Summary statistics reflect the SQL operations for specific documents but make
no reference to which operations affected which tables. If you want more detailed
statistics, you can use one of the options ending in t to specify statistics gathering by
table, or one ending with o to trace the operations history, the sequence of operations
performed by the Director to process a specific document.
The –st and –su options determine whether individual SQL operations (SELECT,
UPDATE, INSERT, and DELETE) are timed. If you specify the –st option, the statistics
or counter related to an operation will reflect the number of milliseconds between the
completion of that operation and the completion of the previous timed operation. Certain
operations, such as parsing or the allocation of document handlers, are timed, regardless
of which –s option you choose.
U
U
s
s
i
i
n
n
g
g
D
D
i
i
r
r
e
e
c
c
t
t
o
o
r
r
S
S
t
t
a
a
t
t
i
i
s
s
t
t
i
i
c
c
s
s
Whether you display statistics, using the –statistics option, or harvest them to a file, using
the –sx option, statistics are provided in XML format. The name of an XML segment
that contains statistics is (unsurprisingly) STATISTICS.
In the following example, the first STATISTICS segment contains summary statistics.
The subsequent three segments contain detailed statistics. Explanations of individual tags
and attributes follow the example.
<STATISTICS>
<PARSE BYTES="3451" />
<HANDLERS ALLOCATED="1" PREPARED="1" MAXIMUM="1"
MAXIMUM_BY_CLASS="1" MAXIMUM_INUSE="1" />
<SELECT STATEMENTS="26" ROWS="0" />
<INSERT STATEMENTS="34" ROWS="34" />
<SERIALIZE BYTES="345" />
</STATISTICS>
<STATISTICS TABLE="ITEM">
<INSERT STATEMENTS="25" ROWS="25" />
</STATISTICS>
<STATISTICS TABLE="BRANCH">
<SELECT STATEMENTS="1" ROWS="0" />
<INSERT STATEMENTS="1" ROWS="1" />
</STATISTICS>