When ever I set the value of Logretain=recovery while configuring configuration parameters and giving restart to DB.

The database become unavailable and give the following error on connect.

[IBM][CLI Driver] SQL1116N A connection to or activation of
database "MOITSQL1" cannot be made because of BACKUP PENDING.
SQLSTATE=57019.



Thanks in advance.

After you set the logretain=recovery, you need to do an offline backup of the database. I believe that this is so that the database starts at a consistant state for the logretain=recovery to work properly. This setting will allow you to do online backups, but that needs a consistant starting point. The offline backup gives you tha.

HTH

Andy

Yeah after taking the backup things went proper.

Thanks for your response.

Istikhar