When restoring a database in DB2 you need to specify the rollforward. I have created a new database using:
db2 RESTORE DATABASE dbname USER adminuser USING 'adminpassword' FROM 'C:\databases' TAKEN AT 20161231131530 INTO newdbnew without prompting
This works correctly, but leaves the newly created db in rollforward pending state.
DB20000I The RESTORE DATABASE command completed successfully.
When trying to rollforward to a specified point in time (December 31 2016) I get an error that I should roll forward to a point in time after 08 march 2017 because I have logs up untill that day.
How do I restore and use an older db (even with another name) and keeping the new db?