Time Stamp fields

The command format is:
SELECT(PERFORMANCE|EXCEPTION|LOGGER(
       INCLUDE|EXCLUDE(
       START|STOP|ACTIVE(FROM(date,time),TO(date,time)),...),...))

Three time stamp fields can be specified with the SELECT(PERFORMANCE and SELECT(EXCEPTION operands:

START
Refers to when the transaction was attached or when processing continued from a conversational transaction.
STOP
Refers to when the transaction was detached or a conversational transaction waited for terminal input.
ACTIVE
Refers to the entire time span between the Start and Stop times. ACTIVE can be used to make sure long-running transactions are included when their Start or Stop times fall out of the selection range.

Only the STOP time stamp field can be specified with the SELECT(LOGGER operand.

FROM and TO together specify the report interval, and represent either a date/time range or a time slot (times only). The operands are positional, with FROM preceding TO. Up to 14 report intervals can be specified.

The date is either a calendar date in the format yyyy/mm/dd or a relative date. Relative dates are specified as 0, -1, -2,... to signify a date relative to the current date. 0 represents today, -1 yesterday, -2 two days ago, and so on. If both FROM and TO dates are specified, they must be in the same format.

The time is a time-of-day in the format hh:mm:ss.th.

For a date/time range:

For a time slot, both times must be specified with no dates to signify the same time slot every day. The times can span midnight.

For example, the following command includes performance records for transactions running between 8:00 in the morning and 6:00 in the evening:
SELECT(PERFORMANCE(INCLUDE(ACTIVE(FROM(08:00),TO(18:00)))))
To specify both date and time, the format is:
To specify a date only, the format is:
Note: The comma following the date is required to designate the missing time value.

To specify a time only, the format is FROM(,hh:mm:ss.th) or FROM(hh:mm:ss.th). The comma preceding the time is optional.

For further information on specifying date and time values, see Operand value formats.


Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/cpaug200.htm