lock table size change in instance profile RZ10

[Former Member]

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

[alexander_maetzing · Accepted solution]

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

[Former Member]

Dear Epeli,

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

Regards

Amit

[Former Member]

Hi

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

Thanks

Prince Jose

[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.