SHARD_ID configuration parameter

Sets the unique ID for a shard server in a shard cluster.

onconfig.std value
SHARD_ID 0
range of values
0 = Default. The database server cannot run parallel sharded queries.
1 - 65535 = The unique ID of the shard server.
takes effect
After you edit your onconfig file and restart the database server.
If the value is 0 or not set, you can set the value dynamically in your onconfig file by running the onmode -wf command.

You set the value of the SHARD_ID configuration parameter to a different number on each shard server in a shard cluster. If the value of the SHARD_ID configuration parameter is unset or set to 0 on all shard servers in the shard cluster, the shard cluster performs poorly. If the values of the SHARD_ID configuration parameter are not unique on all shard servers in a shard cluster, shard queries fail.

To reset the value if the SHARD_ID configuration parameter is set to a positive integer, edit the onconfig file and then restart the database server.


Copyright© 2019 HCL Technologies Limited