Database Worksheet
The Database Worksheet defines the distributed environment for all CDDSs in your replication scheme. The following table describes the guidelines for filling in the Database Worksheet.
Value | Guidelines | |
|---|---|---|
Database Number | This number is an enterprise-wide unique integer in the range of 1-32,767. Assign database numbers carefully; Priority Resolution and Last Write Wins collision modes can use the database number as the basis for deciding priority when resolving collisions. We recommend assigning database numbers in increments of ten, so that new databases can be added in between the original ones. | |
Database Vnode/Name | Database names must follow DBMS guidelines; Ingres Replicator does not impose further restrictions. The vnode is the Ingres Net virtual node name for the database. For more information on vnodes, see the Connectivity Guide. | |
Database Owner | The owner (DBA) of the database. | |
DBMS Type | The DBMS Type can be any one of the following: | |
CA-Datacom/DB CA-IDMS IBM DB2 IBM DB2 UDB IMS Ingres | Microsoft SQL Server Oracle OpenVMS RMS Star Sybase VSAM | |
For more DBMS types, check the Readme file. | ||
Remarks | User-specified, up to 80 characters. | |
The following is an example of a Database Worksheet.
The following figure illustrates a completed Database Worksheet.
Last modified date: 01/30/2023