Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    19

    Arrow Unanswered: DB2 Configuration parameters (Logretain=recovery)

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Sep 2006
    Posts
    19
    Yeah after taking the backup things went proper.

    Thanks for your response.

    Istikhar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •