Problem
执行rollforward前滚操作时报错。
SQL4970N Rollforward recovery stopped on the database named “TEMPLEDB” because the rollforward utility cannot reach the specified stop point (end-of-log or point-in-time) on the following database partitions: “0”.
Resolving The Problem
查看时间标记：
db2 list history backup all for db TEMPLEDB可以看到每次备份的Start Time和End Time
前滚操作：
db2 “rollforward db TEMPLEDB to [End Time或end of logs] using local time and stop overflow log path (/db2_backup/db2inst1/TEMPLEDB)”
补充备份语句和恢复语句：
db2 backup db TEMPLEDB online to /tmp/backup include logs
db2ckbkp –h XXXXXXXX（查询该备份文件）
db2 resotre database TEMPLEDB from /tmp/backup taken at 20180823192011 logtarget /db2log/db2inst1/TEMPLEDB without prompting
Analysis
End Time为备份的结束时间，同时它也是前滚的最小恢复时间点（PIT）。也就是说，如果按照指定时间点恢复，最小要恢复到这个时间点，如果用提前于这个时间的时间来前滚，将会报错。
