Was this helpful?
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