CHANGE-CATLOG

This statement changes the CAT-LOG file and the DA-LOG files and creates a copy of the CAT-REC file.

Scope of validity

DBH administration

Function

You can use the CHANGE-CATLOG statement to close the CAT- LOG file and the DA-LOG files for the specified database or databases and open the next one, and to create a copy of the CAT-REC file.

The copy of the CAT-REC file is created in the media of the CAT-LOG file. It cannot be created on tape.

If the database – and hence also the CAT-REC file – is located in a DB user ID, a file is created with the name catalog-name.CAT-REC.COPY. For more information about “Database files and job variables on foreign user IDs“ see the section of the same name in the “ Core manual”. If the file cannot be created on the DB user ID it is created on the DBH user ID.

The CHANGE-CATLOG statement is rejected with an error message in the following situations:

• the specified database does not belong to the configuration

• the specified database is being run without LD backup

• READ access only is allowed for the specified database

• the specified database is in the “copy pending” state

• the specified database cannot be locked during processing (due to parallel utility, DDL or administration statements)

• the specified database is a SESAM backup copy or a replication

• SELECT = *ALL is specified and one of the databases cannot be locked during processing (due to parallel utility, DDL or administration statements). The name of the database where the error occurred is announced; the action was executed for all databases with LD backup that are before this database in the ordered list of DBC entries (corresponding to the output for SHOW-SQL-DB-CATALOG-ENTRIES)

• the specified database is closed or defective

• there is a resource bottleneck.

If you do not specify any databases, the CAT-LOG file and the DA-LOG files are switched in the order given in the database directory and the action is performed for all databases with an LD backup. For databases for which logging is not activated, the statement is ignored.

CHANGE-CATLOG

SELECT = *ALL / *LOGICAL(...) / *PHYSICAL(...)
	*LOGICAL(...)
		|	CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
	*PHYSICAL(...)
		|	PHYS-CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>

Operands

SELECT =

Specifies the databases for which the CAT-LOG file and DA-LOG files are to be changed.

SELECT = *ALL
The CAT-LOG file and DA-LOG files of all the databases for which logging is activated are changed.

SELECT = *LOGICAL(...)
Selection of the database(s) whose CAT-LOG and DA-LOG files are to be changed

CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Logical name of the database

SELECT = *PHYSICAL(...)
Selection of the database(s) whose CAT-LOG and DA-LOG files are to be changed

PHYS-CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Physical name of the database

Administration command at the CALL DML interface

The CAW administration command corresponds to the CHANGE-CATLOG administration statement here. The CAW administration statement can be issued at the CALL DML interface or through the INFORM-PROGRAM interface.

CAW[,name]

name ::= {C[ATALOG]=catalog-name|P[HYSICAL-NAME]=physical-name}

You can specify the logical name of the database in catalog-name using up to 18 characters.

You can specify the physical name of the database in physical-name using up to 18 characters.