With db2 restore restore the 2019-09-24 10 points on the day of the backup, including 10 PM to 1 PM were conducted between three transaction commit is 11 points at 12 and 13 points respectively (opened the archive, use log rolling forward)
After a study found that:
1, I roll reduction to 12 points, then reducing roll forward to 11 a.m., success
2, I have rolled to the 12 o 'clock, and then get 13 points, before reduction failure

With full amount of backup to restore the first rolled to a particular point in time after operation, reducing roll forward again can only get to this point in time before a particular point in time, and after a certain point in time, an

Bosses novice db2, do not understand why,

Personal idea and question: since opened the archive, specifies the directory in which the overflow should find log all time points, before also can roll point in time, what is limiting the time points before rolling, or database system mechanism,

CodePudding user response:

Use the backup at 10, the first roll forward db2 rollforward db dbname to end of logs and complete can roll to the latest time 1 PM to commit the transaction,