The SELECT parameter CATALOG-NAMES

Function

You use this parameter to specify the databases to be evaluated. For each database, the report can be limited to individual schemata, tables and spaces.

A statement is logged when the specified database is accessed, or when selected schemata, tables or spaces are accessed.

A statement may also evaluated when a table is not accessed. An example of this is the end statement of a transaction.

A transaction is logged when at least one statement of the transaction accesses the specified database or selected schemata, tables or spaces.

Note that the selection of individual schemata, tables or spaces affects:

• what is output in the STEP-IO-STATISTICS and STEP-COMPLEXITY lists

• the statistical resource data in the output lines and the termination statistics, in particular the selected logged resource consumption and

• the checking of the conditions specified for the SELECT parameters CPU-TIME and NUMBER-OF-LOGICAL-IO.

CATALOG-NAMES

= *ALL / list-poss(10): <filename 1..18_without-all>(...)
	<filename 1..18_without-all>(...)
		|	SCHEMA-NAMES = *ALL / list-poss(10): <c-string 1..31>(...)
		|		<c-string 1..31> (...)
		|			|	TABLE-NAMES = *ALL / list-poss(10): <text 1..31> / <c-string 1..31>
		|	SPACE-NAMES = *ALL / list-poss(10):<filename 1..18 without-all>

Operands

CATALOG-NAMES = *ALL

All databases are to be evaluated. Specifying *ALL does not have the same effect as specifying all databases individually because internal tables are also evaluated.

CATALOG-NAMES = list-poss(10): <filename 1..18_without-all>(...)
You specify up to ten databases that are to be evaluated. The databases are identified by their physical database names (see the DBH start statement ADD-SQL-DATABASE-CATALOG-LIST on "ADD-SQL-DATABASE-CATALOG-LIST").

<filename 1..18_without-all>(...)

SCHEMA-NAMES = *ALL
All this database's schemas are to be evaluated.

SCHEMA-NAMES = list-poss(10): <c-string 1..31>(...)
You specify up to ten of this database's schemas that are to be evaluated.

<c-string 1..31> (...)

TABLE-NAMES = *ALL
All tables of this schema are to be evaluated.

TABLE-NAMES = list-poss(10): <text 1..31> / <c-string 1..31>
You specify up to ten of this schema's tables that are to be evaluated.

SPACE-NAMES = *ALL
All this database's spaces are to be evaluated.

SPACE-NAMES = list-poss(10): <filename 1..18 without-all>
You specify up to ten of this database's spaces that are to be evaluated.

Example

The following input file for SESCOSP creates a report relating only to the data of the HEI database and the DC_SCHEMA schema.

//  CREATE-REPORT -
//      INPUT-FILE      = CO-LOG.70EX.0002, -
//      OUTPUT          = *SYSLST, -
//      SELECT          = *PARAMETERS ( -
//          CATALOG-NAMES   = HEI ( -
//              SCHEMA-NAMES    = 'DC_SCHEMA' ( -
//                  TABLE-NAMES     = *ALL ), -
//              SPACE-NAMES     = *ALL ), -
//          USERS           = *ALL, -
//          STATEMENTS      = *ALL, -
//          TIME            = *ALL, -
//          CPU-TIME        = *ALL, -
//          ELAPSED-TIME    = *ALL, -
//          NUMBER-OF-LOGICAL-IO = *ALL ),-
//      REPORT-FORMAT   = *STD