Switches DA-LOG files
Scope of validity
DBH administration
Function
You can use the CHANGE-DALOG statement when logging to close the DA-LOG files for the specified database or databases and open the next DA-LOG file.
If you specify databases that do not belong to the configuration or for which logging is not activated, the statement is rejected.
If you do not specify any databases, the DA-LOG files are changed in the order of the catalog list. If logging is not activated, the statement is ignored.
The CHANGE-DALOG statement is not permitted while a database is being processed by a utility statement, and it is rejected with an error message.
The CHANGE-DALOG statement is rejected with an error message in the following situations:
the specified database does not belong to the configuration
logging is not turned on for the specified database
READ access only is allowed for the specified database
the specified database is a SESAM backup copy or a replication
the specified database is closed or defective
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)
if 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)
if there is a resource bottleneck.
CHANGE-DALOG | ||||||||||||||||||||
| ||||||||||||||||||||
Operands
SELECT =
Specifies the databases for which the DA-LOG files are to be changed.
SELECT = *ALL
The DA-LOG files for all databases for which logging is activated are changed.
SELECT = *LOGICAL(...)
Selection of the database(s) whose DA-LOG file is 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 DA-LOG file is 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 DAW administration command corresponds to the CHANGE-DALOG administration statement here. The DAW administration command cannot be issued at the CALL DML interface and through the INFORM-PROGRAM interface.
DAW[,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.