Topic
  • 1 reply
  • Latest Post - ‏2012-12-13T07:04:49Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic Warning Mess when DB startup

‏2012-12-13T06:16:57Z |
Dear Team,

I am getting a waring message when i start up sap.
As i am new to DB2 i request you to provide a commands too how to execute.

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 LOGRETAIN value = NO.
How to change and this parameter to which value.
Suggest me what i want to do now....
Thanks,
Thamodaran.
Updated on 2012-12-13T07:04:49Z at 2012-12-13T07:04:49Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: Warning Mess when DB startup

    ‏2012-12-13T07:04:49Z  
    Hello,

    The preferred way to configure log archiving is setting up LOGARCHMETH1 :

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.config.doc/doc/r0011448.html

    Regards

    Yves-Antoine Emmanuelli