Restoring the database

If, during restructuring, a program abnormally terminates processing with "ABNORMAL END", one of the following steps must be taken, depending on the gravity of the error:

• re-execute the terminated program, or

• make use of the backup and repeat restructuring

The sections of this chapter dealing with the individual restructuring programs describe when it is necessary to reset the database and to repeat the restructuring process, and when it is sufficient to repeat the programs terminated abnormally.

The following table shows which programs modify which files or realms in the database during restructuring.

	H A S H L I B	D B D I R	D B C O M	D B C O M . O	C O S S D	C O S S D . O	User realms which have to be accessed
BCHANGE	-	RW	RW	W	R	W	-
DDL compiler	-	RW	RW	-	W	-	-
SSL compiler	-	RW	RW	-	W	-	-
BGSIA	-	RW	RW	-	-	-	-
LMS	W	-	-	-	-	-	-
BALTER (analysis phase)	-	R	R	R	-	-	-
BALTER (restructuring phase)	R	RW	R	R	-	-	RW
DDL compiler (subschemas)	-	RW	RW	-	W	R	-
BGSSIA	-	RW	R	-	-	-	-

Table 34: Access to files and realms of the database during restructuring

R	read access
W	write access
-	no access

The following options are available for restoring the database:

• You can convert the shadow database to an original database by renaming it with the die MODIFY-FILE-ATTRIBUTES command.

• You can read in the ARCHIVE backup and then change the database name, if desired, with the MODIFY-FILE-ATTRIBUTES command. If the ARCHIVE backup was created on-line, you may have to mend it with the BMEND utility routine (see "BMEND" in the "Recovery, Information and Reorganization" manual).

For further information on restoring a database, refer to the section "Saving and recovering a database in the event of errors" in the "Database Operation" manual.

Steps required in case of memory shortage

If one of the programs terminates with database status (DBSTATUS) 14802 or 14804, you must

• expand the affected realm or record type with BREORG,

• restart the program and if necessary delete any incompletely generated information with the DELETE parameter.