Skip to Content
avatar image
Former Member

lock table size change in instance profile RZ10

i need your help. I changed the table size from 10000 to 17000 and then to 20000 but still have the same table size as before.i used rz10 to change the parameter enque/table_size.

the steps i followed are as in all documents i can find.

1. change parameter value

2. save it (parameter and instance)

3. activate it.

4.on restart instance (i just left it for the offline backup to do this).

on the 4th step is that enough, because after the system came back i checked the parameter in rz11 and the current value on the parameter is still 10000. (owner entries and granule still 12557 as before)

am i missing something?

vinaka

epeli

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 02, 2007 at 08:43 AM

    Hi,

    it COULD be that the offline backup did indeed no restart of the instance. From Oracle I know that there is a so called "reconnect-status" where the SAP instance is trying over a defined period of time to log to the database again after the workprocesses lost connection to the database processes. In this timeframe the instance is not to be considered as restarted.

    If you check ST02 you see the point of time where the instance was restarted in reality the last time. If this date is before your offline backup you need to do the restart manually.

    Best regards, Alexander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2007 at 04:16 AM

    Hi

    Where did u put this value ? Default profile or instance profile?

    Thanks

    Prince Jose

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      in the instance profile.

      The parameter is not on the default profile.

      i have even deleted the old parameter and recreated the parameter with the value 20000 and after following the 4 steps above still did not take effect.

  • avatar image
    Former Member
    Jul 04, 2007 at 12:48 PM

    Dear Epeli,

    You need to explicitly start and stop the system. Without which the parameeter will not be activated.

    Regards

    Amit

    Add comment
    10|10000 characters needed characters exceeded