Skip to Content
avatar image
Former Member

Autolog on SAPDB 7.2.4

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 22, 2008 at 10:28 AM

    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%

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 06:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 22, 2008 at 09:07 AM

    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%

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2008 at 10:07 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2008 at 10:29 AM

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

    Add comment
    10|10000 characters needed characters exceeded