The individual parameter SELECT

Function

You use this parameter to specify which data from the request log file is to be evaluated by SESCOSP.

The type of evaluation depends not only on the parameters specified for SELECT but also on whether statements or transactions are evaluated. You specify this by means of the REPORT-FORMAT parameter PROTOCOL (see "The REPORT-FORMAT parameter PROTOCOL"). For each SELECT parameter, the differences in the logging of statements and transactions are described below.

SELECT

= *ALL / *PARAMETERS(...)
	*PARAMETERS(...)
		|	CATALOG-NAMES =
		|	,USERS =
		|	,STATEMENTS =
		|	,TIME =
		|	,CPU-TIME=
		|	,ELAPSED-TIME =
		|	,NUMBER-OF-LOGICAL-IO=

Operands

SELECT = *ALL

SESCOSP evaluates all databases, all spaces, all tables and all statements and the report is not limited to specific users or specific time periods.

SELECT = *PARAMETERS(...)
The options that allow you to limit the data to be collected are described below individually as SELECT parameters.