Error "0xe0000340 - The Database script returned an error" is reported in the job log when performing a restore and rollforward operation of all of the tablespaces of a DB2 database.

Article:TECH53109  |  Created: 2007-01-14  |  Updated: 2012-03-30  |  Article URL http://www.symantec.com/docs/TECH53109
Article Type
Technical Solution

Product(s)

Environment

Issue



Error "0xe0000340 - The Database script returned an error" is reported in the job log when performing a restore and rollforward operation of all of the tablespaces of a DB2 database.

 


Error



Final error: 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details.

If all of the tablespaces of a DB2 database are backed up, and a restore and rollforward operation is attempted from this backup, the job may fail with the error above and below. (Fig. 1)
 
Figure 1
 
 
 

Cause



The system catalog tablespace "syscatspace" contains all of the system catalog information for the tables. Syscatspace needs to be rolled forward first, and then the other tablespaces must be rolled forward.


Solution



Workaround:
 
When the restore operation is run from a tablespace level backup, perform the rollforward for the syscatspace tablespace first and then for other tablespaces.
 
Execute the rollforward operation as a DBA operation. The sequence of the recovery process should be as follows:
 
1. Select all tablespaces, uncheck the rollforward option and run the restore job.
 
2. Run the rollforward operation as a DBA initiated operation:
 
rollforward syscatspace to point in time / end of logs. e.g. db2 => rollforward database UEXIT to end of logs and complete Tablespace (SYSCATSPACE) online
 
3. Perform rollforward of all other tablespaces.
 
e.g. db2 => rollforward database UEXIT to end of logs and complete tablespace (SYSTOO LSPACE,USERSPACE1) online
 
Refer to IBM DB2 documentation for more information on DBA-initiated operations.

Supplemental Materials

SourceETrack
Value863896
Description

DB2:Database recovery fails during restore and rollforward from backup of all tablespaces.


SourceError Code
Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details.


SourceUMI
ValueV-79-57344-832


Legacy ID



290596


Article URL http://www.symantec.com/docs/TECH53109


Terms of use for this information are found in Legal Notices