maxdb log mode

[Former Member]

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

[former_member229109]

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

[Former Member]

hi,

our maxdb version is 7.6

[former_member229109]

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

[roland_mallmann]

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