Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

The SELECT parameter CPU-TIME

Function

You use this parameter to specify that SESCOSP is to evaluate only statements or transactions whose CPU time is within a specific period. You cannot select a CPU time period unless the CPU time was recorded during logging (see the SET-TUNING-TRACE administration statement on "SET-TUNING-TRACE").

The CPU time of a transaction is obtained by adding up all the CPU times of the statements involved in the transaction.

CPU-TIME

= *ALL / *INTERVAL(...)


*INTERVAL(...)



|

FROM = <integer 0..2147483647>



|

,TO = <integer 1..2147483647>

Operands

CPU-TIME = *ALL

The data to be evaluated is not limited to that logged during a specific CPU-time period.

CPU-TIME = *INTERVAL(...)
Statements and transactions are logged whose consumed CPU time lies between the CPU time start value (FROM) and the CPU time end value (TO). The time specified for FROM must be before or the same as that specified for TO.

FROM = <integer 0..2147483647>
CPU start time, to be entered in milliseconds or microseconds, depending on the setting of the TIME-PRECISION parameter.
Default: 0

TO = <integer 1..2147483647>
CPU end time, to be entered in milliseconds or microseconds, depending on the setting of the TIME-PRECISION parameter.
Default: 2147483647