SHARD_ID configuration parameter

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.