When performing restore of DB2 database to a point-in-time before the most recent backup set, the rollforward command would fail

Article:TECH60992  |  Created: 2009-01-22  |  Updated: 2011-12-29  |  Article URL http://www.symantec.com/docs/TECH60992
Article Type
Technical Solution

Product(s)

Environment

Issue



When performing restore of DB2 database to a point-in-time before the most recent backup set, the rollforward command would fail


Error



SQL1275N The stoptime passed to roll-forward must be greater than or equal to "", because database "" on node(s) "0" contains information later than the specified time.


Solution



When performing restore of DB2 database to a point-in-time before the most recent backup set (Fig1 and Fig2), the rollforward command would fail and the SQL1275N was reported in DB2 Output section in the job log.

Fig. 1
 

Fig. 2
 

Permanent resolution:
This issue has been permanently resolved in Backup Exec 12.0 for Windows Servers.

Workaround:
To work around this issue, follow these steps:

1. make sure of  DB2 service account (Fig3)

Fig. 3
 

2. open property of the restore job, then create and select a logon account which is the same user name with the DB2 service account (Fig4)

Fig. 4
 



 

Supplemental Materials

SourceETrack
Value1261742
Description

DB2: Unable to recover database to a point-in-time before the most recent differential/incremental backup set


SourceError Code
Value0xe0000340
Description

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


SourceError Code
ValueSQL1275N
Description

The stoptime passed to roll-forward must be greater than or equal to "", because database "" on node(s) "0" contains information later than the specified time



Legacy ID



304842


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


Terms of use for this information are found in Legal Notices