FDREPORT OPTIMIZE Statement

OPTIMIZE statement

The OPTIMIZE statement currently permits the inclusion of a list of catalogs that are not to be processed by FDREPORT catalog read service. One or more OPTIMIZE statements are used to define the names of the catalogs to be bypassed during FDREPORT execution when the DATATYPE= is CATALOG, CATARCH, or CATVTOC.

OPTIMIZE statement syntax

OPTIMIZE



CATEXCLUDE=(catn[,catn,…])


,RESET|NORESET

If the OPTIMIZE command is not specified, all catalogs encountered when reading the Master Catalog are added to the catalog table for processing.

Important

Do NOT include the master catalog in the list of catalogs not to be processed. If the master catalog is encountered in the list it results in message:

FDR687** CATALOG SCAN USING FDR$CATP NOT PROCESSED – UNABLE TO CREATE ALIAS
AND CATALOG TABLES

followed by:

FDR484** INTERNAL LOGIC ERROR – JOB TERMINATED.

OPTIMIZE statement operands

CATEXCLUDE=

Specifies a name of a catalog to be added to a list of catalogs that are not to be processed by the catalog read service.

RESET

Indicates that the catalogs specified replace the current list of catalogs that are not to be processed and NOT just added to the list.

NORESET

Indicates that the catalogs specified are to be added to the current list of catalogs that are not to be processed and NOT replace the list.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*