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 NUMBER-OF-LOGICAL-IO

Function

You use this parameter to specify that SESCOSP is to evaluate only statements whose number of logical I/Os lies within a specified range.

The number of logical I/Os of a transaction is the sum of all the logical I/Os of the individual statements involved in the transaction.

NUMBER-OF-LOGICAL-IO

= *ALL /*INTERVAL(...)


*INTERVAL(...)



|

FROM = <integer 0..2147483647>



|

,TO = <integer 0..2147483647>

Operands

NUMBER-OF-LOGICAL-IO = *ALL

The evaluation is limited on the basis of the number of logical I/Os.

NUMBER-OF-LOGICAL-IO = *INTERVAL(..)
Only statements or transactions whose number of logical I/Os lie within the specified range are evaluated.

FROM = <integer 0..2147483647>
Minimum number of logical I/Os
Default: 0

TO = <integer 0..2147483647>
Maximum number of logical I/Os
Default: 2147483647