Have restored DB2 full backup successfully, then tried restoring the incremental backup and it gave the following error
SQL1119N A connection to or activation of database "DEV" cannot be made because a previous restore is incomplete. SQLSTATE=57019
The procedure for restoring incremental backup for DB2 is outlined in the User Guide
Restoring from Incremental Backup
Here is an example for reference. In this case, there is only one incremental backup. Also there was no user requirement to restore archived logs, so rollforward archived logs was not selected for the final step.
1. Restore the last incremental backup. Plugin options used during restore.
2. Restore the most recent full backup. Plugin options used for the full restore.
3. Restore the other incremental (in this case, there is none since there is only 1 incremental) to the last incremental backup. Plugin options used for the incremental restore.
In a scenario where there are more than 1 incremental backup. The procedure remains the same; INCR2 (latest) --> FULL --> INCR1 --> INCR2 (latest, a second time)
