Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012

    Unanswered: Warning Mess when DB startup

    Dear Team,

    I am new to DB2 .We are using DB2 9.7 for SAP. when starting up DB we are facing a warning message like

    Database activated

    *** WARNING Logretain mode is disabled

    You will be unable to fully recover your database in case

    of a media failure

    Starting Startup Agent sapstartsrv.

    I checked the LOGRETAIN value = NO.

    Can you please help me how to change this parameter and what value i should maintain to get the archieve logs.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    and you are maintaining this system/databases ??
    please try to read the doc and try to understand what is going on
    study some basic material about db2 and logging ..
    Archive logging
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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