Skip to Content
avatar image
Former Member

maxdb log mode

hello experts,

I need to change the log mode which is in "overwrite mode"

currently. and increase LOG_IO_QUEUE size.

how can i do it.

our maxdb version is 7.6 and O/S linux 2.6.16

plz suggest steps .

thanks and regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 13, 2008 at 08:30 AM

    Hi,

    probably the easiest way would be to:

    - install the Database Manager GUI and logon remotely

    - using the DBMGUI, goto 'Configuration' -> 'Log Settings' and select 'Overwrite Mode for the Log Area' and follow the steps mentioned by the Wizard. You need to create a data backup afterwards, as also specified by the Wizard.

    From a DBMCLI perspective, the relevant command would be: 'util_execute SET LOG AUTO OVERWRITE OFF', which ofcourse should also be followed by a data backup (to start the backuphistory again).

    Regards,

    Roland

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2008 at 10:30 PM

    Dear Kavitha,

    -> Please review the SAP notes::

    869267 FAQ: MaxDB LOG area

    < "35. Can the log area be overwritten cyclically without having to make a log backup?"

    &&

    "52. How large should the LOG_IO_QUEUE be when configured? " >

    719652 Setting initial parameters for liveCache 7.5 or 7.6

    819641 FAQ: MaxDB Performance

    If you are SAP customer, you are able to read the SAP notes.

    -> The MAXDB documentation also give you answers on the reported questions::

    http://maxdb.sap.com/documentation/ -> Open the SAP MaxDB 7.6 Library

    -> Glossary

    "Changing the Values of Database Parameters" at

    http://maxdb.sap.com/doc/7_6/9b/e6dc41765b6024e10000000a1550b0/content.htm

    "Log Queue"

    http://maxdb.sap.com/doc/7_6/23/c806c81e20f946a59a421e01c42c3b/content.htm

    < The new value of the LOG_IO_QUEUE parameter will be activated only after

    the database will be restarted from offline mode. >

    "Displaying and Changing Database Parameters" using DBMGUI tool at

    http://maxdb.sap.com/doc/7_6/84/d8d198570411d4aa82006094b92fad/content.htm

    -> Please pay attention ::

    "Automatic overwrite of the log area without log backups is NOT

    recommended for production operation. Since no backup history exists

    for the following changes in the database, you cannot track transactions

    in the case of recovery. "

    Run dbm command 'param_getexplain LOG_IO_QUEUE'.

    May be the log devspaces can be moved to a faster disk, to accelerate the physical log I/O.

    -> What is the version of the database? < Please also give the patch and build number >

    Why do you need to change the log mode which is in "overwrite mode"

    and increase the value of the database parameter LOG_IO_QUEUE?

    Thank you and best regards, Natalia Khlopina

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Kavitha,

      1) Are you SAP customer?

      If you are SAP customer, please review the SAP notes::

      972785 Information: Change to MaxDB version numbering

      767598 Available documentatio

      2) Q:"What is the version of the database? < Please also give the patch<Correction Level> and build number >"

      Format of the expected answer :: <Major Release>.<Minor Release>.<Correction Level>.<Build Number>

      for example:: 7.6.00.18

      For example, run 'xinstinfo <SID>' or 'dbmcli db_enum' command or check in the knldiag file the

      database version.

      3) Please let us know if you need additional information on the posted questions in this thread:

      "I need to change the log mode which is in "overwrite mode" currently. and increase LOG_IO_QUEUE size.

      how can i do it."

      Thank you and best regards, Natalia Khlopina