Assigning unique identification numbers to each database

You must assign a different identification number to each remote database. You can create and distribute the identification numbers by a variety of means. One method is to place the values in a table and download the correct row to each database based on some other unique property, such as user name.

Using the global_database_id option

The public option global_database_id in each database must be set to a unique, non-negative integer. The range of default values for a particular database is pn + 1 to p(n + 1), where p is the partition size and n is the value of the public option global_database_id. For example, if the partition size is 1000 and global_database_id is set to 3, then the range is from 3001 to 4000.

When global_database_id is set to a non-negative integer, SQL Anywhere chooses default values by applying the following rules:

When the column contains no values in the current partition, the first default value is pn + 1.
When the column contains values in the current partition, but all are less than p(n + 1), the next default value is one greater than the previous maximum value in this range.
Default column values are not affected by values in the column outside the current partition; that is, by numbers less than pn + 1 or greater than p(n + 1). Such values may be present if they have been replicated from another database via MobiLink synchronization.

If the public option global_database_id is set to the default value of 2147483647, a null value is inserted into the column. Should null values not be permitted, the attempt to insert the row causes an error. This situation arises, for example, when the column is contained in the table's primary key.

Because the public option global_database_id cannot be set to negative values, the values chosen are always positive. The maximum identification number is restricted only by the column data type and the partition size.

Null default values are also generated when the supply of values within the partition has been exhausted. In this example, a new value of global_database_id should be assigned to the database to allow default values to be chosen from another partition. Attempting to insert the null value causes an error when the column does not permit nulls. To detect that the supply of unused values is low and handle this condition, create an event of type GlobalAutoincrement. See Declaring DEFAULT GLOBAL AUTOINCREMENT.

Should the values in a particular partition become exhausted, you can assign a new database ID to that database. You can assign new database ID numbers in any convenient manner. However, one possible technique is to maintain a pool of unused database ID values. This pool is maintained in the same manner as a pool of primary keys. See Using primary key pools.

You can set an event handler to automatically notify the database administrator (or do some other action) when the partition is nearly exhausted. See Defining trigger conditions for events.

Assigning unique identification numbers to each database

Using the global_database_id option

See also