In HA setup for SAP ABAP, will failover of central services happen when lock table overflow occurs

[Former Member]

Hello,

In HA setup for SAP ABAP -

Node 1 - DB

Node 2 - ASCS (ms and en services) and SAP ABAP instance

Node 3 - ERS are running.

I have a doubt if failover of central services happen when lock table overflow occurs?

Thanks,

Subbu

[Former Member]

Not sure what you are asking about ...

Imho, no matter what the environment is:

1) A lock table overflow should not, and will not, trigger a failover of the ASCS instance.

2) If a failover is needed for whatever reason, then a lock table overflow should not, and will not, prevent it from happening. (Never tested this myself though.)

hope this helps

[Former Member]

Thank you.

I understand Lock table overflow should not happen in any environment.

However, we have a situation that few users unintentionally give some input data which causes this situation.

So, thinking if there is any way to trigger a enqueue failover when Lock table overflow occurs (Which makes sense for me :-))

Thanks,

Subbu

[Sriram2009]

Hi Subbu

Could you refer the SCN link about the HA FAQ it is having clear information

• What is an "Enqueue Replication Server"?

BR

SS

[Former Member]

Well, imho forcing a failover whenever lock table is full doesn't make much sense.

It may be a remedy for the symptoms, but it is not a cure for the root cause.

And I'm afraid side effects may be more annoying than the problem itself...

I would rather step up my efforts to find out how to prevent a lock table overflow.

But it's your choice of course.

[Former Member]

subbu panguluri wrote:

So, thinking if there is any way to trigger a enqueue failover when Lock table overflow occurs (Which makes sense for me :-))

Thanks,
Subbu

It does not make sense at all because the main reason for ASCS HA installation is to preserve enqueue service availability and to preserve enqueue table entries during failover operation. In other words after failover enqueue table entries must be the same on failover node as on primary.

[Sriram2009]

Hi Subbu

Is it Windows failover cluster environment?

BR

SS

[Former Member]

Hello SS,

Sorry, didn't mention the environment:

All our services are installed on LINUX.

We are meeting all pre-requisites and we are using VCS.

My only doubt is - Will failover of central services happen when lock table overflow issue occurs?

Thanks,

Subbu