SAP Knowledge Base Article - Preview

2935054 - ENSA 2.0: Cannot change MAX_LOCKS value in "enq/server/schema" parameter from SMENQ

Symptom

Changing the value of MAX_LOCKS subparameter in the parameter enq/server/schema from SMENQ does not work.

Case 1.

==> Increase enq/server/schema above 2000000 (with kernel versions lower than the note 2942857)

dev_enq_server (from ASCS work folder or from SMENQ ==> Sever Administration ==> Diagnosis ==> Developer Trace)

|79 |[2020-06-08-18:38:07,234] [Thr 140549917718272] *** WARNING => EnqServer: invalid size (250000 => 3000000) [EnqEnqueueSe 1430] |
|80 |[2020-06-08-18:38:07,234] [Thr 140549917718272] *** ERROR => EnqServer: failed to set parameter 'enq/server/schema' by client/user '<client>/<user>' [EnqEnqueueSe 1461] |
|81 |[2020-06-08-18:38:36,453] [Thr 140549912962816] *** WARNING => EnqServer: invalid size (250000 => 2000001) [EnqEnqueueSe 1430] |
|82 |[2020-06-08-18:38:36,453] [Thr 140549912962816] *** ERROR => EnqServer: failed to set parameter 'enq/server/schema' by client/user '<client>/<user>' [EnqEnqueueSe 1461] |
|83 |[2020-06-08-18:38:51,652] [Thr 140549913491200] EnqLockTable: resize to 2000000 entries is prepared |
|84 |[2020-06-08-18:38:52,581] [Thr 140549913491200] EnqLockTable: resize to 2000000 entries is completed (0 errors) |
|85 |[2020-06-08-18:38:52,581] [Thr 140549913491200] ***LOG GOC=> SystemLog, ParameterChanged (enq/server/schema&NAME=<SID>,MAX_LOCKS=2000000,SESSION_QUOTA=100 |
|86 |&200&Y000063&) [EnqSystemLog 89] |
|87 |[2020-06-08-18:38:52,581] [Thr 140549913491200] EnqServer: client/user '<client>/<user>' changed parameter 'enq/server/schema' to 'NAME=<SID>,MAX_LOCKS=2000000,SESSION_QUOTA=100|
|88 |[2020-06-08-18:38:52,581] [Thr 140549913491200] '


==> Increase enq/server/schema above 5000000 (as of kernel version mentioned in the note 2942857)

dev_enq_server (from ASCS work folder or from SMENQ ==> Sever Administration ==> Diagnosis ==> Developer Trace)

[2020-06-08-18:48:07,234] [Thr 140549917718272] *** WARNING => EnqServer: invalid size (2000000 => 6000000) [EnqEnqueueSe 1430] |
[2020-06-08-18:48:07,234] [Thr 140549917718272] *** ERROR => EnqServer: failed to set parameter 'enq/server/schema' by client/user '<client>/<user>' [EnqEnqueueSe 1461] |

Case 2.

==>Decrease  enq/server/schema from current higher value to a new low value.

dev_enq_server

|89 |[2020-06-08-18:39:05,683] [Thr 140549909792512] *** WARNING => EnqServer: invalid size (2000000 => 250000) [EnqEnqueueSe 1430] |
|90 |[2020-06-08-18:39:05,683] [Thr 140549909792512] *** ERROR => EnqServer: failed to set parameter 'enq/server/schema' by client/user '<client>/<user>' [EnqEnqueueSe 1461] |
|91 |[2020-06-08-18:50:23,085] [Thr 140549912962816] *** WARNING => EnqServer: invalid size (2000000 => 250000) [EnqEnqueueSe 1430] |
|92 |[2020-06-08-18:50:23,085] [Thr 140549912962816] *** ERROR => EnqServer: failed to set parameter 'enq/server/schema' by client/user '<client>/<user>' [EnqEnqueueSe 1461] 


Read more...

Environment

System runs with ENSA 2.0 (Standalone enqueue server 2), you'll find following parameters from DEFAULT.PFL 
  enq/enable = TRUE
  enque/process_location = REMOTESA
  enq/serverhost = <enqueue server 2 host>
  enq/serverinst = <instance number>

Keywords

ASCS, enque, ENSA2, Standalone Enqueue Server 2, enq/enable, dynamic, SCS, enque table size,
enq/server/schema, enq/server/schema_0, Schema0

, KBA , BC-CST-EQ , Enqueue , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.