Autolog on SAPDB 7.2.4

[Former Member]

Hai,

i know that SAPDB is an old DB, but we can´t change it at the moment.

We have activate the autolog-function.

The Log is about 10 percent and i want to know, when the log will be save as file?

Can somebody help me?

[Former Member · Accepted solution]

Hello,

first of all you need to know the size of your log area (summ of log files sizes)

lets say you have 3 logfiles , each 1 GB (LOG001 LOG002 LOG003)

which means your log area is 3GB

one page = 8KB

then

3GB =~ 400 000 pages

so you need to set LOG_SEGMENT_SIZE to 40 000 to start autolog once log fill level reach 10%

[Former Member]

Hai,

thanks a lot.

I have seen, that in the configuration is a "value" an a "new value".

What is that?

Is the "value" -> the value of database?

"new value" -> the value of me?

And the database use "value" when "new value" is not filled?

would be nice, if somebody can help me.

[Melanie]

Hi Nils,

I assume you're talking about the database parameter display.

Most database parameters only take effect after a restart of the database.

So 'value' is the value currently used by the database. 'New value' is the changed value, which will take effect when the database was restarted.

Regards,

Melanie

[Former Member]

if you are SAP customer, you can read SAP note 869267 for more details

[Former Member]

Hai,

thank you!

How can i make it, that log-file writes at 5% or 10%.

Is this possible?

(Don´t know what "pages" means)

[Former Member]

Hello,

parameter log_segment_size (in pages) shout determine when the autolog will be triggered

if it is set to 0 , autolog will be triggered when log fill level reach 33%