SQL1117N A connection to or activation

SQL1117N A connection to or activation of database “your database” cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019

The error message SQL1117N with SQLSTATE=57019 indicates that there is a roll-forward pending state in the database, preventing a connection or activation.

Roll-forward pending means that there are log files that need to be applied to bring the database to a consistent state. This situation often occurs after a database restore or an incomplete roll-forward operation.

$db2 get db cfg for | grep -i rollforward

db2 rollforward db to end of logs and stop

                        Or

db2 rollforward db to end of logs and complete