Setting the GLOBAL_DATABASE

Setting unique database identification numbers when extracting databases

MobiLink Synchronization User's Guide
  Synchronization Techniques
    Maintaining unique primary keys
      Maintaining unique primary keys using global autoincrement

Setting the GLOBAL_DATABASE_ID value

When deploying an application, you must assign a different identification number to each database. You can accomplish the task of creating and distributing 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.

To set the global database identification number

You set the identification number of a database by setting the value of the public option GLOBAL_DATABASE_ID. The identification number must be a non-negative integer.

Example

For example, the following statement sets the database identification number to 20.

SET OPTION PUBLIC.GLOBAL_DATABASE_ID = 20

If the partition size for a particular column is 5000, default values for this database are selected from the range 100001-105000.